|
AGENT_ID |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
APPL_ID |
CHARACTER |
32 |
0 |
1251 |
|
|
|
|
|
APPL_NAME |
VARCHAR |
255 |
0 |
1251 |
|
|
|
|
|
AUTH_ID |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
CLIENT_DB_ALIAS |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
|
CLIENT_NNAME |
VARCHAR |
20 |
0 |
1251 |
|
|
|
|
|
CLIENT_PID |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CLIENT_PLATFORM |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
CLIENT_PRDID |
VARCHAR |
20 |
0 |
1251 |
|
|
|
|
|
CLIENT_PROTOCOL |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
CODEPAGE_ID |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
CONN_TIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
CORR_TOKEN |
CHARACTER |
32 |
0 |
1251 |
|
|
|
|
|
EXECUTION_ID |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
SEQUENCE_NO |
CHARACTER |
4 |
0 |
1251 |
|
|
|
|
|
TERRITORY_CODE |
INTEGER |
4 |
0 |
0 |
|
|
|
|
Total: 16 column(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 "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" ;
List of tables