Properties

Name: CONNHEADER_XXXXX 
Schema: USER 
Status: NORMAL 
Create time: 01.07.2006 
Tablespace: USERSPACE1 
Index tablespace:  
Long tablespace:  
Base table schema:  
Base table:  
Rowtype schema:  
Rowtype name:  
Description:  

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  AGENT_ID  BIGINT         
  APPL_ID  CHARACTER  32  1251         
  APPL_NAME  VARCHAR  255  1251         
  AUTH_ID  VARCHAR  30  1251         
  CLIENT_DB_ALIAS  CHARACTER  1251         
  CLIENT_NNAME  VARCHAR  20  1251         
  CLIENT_PID  BIGINT         
  CLIENT_PLATFORM  INTEGER         
  CLIENT_PRDID  VARCHAR  20  1251         
  CLIENT_PROTOCOL  INTEGER         
  CODEPAGE_ID  INTEGER         
  CONN_TIME  TIMESTAMP  10         
  CORR_TOKEN  CHARACTER  32  1251         
  EXECUTION_ID  VARCHAR  30  1251         
  SEQUENCE_NO  CHARACTER  1251         
  TERRITORY_CODE  INTEGER         
Total: 16 column(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    "."CONNHEADER_XXXXX"  (
          "AGENT_ID" BIGINT NOT NULL ,
          "APPL_ID" CHAR(32) NOT NULL ,
          "APPL_NAME" VARCHAR(255) NOT NULL ,
          "AUTH_ID" VARCHAR(30) NOT NULL ,
          "CLIENT_DB_ALIAS" CHAR(8) NOT NULL ,
          "CLIENT_NNAME" VARCHAR(20) NOT NULL ,
          "CLIENT_PID" BIGINT NOT NULL ,
          "CLIENT_PLATFORM" INTEGER NOT NULL ,
          "CLIENT_PRDID" VARCHAR(20) NOT NULL ,
          "CLIENT_PROTOCOL" INTEGER NOT NULL ,
          "CODEPAGE_ID" INTEGER NOT NULL ,
          "CONN_TIME" TIMESTAMP NOT NULL ,
          "CORR_TOKEN" CHAR(32) NOT NULL ,
          "EXECUTION_ID" VARCHAR(30) NOT NULL ,
          "SEQUENCE_NO" CHAR(4) NOT NULL ,
          "TERRITORY_CODE" INTEGER NOT NULL )  
         IN "USERSPACE1" ;

See Also

List of tables