How to rebuild DATABASE by shell script? Could you give me some sample scripts for it?

~ 0 min
2016-02-02 11:21

Please refer the ${dbmaker_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;

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags