zOs/SQL/YVV326WD

SET CURRENT SQLID = 'S100447';
    CREATE TABLESPACE VV425
           IN DA540769
           BUFFERPOOL BP2
           DSSIZE 32G
           CLOSE YES
           LOCKMAX SYSTEM
           SEGSIZE 0
           DEFINE YES
           LOGGED
           LOCKSIZE PAGE
           MAXROWS 255
           CCSID EBCDIC
           NUMPARTS 10
                     USING STOGROUP "GSMS    "
                                    PRIQTY -1
                                    SECQTY -1
                                    ERASE NO
                     PCTFREE 5
                     FREEPAGE 50
                     GBPCACHE CHANGED
                     COMPRESS YES
                     TRACKMOD YES
;

 SET CURRENT SQLID = 'S100447';


    CREATE TABLE A540769.QZSCANKEY
        (PARTITION_NUMBER SMALLINT
                                                        NOT NULL
        ,TEMP_DBKEY INTEGER
                                                        NOT NULL
        ,OUT_IDSYMBOL_2 CHARACTER(30) FOR SBCS DATA
  WITH DEFAULT NULL
        ,OUT_IDSYMBOL_3 CHARACTER(30) FOR SBCS DATA
  WITH DEFAULT NULL
        ,STATUS_FLAG SMALLINT
  WITH DEFAULT NULL
        ,IS_ACTIVE SMALLINT
  WITH DEFAULT NULL
        ,CREATETIMESTAMP VARCHAR(30) FOR SBCS DATA
  WITH DEFAULT NULL
        ,UPDATETIMESTAMP VARCHAR(30) FOR SBCS DATA
  WITH DEFAULT NULL
        )
        IN DA540769.VV425
   APPEND NO
   NOT VOLATILE CARDINALITY
   DATA CAPTURE CHANGES
   AUDIT NONE
   CCSID EBCDIC
   PARTITION BY RANGE
        (PARTITION_NUMBER NULLS LAST ASC
        )
        ( PARTITION 1
           ENDING ( 1
        ) INCLUSIVE
        , PARTITION 2
           ENDING ( 2
        ) INCLUSIVE
        , PARTITION 3
           ENDING ( 3
        ) INCLUSIVE
        , PARTITION 4
           ENDING ( 4
        ) INCLUSIVE
        , PARTITION 5
           ENDING ( 5
        ) INCLUSIVE
        , PARTITION 6
           ENDING ( 6
        ) INCLUSIVE
        , PARTITION 7
           ENDING ( 7
        ) INCLUSIVE
        , PARTITION 8
           ENDING ( 8
        ) INCLUSIVE
        , PARTITION 9
           ENDING ( 9
        ) INCLUSIVE
        , PARTITION 10
           ENDING ( 10
        ) INCLUSIVE
        )
;
COMMIT