Please see the example:
/home/db2admin> db2sampl -v8 -dbpath /home/db2admin/sample8 -name sample8 -verbose
Creating database "sample8" on path "/home/db2admin/sample8"...
Connecting to database "sample8"...
Creating tables and data in schema "DB2ADMIN"...
'db2sampl' processing complete.
Note: the tables do not have PK; you may manually create them using:
ALTER TABLE "ORG" ADD PRIMARY KEY ("DEPTNUMB");
ALTER TABLE "STAFF" ADD PRIMARY KEY ("ID");
ALTER TABLE "DEPARTMENT" ADD PRIMARY KEY ("DEPTNO");
ALTER TABLE "EMPLOYEE" ADD PRIMARY KEY ("EMPNO");
ALTER TABLE "PROJECT" ADD PRIMARY KEY ("PROJNO");
ALTER TABLE "EMP_PHOTO" ADD PRIMARY KEY ("EMPNO", "PHOTO_FORMAT");
ALTER TABLE "EMP_RESUME" ADD PRIMARY KEY ("EMPNO", "RESUME_FORMAT");
添加新评论0 条评论