|
APPLY_QUAL |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
MEMBER |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
INTENTSEQ |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
OPERATION |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
Total: 4 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 "ASN "."IBMSNAP_COMPENSATE" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"MEMBER" SMALLINT NOT NULL ,
"INTENTSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"OPERATION" CHAR(1) NOT NULL )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_COMPENSATX" ON "ASN "."IBMSNAP_COMPENSATE"
("APPLY_QUAL" ASC,
"MEMBER" ASC);
List of tables