|
SIGNAL_TIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
CURRENT TIMESTAMP |
|
|
SIGNAL_TYPE |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
SIGNAL_SUBTYPE |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
SIGNAL_INPUT_IN |
VARCHAR |
500 |
0 |
1251 |
|
|
|
|
|
SIGNAL_STATE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
SIGNAL_LSN |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
Total: 6 column(s)
Total: 1 index(s)
|
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)
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);
List of tables