|
APPLY_QUAL |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
SET_NAME |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
WHOS_ON_FIRST |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
SOURCE_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
SOURCE_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
SOURCE_VIEW_QUAL |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
TARGET_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
TARGET_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
TARGET_CONDENSED |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
TARGET_COMPLETE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
TARGET_STRUCTURE |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
PREDICATES |
VARCHAR |
1024 |
0 |
1251 |
|
|
|
|
|
MEMBER_STATE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
TARGET_KEY_CHG |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
UOW_CD_PREDICATES |
VARCHAR |
1024 |
0 |
1251 |
|
|
|
|
|
JOIN_UOW_CD |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
LOADX_TYPE |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
LOADX_SRC_N_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
LOADX_SRC_N_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
Total: 19 column(s)
|
ASN.IBMSNAP_SUBS_MEMBX |
UNIQUE |
REGULAR |
APPLY_QUAL, SET_NAME, WHOS_ON_FIRST, SOURCE_OWNER, SOURCE_TABLE, SOURCE_VIEW_QUAL, TARGET_OWNER, TARGET_TABLE |
|
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_MEMBR" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"WHOS_ON_FIRST" CHAR(1) NOT NULL ,
"SOURCE_OWNER" VARCHAR(30) NOT NULL ,
"SOURCE_TABLE" VARCHAR(128) NOT NULL ,
"SOURCE_VIEW_QUAL" SMALLINT NOT NULL ,
"TARGET_OWNER" VARCHAR(30) NOT NULL ,
"TARGET_TABLE" VARCHAR(128) NOT NULL ,
"TARGET_CONDENSED" CHAR(1) NOT NULL ,
"TARGET_COMPLETE" CHAR(1) NOT NULL ,
"TARGET_STRUCTURE" SMALLINT NOT NULL ,
"PREDICATES" VARCHAR(1024) ,
"MEMBER_STATE" CHAR(1) ,
"TARGET_KEY_CHG" CHAR(1) NOT NULL ,
"UOW_CD_PREDICATES" VARCHAR(1024) ,
"JOIN_UOW_CD" CHAR(1) ,
"LOADX_TYPE" SMALLINT ,
"LOADX_SRC_N_OWNER" VARCHAR(30) ,
"LOADX_SRC_N_TABLE" VARCHAR(128) )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_MEMBX" ON "ASN "."IBMSNAP_SUBS_MEMBR"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC,
"TARGET_OWNER" ASC,
"TARGET_TABLE" ASC);
List of tables