|
IBMSNAP_UOWID |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
IBMSNAP_COMMITSEQ |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
IBMSNAP_LOGMARKER |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
IBMSNAP_AUTHTKN |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
IBMSNAP_AUTHID |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
IBMSNAP_REJ_CODE |
CHARACTER |
1 |
0 |
1251 |
|
|
' ' |
|
|
IBMSNAP_APPLY_QUAL |
CHARACTER |
18 |
0 |
1251 |
|
|
' ' |
|
Total: 7 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_UOW" (
"IBMSNAP_UOWID" CHAR(10) FOR BIT DATA NOT NULL ,
"IBMSNAP_COMMITSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"IBMSNAP_LOGMARKER" TIMESTAMP NOT NULL ,
"IBMSNAP_AUTHTKN" VARCHAR(30) NOT NULL ,
"IBMSNAP_AUTHID" VARCHAR(30) NOT NULL ,
"IBMSNAP_REJ_CODE" CHAR(1) NOT NULL WITH DEFAULT ,
"IBMSNAP_APPLY_QUAL" CHAR(18) NOT NULL WITH DEFAULT )
IN "TSASNUOW" ;
ALTER TABLE "ASN "."IBMSNAP_UOW" VOLATILE CARDINALITY;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_UOWX" ON "ASN "."IBMSNAP_UOW"
("IBMSNAP_COMMITSEQ" ASC,
"IBMSNAP_LOGMARKER" ASC);
List of tables