|
APPLY_QUAL |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
SET_NAME |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
WHOS_ON_FIRST |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
BEFORE_OR_AFTER |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
STMT_NUMBER |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
EI_OR_CALL |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
SQL_STMT |
VARCHAR |
1024 |
0 |
1251 |
|
|
|
|
|
ACCEPT_SQLSTATES |
VARCHAR |
50 |
0 |
1251 |
|
|
|
|
Total: 8 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_SUBS_STMTS" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"WHOS_ON_FIRST" CHAR(1) NOT NULL ,
"BEFORE_OR_AFTER" CHAR(1) NOT NULL ,
"STMT_NUMBER" SMALLINT NOT NULL ,
"EI_OR_CALL" CHAR(1) NOT NULL ,
"SQL_STMT" VARCHAR(1024) ,
"ACCEPT_SQLSTATES" VARCHAR(50) )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_STMTX" ON "ASN "."IBMSNAP_SUBS_STMTS"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"BEFORE_OR_AFTER" ASC,
"STMT_NUMBER" ASC);
List of tables