Properties

Name: CDSTAFF 
Schema: USER 
Status: NORMAL 
Create time: 01.07.2006 
Tablespace: TSCDSTAFF 
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_COMMITSEQ  CHARACTER  10         
  IBMSNAP_INTENTSEQ  CHARACTER  10         
  IBMSNAP_OPERATION  CHARACTER  1251         
  ID  SMALLINT         
  NAME  VARCHAR  1251         
  DEPT  SMALLINT         
  JOB  CHARACTER  1251         
  YEARS  SMALLINT         
  SALARY  DECIMAL         
  COMM  DECIMAL         
Total: 10 column(s)

Indexes

Name Unique rule Type Colnames Description
  USER.IXCDSTAFF  UNIQUE  REGULAR  IBMSNAP_COMMITSEQ, IBMSNAP_INTENTSEQ   
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 "USER    "."CDSTAFF"  (
          "IBMSNAP_COMMITSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
          "IBMSNAP_INTENTSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
          "IBMSNAP_OPERATION" CHAR(1) NOT NULL ,
          "ID" SMALLINT NOT NULL ,
          "NAME" VARCHAR(9) ,
          "DEPT" SMALLINT ,
          "JOB" CHAR(5) ,
          "YEARS" SMALLINT ,
          "SALARY" DECIMAL(7,2) ,
          "COMM" DECIMAL(7,2) )  
         IN "TSCDSTAFF" ;

ALTER TABLE "USER    "."CDSTAFF" VOLATILE CARDINALITY;


CREATE UNIQUE INDEX "USER    "."IXCDSTAFF" ON "USER    "."CDSTAFF"
        ("IBMSNAP_COMMITSEQ" ASC,
         "IBMSNAP_INTENTSEQ" ASC)
        PCTFREE 0 ;

See Also

List of tables