zOs/SQL/RUSCH18

SET CURRENT SQLID = 'S100447';
CREATE       TABLESPACE A018T    IN SV01A1L
       USING STOGROUP GSMS
             PRIQTY 48
             SECQTY 7200
             ERASE NO
             FREEPAGE   0
             PCTFREE 10
             COMPRESS YES
             GBPCACHE CHANGED
             TRACKMOD YES
       BUFFERPOOL BP2
       LOCKSIZE ANY
       LOCKMAX SYSTEM
       CCSID EBCDIC
       MAXROWS 255
       CLOSE YES
       SEGSIZE 64
                                                                      ;
CREATE TABLE    OA1L.TSV018T1
   (SV01801U CHAR(20)                            NOT NULL             ,
    SV01801N TIMESTAMP                           NOT NULL             ,
    SV01802 SMALLINT                             NOT NULL             ,
    SV01806 CHAR(20)                             NOT NULL             ,
    SV01807 CHAR(12)                             NOT NULL             ,
    SV01808 CHAR(3)                              NOT NULL             ,
    SV01809A CHAR(1)                             NOT NULL             ,
    SV01809B CHAR(2)                             NOT NULL             ,
    SV01809C SMALLINT                            NOT NULL             ,
    SV01810 SMALLINT                             NOT NULL             ,
    SV01811 SMALLINT                             NOT NULL             ,
    SV01812 CHAR(20)                             NOT NULL             ,
    SV01813 CHAR(20)                             NOT NULL             ,
    SV01814A CHAR(1)                             NOT NULL             ,
    SV01814B DATE                                NOT NULL             ,
    SV01815A CHAR(1)                             NOT NULL             ,
    SV01815B DATE                                NOT NULL             ,
    SV01816A CHAR(1)                             NOT NULL             ,
    SV01816B DATE                                NOT NULL             ,
    SV01817A CHAR(1)                             NOT NULL             ,
    SV01817B CHAR(4)                             NOT NULL             ,
    SV01818 CHAR(1)                              NOT NULL             ,
    SV01819A CHAR(1)                             NOT NULL             ,
    SV01819B SMALLINT                            NOT NULL             ,
    SV01820 SMALLINT                             NOT NULL             ,
    SV01821 TIMESTAMP                            NOT NULL             ,
    SV01822 CHAR(20)                             NOT NULL             ,
    SV01823 DATE                                 NOT NULL             ,
    SV01824 CHAR(7)                              NOT NULL             ,
    SV01825 CHAR(4)                              NOT NULL             ,
    SV01826 CHAR(16)                             NOT NULL             ,
    SV01827 CHAR(16)                             NOT NULL             ,
    SV01890 CHAR(11)                             NOT NULL             ,
    SV01891 CHAR(10)                             NOT NULL             ,
    SV01892 CHAR(10)                             NOT NULL             ,
    SV01893 DATE                                 NOT NULL             ,
    SV01894 DATE                                 NOT NULL             ,
    SV01895 DATE                                 NOT NULL             ,
    SV01896 SMALLINT                             NOT NULL             ,
    SV01897 SMALLINT                             NOT NULL             ,
    SV01898 SMALLINT                             NOT NULL             ,
    SV01899 SMALLINT                             NOT NULL
                                                                      )
       IN SV01A1L.A018T
       AUDIT NONE
       CCSID EBCDIC
                                                                      ;
CREATE INDEX OA1L.ISV018T1
       ON OA1L.TSV018T1
     ( SV01807              ASC  )
       USING STOGROUP GSMS
             PRIQTY      48
             SECQTY    7200
       ERASE NO
       FREEPAGE  10
       PCTFREE 10
       GBPCACHE CHANGED
       BUFFERPOOL BP1
       CLOSE YES
       PIECESIZE 2       G
       COPY NO
;