|
APPLY_QUAL |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
APPLY_PATH |
VARCHAR |
1040 |
0 |
1251 |
|
|
|
|
|
COPYONCE |
CHARACTER |
1 |
0 |
1251 |
|
|
'N' |
|
|
DELAY |
INTEGER |
4 |
0 |
0 |
|
|
6 |
|
|
ERRWAIT |
INTEGER |
4 |
0 |
0 |
|
|
300 |
|
|
INAMSG |
CHARACTER |
1 |
0 |
1251 |
|
|
'Y' |
|
|
LOADXIT |
CHARACTER |
1 |
0 |
1251 |
|
|
'N' |
|
|
LOGREUSE |
CHARACTER |
1 |
0 |
1251 |
|
|
'N' |
|
|
LOGSTDOUT |
CHARACTER |
1 |
0 |
1251 |
|
|
'N' |
|
|
NOTIFY |
CHARACTER |
1 |
0 |
1251 |
|
|
'N' |
|
|
OPT4ONE |
CHARACTER |
1 |
0 |
1251 |
|
|
'N' |
|
|
SLEEP |
CHARACTER |
1 |
0 |
1251 |
|
|
'Y' |
|
|
SQLERRCONTINUE |
CHARACTER |
1 |
0 |
1251 |
|
|
'N' |
|
|
SPILLFILE |
VARCHAR |
10 |
0 |
1251 |
|
|
'DISK' |
|
|
TERM |
CHARACTER |
1 |
0 |
1251 |
|
|
'Y' |
|
|
TRLREUSE |
CHARACTER |
1 |
0 |
1251 |
|
|
'N' |
|
Total: 16 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_APPPARMS" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"APPLY_PATH" VARCHAR(1040) ,
"COPYONCE" CHAR(1) WITH DEFAULT 'N' ,
"DELAY" INTEGER WITH DEFAULT 6 ,
"ERRWAIT" INTEGER WITH DEFAULT 300 ,
"INAMSG" CHAR(1) WITH DEFAULT 'Y' ,
"LOADXIT" CHAR(1) WITH DEFAULT 'N' ,
"LOGREUSE" CHAR(1) WITH DEFAULT 'N' ,
"LOGSTDOUT" CHAR(1) WITH DEFAULT 'N' ,
"NOTIFY" CHAR(1) WITH DEFAULT 'N' ,
"OPT4ONE" CHAR(1) WITH DEFAULT 'N' ,
"SLEEP" CHAR(1) WITH DEFAULT 'Y' ,
"SQLERRCONTINUE" CHAR(1) WITH DEFAULT 'N' ,
"SPILLFILE" VARCHAR(10) WITH DEFAULT 'DISK' ,
"TERM" CHAR(1) WITH DEFAULT 'Y' ,
"TRLREUSE" CHAR(1) WITH DEFAULT 'N' )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_APPPARMSX" ON "ASN "."IBMSNAP_APPPARMS"
("APPLY_QUAL" ASC);
List of tables