|
APPLY_QUAL |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
SET_NAME |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
WHOS_ON_FIRST |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
TARGET_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
TARGET_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
COL_TYPE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
TARGET_NAME |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
IS_KEY |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
COLNO |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
EXPRESSION |
VARCHAR |
254 |
0 |
1251 |
|
|
|
|
Total: 10 column(s)
|
ASN.IBMSNAP_SUBS_COLSX |
UNIQUE |
REGULAR |
APPLY_QUAL, SET_NAME, WHOS_ON_FIRST, TARGET_OWNER, TARGET_TABLE, TARGET_NAME |
|
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_COLS" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"WHOS_ON_FIRST" CHAR(1) NOT NULL ,
"TARGET_OWNER" VARCHAR(30) NOT NULL ,
"TARGET_TABLE" VARCHAR(128) NOT NULL ,
"COL_TYPE" CHAR(1) NOT NULL ,
"TARGET_NAME" VARCHAR(30) NOT NULL ,
"IS_KEY" CHAR(1) NOT NULL ,
"COLNO" SMALLINT NOT NULL ,
"EXPRESSION" VARCHAR(254) NOT NULL )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_COLSX" ON "ASN "."IBMSNAP_SUBS_COLS"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"TARGET_OWNER" ASC,
"TARGET_TABLE" ASC,
"TARGET_NAME" ASC);
List of tables