Properties

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

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  APPLY_QUAL  CHARACTER  18  1251         
  APPLY_PATH  VARCHAR  1040  1251         
  COPYONCE  CHARACTER  1251      'N'   
  DELAY  INTEGER       
  ERRWAIT  INTEGER      300   
  INAMSG  CHARACTER  1251      'Y'   
  LOADXIT  CHARACTER  1251      'N'   
  LOGREUSE  CHARACTER  1251      'N'   
  LOGSTDOUT  CHARACTER  1251      'N'   
  NOTIFY  CHARACTER  1251      'N'   
  OPT4ONE  CHARACTER  1251      'N'   
  SLEEP  CHARACTER  1251      'Y'   
  SQLERRCONTINUE  CHARACTER  1251      'N'   
  SPILLFILE  VARCHAR  10  1251      'DISK'   
  TERM  CHARACTER  1251      'Y'   
  TRLREUSE  CHARACTER  1251      'N'   
Total: 16 column(s)

Indexes

Name Unique rule Type Colnames Description
  ASN.IBMSNAP_APPPARMSX  UNIQUE  REGULAR  APPLY_QUAL   
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_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);

See Also

List of tables