Properties

Name: IBMSNAP_SUBS_MEMBR 
Schema: ASN 
Status: NORMAL 
Create time: 01.07.2006 
Tablespace: TSASNAA 
Index tablespace:  
Long tablespace:  
Base table schema:  
Base table:  
Rowtype schema:  
Rowtype name:  
Description:  

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  APPLY_QUAL  CHARACTER  18  1251         
  SET_NAME  CHARACTER  18  1251         
  WHOS_ON_FIRST  CHARACTER  1251         
  SOURCE_OWNER  VARCHAR  30  1251         
  SOURCE_TABLE  VARCHAR  128  1251         
  SOURCE_VIEW_QUAL  SMALLINT         
  TARGET_OWNER  VARCHAR  30  1251         
  TARGET_TABLE  VARCHAR  128  1251         
  TARGET_CONDENSED  CHARACTER  1251         
  TARGET_COMPLETE  CHARACTER  1251         
  TARGET_STRUCTURE  SMALLINT         
  PREDICATES  VARCHAR  1024  1251         
  MEMBER_STATE  CHARACTER  1251         
  TARGET_KEY_CHG  CHARACTER  1251         
  UOW_CD_PREDICATES  VARCHAR  1024  1251         
  JOIN_UOW_CD  CHARACTER  1251         
  LOADX_TYPE  SMALLINT         
  LOADX_SRC_N_OWNER  VARCHAR  30  1251         
  LOADX_SRC_N_TABLE  VARCHAR  128  1251         
Total: 19 column(s)

Indexes

Name Unique rule Type Colnames Description
  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)

Autherisations

Grantor Grantee Authorities
  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)

SQL

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);

See Also

List of tables