SET CURRENT SQLID = 'S100447';
CREATE TABLESPACE A120T IN SV10A1L
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.TSV120T1
(SV12001T INTEGER NOT NULL ,
SV12001N TIMESTAMP NOT NULL ,
SV12002 SMALLINT NOT NULL ,
SV12003 CHAR(4) NOT NULL ,
SV12004 DATE NOT NULL ,
SV12005 DATE NOT NULL ,
SV12006 CHAR(3) NOT NULL ,
SV12007 CHAR(12) NOT NULL ,
SV12008 CHAR(4) NOT NULL ,
SV12010 CHAR(20) NOT NULL ,
SV12011 SMALLINT NOT NULL ,
SV12012 CHAR(1) NOT NULL ,
SV12013 SMALLINT NOT NULL ,
SV12014 CHAR(1) NOT NULL ,
SV12015 CHAR(1) NOT NULL ,
SV12016 SMALLINT NOT NULL ,
SV12017 TIMESTAMP NOT NULL ,
SV12018 CHAR(7) NOT NULL ,
SV12019 CHAR(20) NOT NULL ,
SV12020 DATE NOT NULL ,
SV12022 CHAR(12) NOT NULL ,
SV12023 CHAR(10) NOT NULL ,
SV12024 CHAR(10) NOT NULL ,
SV12025 CHAR(10) NOT NULL ,
SV12026 CHAR(10) NOT NULL ,
SV12027 CHAR(10) NOT NULL ,
SV12028 CHAR(10) NOT NULL ,
SV12029 CHAR(10) NOT NULL ,
SV12030 CHAR(10) NOT NULL ,
SV12031 CHAR(10) NOT NULL
)
IN SV10A1L.A120T
AUDIT NONE
CCSID EBCDIC
;
CREATE INDEX OA1L.ISV120T1
ON OA1L.TSV120T1
( SV12007 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