怎样通过shell script rebuild数据库?能给一些示例吗?

~ 0 min
2016-01-28 10:46

请参考${dbmaster_home}\samples\DATABASE\init.sql.

                  CREATE DB DBSAMPLE4;

   CREATE TABLE SYSADM.Card ( NumSERIAL(1) PRIMARY KEY,FirstName                  VARCHAR(30), LastName VARCHAR(30),TitleVARCHAR(30), BMp LONG                     VARBINARY) IN DEFTABLESPACE;

INSERT INTO SYSADM.Card VALUES (?,?,?,?,?) ;

1, 'Eddie', 'Chang', 'Manager', &data1.b0(0,6666);

2, 'Hook', 'Hu', 'Software Engineer', &data1.b0(6666,6666);

3, 'Jackie', 'Yu', 'Software Engineer', &data1.b0(13332,6666);

4, 'Ray', 'Sung', 'Software Engineer', &data1.b0(19998,6666);

5, 'Louis', 'Liu', 'Software Engineer', &data1.b0(26664,6666);

6, 'Trent', 'Clowater', 'Software Engineer', &data1.b0(33330,6666);

7, 'Oscar', 'Tseng', 'Software Engineer', &data1.b0(39996,6666);

8, 'Jerry', 'Liu', 'Manager', &data1.b0(46662,6666);

END;

平均分: 0 (0 投票)

你不能对该内容发表评论

标签