|
IBMSNAP_COMMITSEQ |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
IBMSNAP_INTENTSEQ |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
IBMSNAP_OPERATION |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
ID |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
NAME |
VARCHAR |
9 |
0 |
1251 |
|
|
|
|
|
DEPT |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
JOB |
CHARACTER |
5 |
0 |
1251 |
|
|
|
|
|
YEARS |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
SALARY |
DECIMAL |
7 |
2 |
0 |
|
|
|
|
|
COMM |
DECIMAL |
7 |
2 |
0 |
|
|
|
|
Total: 10 column(s)
Total: 1 index(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 "."CDSTAFF" (
"IBMSNAP_COMMITSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"IBMSNAP_INTENTSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"IBMSNAP_OPERATION" CHAR(1) NOT NULL ,
"ID" SMALLINT NOT NULL ,
"NAME" VARCHAR(9) ,
"DEPT" SMALLINT ,
"JOB" CHAR(5) ,
"YEARS" SMALLINT ,
"SALARY" DECIMAL(7,2) ,
"COMM" DECIMAL(7,2) )
IN "TSCDSTAFF" ;
ALTER TABLE "USER "."CDSTAFF" VOLATILE CARDINALITY;
CREATE UNIQUE INDEX "USER "."IXCDSTAFF" ON "USER "."CDSTAFF"
("IBMSNAP_COMMITSEQ" ASC,
"IBMSNAP_INTENTSEQ" ASC)
PCTFREE 0 ;
List of tables