Properties

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

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  IBMSNAP_UOWID  CHARACTER  10         
  IBMSNAP_COMMITSEQ  CHARACTER  10         
  IBMSNAP_LOGMARKER  TIMESTAMP  10         
  IBMSNAP_AUTHTKN  VARCHAR  30  1251         
  IBMSNAP_AUTHID  VARCHAR  30  1251         
  IBMSNAP_REJ_CODE  CHARACTER  1251      ' '   
  IBMSNAP_APPLY_QUAL  CHARACTER  18  1251      ' '   
Total: 7 column(s)

Indexes

Name Unique rule Type Colnames Description
  ASN.IBMSNAP_UOWX  UNIQUE  REGULAR  IBMSNAP_COMMITSEQ, IBMSNAP_LOGMARKER   
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_UOW"  (
          "IBMSNAP_UOWID" CHAR(10) FOR BIT DATA NOT NULL ,
          "IBMSNAP_COMMITSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
          "IBMSNAP_LOGMARKER" TIMESTAMP NOT NULL ,
          "IBMSNAP_AUTHTKN" VARCHAR(30) NOT NULL ,
          "IBMSNAP_AUTHID" VARCHAR(30) NOT NULL ,
          "IBMSNAP_REJ_CODE" CHAR(1) NOT NULL WITH DEFAULT  ,
          "IBMSNAP_APPLY_QUAL" CHAR(18) NOT NULL WITH DEFAULT  )  
         IN "TSASNUOW" ;

ALTER TABLE "ASN     "."IBMSNAP_UOW" VOLATILE CARDINALITY;


CREATE UNIQUE INDEX "ASN     "."IBMSNAP_UOWX" ON "ASN     "."IBMSNAP_UOW"
        ("IBMSNAP_COMMITSEQ" ASC,
         "IBMSNAP_LOGMARKER" ASC);

See Also

List of tables