|
SOURCE_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
SOURCE_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
SOURCE_VIEW_QUAL |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
GLOBAL_RECORD |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
SOURCE_STRUCTURE |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
SOURCE_CONDENSED |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
SOURCE_COMPLETE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
CD_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
CD_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
PHYS_CHANGE_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
PHYS_CHANGE_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
CD_OLD_SYNCHPOINT |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
CD_NEW_SYNCHPOINT |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
DISABLE_REFRESH |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
CCD_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
CCD_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
CCD_OLD_SYNCHPOINT |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
SYNCHPOINT |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
SYNCHTIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
CCD_CONDENSED |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
CCD_COMPLETE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
ARCH_LEVEL |
CHARACTER |
4 |
0 |
1251 |
|
|
|
|
|
DESCRIPTION |
CHARACTER |
254 |
0 |
1251 |
|
|
|
|
|
BEFORE_IMG_PREFIX |
VARCHAR |
4 |
0 |
1251 |
|
|
|
|
|
CONFLICT_LEVEL |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
CHG_UPD_TO_DEL_INS |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
CHGONLY |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
RECAPTURE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
OPTION_FLAGS |
CHARACTER |
4 |
0 |
1251 |
|
|
|
|
|
STOP_ON_ERROR |
CHARACTER |
1 |
0 |
1251 |
|
|
'Y' |
|
|
STATE |
CHARACTER |
1 |
0 |
1251 |
|
|
'I' |
|
|
STATE_INFO |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
Total: 32 column(s)
Total: 3 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_REGISTER" (
"SOURCE_OWNER" VARCHAR(30) NOT NULL ,
"SOURCE_TABLE" VARCHAR(128) NOT NULL ,
"SOURCE_VIEW_QUAL" SMALLINT NOT NULL ,
"GLOBAL_RECORD" CHAR(1) NOT NULL ,
"SOURCE_STRUCTURE" SMALLINT NOT NULL ,
"SOURCE_CONDENSED" CHAR(1) NOT NULL ,
"SOURCE_COMPLETE" CHAR(1) NOT NULL ,
"CD_OWNER" VARCHAR(30) ,
"CD_TABLE" VARCHAR(128) ,
"PHYS_CHANGE_OWNER" VARCHAR(30) ,
"PHYS_CHANGE_TABLE" VARCHAR(128) ,
"CD_OLD_SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"CD_NEW_SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"DISABLE_REFRESH" SMALLINT NOT NULL ,
"CCD_OWNER" VARCHAR(30) ,
"CCD_TABLE" VARCHAR(128) ,
"CCD_OLD_SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SYNCHTIME" TIMESTAMP ,
"CCD_CONDENSED" CHAR(1) ,
"CCD_COMPLETE" CHAR(1) ,
"ARCH_LEVEL" CHAR(4) NOT NULL ,
"DESCRIPTION" CHAR(254) ,
"BEFORE_IMG_PREFIX" VARCHAR(4) ,
"CONFLICT_LEVEL" CHAR(1) ,
"CHG_UPD_TO_DEL_INS" CHAR(1) ,
"CHGONLY" CHAR(1) ,
"RECAPTURE" CHAR(1) ,
"OPTION_FLAGS" CHAR(4) NOT NULL ,
"STOP_ON_ERROR" CHAR(1) WITH DEFAULT 'Y' ,
"STATE" CHAR(1) WITH DEFAULT 'I' ,
"STATE_INFO" CHAR(8) )
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_REGISTERX" ON "ASN "."IBMSNAP_REGISTER"
("SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC);
CREATE INDEX "ASN "."IBMSNAP_REGISTERX1" ON "ASN "."IBMSNAP_REGISTER"
("PHYS_CHANGE_OWNER" ASC,
"PHYS_CHANGE_TABLE" ASC);
CREATE INDEX "ASN "."IBMSNAP_REGISTERX2" ON "ASN "."IBMSNAP_REGISTER"
("GLOBAL_RECORD" ASC);
List of tables