zOs/SQL/CRETAQQ

  set current sqlid = 's100447';
  CREATE TABLESPACE A051A
    IN dgdb9998
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 7200
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
------------------------------------------------------------------------
--    Table=gdb9998.TQQ051A In dgdb9998.A051A
------------------------------------------------------------------------
--
  CREATE TABLE gdb9998.TQQ051A
     (QQ051ID              CHAR(10) FOR SBCS DATA NOT NULL,
      QQ051TXT             CHAR(20) FOR SBCS DATA WITH DEFAULT NULL,
      QQ051FOR             CHAR(10) FOR SBCS DATA WITH DEFAULT NULL
     )
    IN dgdb9998.A051A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;

  CREATE view gdb9998.VQQ051V1 as select * from gdb9998.TQQ051A;
  CREATE view gdb9998.VQQ051V2 as select * from gdb9998.TQQ051A;
--
--
------------------------------------------------------------------------
-- Database=dgdb9998
--    Index=gdb9998.IQQ051A0 On gdb9998.TQQ051A
------------------------------------------------------------------------
--
  CREATE UNIQUE INDEX gdb9998.Iqq051A0
    ON gdb9998.Tqq051A
     (QQ051ID               ASC)
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 7200
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;