|
PROJNO |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
|
PROJNAME |
VARCHAR |
24 |
0 |
1251 |
|
|
|
|
|
DEPTNO |
CHARACTER |
3 |
0 |
1251 |
|
|
|
|
|
RESPEMP |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
|
PRSTAFF |
DECIMAL |
5 |
2 |
0 |
|
|
|
|
|
PRSTDATE |
DATE |
4 |
0 |
0 |
|
|
|
|
|
PRENDATE |
DATE |
4 |
0 |
0 |
|
|
|
|
|
MAJPROJ |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
Total: 8 column(s)
|
SYSIBM |
USER |
CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
Total: 1 autherisation(s)
CREATE TABLE "USER "."PROJECT" (
"PROJNO" CHAR(6) NOT NULL ,
"PROJNAME" VARCHAR(24) NOT NULL ,
"DEPTNO" CHAR(3) NOT NULL ,
"RESPEMP" CHAR(6) NOT NULL ,
"PRSTAFF" DECIMAL(5,2) ,
"PRSTDATE" DATE ,
"PRENDATE" DATE ,
"MAJPROJ" CHAR(6) )
IN "USERSPACE1" ;
List of tables