Properties

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

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  SIGNAL_TIME  TIMESTAMP  10      CURRENT TIMESTAMP   
  SIGNAL_TYPE  VARCHAR  30  1251         
  SIGNAL_SUBTYPE  VARCHAR  30  1251         
  SIGNAL_INPUT_IN  VARCHAR  500  1251         
  SIGNAL_STATE  CHARACTER  1251         
  SIGNAL_LSN  CHARACTER  10         
Total: 6 column(s)

Indexes

Name Unique rule Type Colnames Description
  ASN.IBMSNAP_SIGNALX  UNIQUE  REGULAR  SIGNAL_TIME   
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_SIGNAL"  (
          "SIGNAL_TIME" TIMESTAMP NOT NULL WITH DEFAULT  ,
          "SIGNAL_TYPE" VARCHAR(30) NOT NULL ,
          "SIGNAL_SUBTYPE" VARCHAR(30) ,
          "SIGNAL_INPUT_IN" VARCHAR(500) ,
          "SIGNAL_STATE" CHAR(1) NOT NULL ,
          "SIGNAL_LSN" CHAR(10) FOR BIT DATA )  
         DATA CAPTURE CHANGES  
         IN "TSASNCA" ;

CREATE UNIQUE INDEX "ASN     "."IBMSNAP_SIGNALX" ON "ASN     "."IBMSNAP_SIGNAL"
        ("SIGNAL_TIME" ASC);

See Also

List of tables