zOs/WK/NZ25DNEW
SET CURRENT SQLID='GDB9998';
CREATE TABLE GDB9998.TPER21A1
(NZ240001 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240002 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240003 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240004 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240005 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240006 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240007 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240008 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240009 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240010 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240011 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240012 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240013 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240014 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240015 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240016 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240017 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240018 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240019 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240020 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240021 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240022 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240023 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240024 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240025 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240026 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240027 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240028 CHAR(50) FOR SBCS DATA NOT NULL,
NZ240029 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240030 CHAR(26) FOR SBCS DATA NOT NULL,
NZ240031 CHAR(26) FOR SBCS DATA NOT NULL,
NZ240032 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240033 CHAR(20) FOR SBCS DATA NOT NULL,
NZ240034 CHAR(10) FOR SBCS DATA NOT NULL,
NZ240035 VARCHAR(1000) FOR SBCS DATA NOT NULL,
NZ240036 DATE WITH DEFAULT NULL,
CONSTRAINT NZ240003
PRIMARY KEY (NZ240003))
IN DGDB9998.APER21
PARTITION BY (NZ240003 ASC)
(PARTITION 1 ENDING AT (X'0001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 2 ENDING AT (X'0003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 3 ENDING AT (X'0005FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 4 ENDING AT (X'0007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 5 ENDING AT (X'0009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 6 ENDING AT (X'000BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 7 ENDING AT (X'000DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 8 ENDING AT (X'000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 9 ENDING AT (X'0011FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 10 ENDING AT (X'0013FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 11 ENDING AT (X'0015FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 12 ENDING AT (X'0017FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 13 ENDING AT (X'0019FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 14 ENDING AT (X'001BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 15 ENDING AT (X'001DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 16 ENDING AT (X'001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 17 ENDING AT (X'0021FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 18 ENDING AT (X'0023FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 19 ENDING AT (X'0025FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 20 ENDING AT (X'0027FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 21 ENDING AT (X'0029FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 22 ENDING AT (X'002BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 23 ENDING AT (X'002DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 24 ENDING AT (X'002FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 25 ENDING AT (X'0031FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 26 ENDING AT (X'0033FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 27 ENDING AT (X'0035FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 28 ENDING AT (X'0037FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 29 ENDING AT (X'0039FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 30 ENDING AT (X'003BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 31 ENDING AT (X'003DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 32 ENDING AT (X'003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 33 ENDING AT (X'0041FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 34 ENDING AT (X'0043FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 35 ENDING AT (X'0045FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 36 ENDING AT (X'0047FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 37 ENDING AT (X'0049FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 38 ENDING AT (X'004BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 39 ENDING AT (X'004DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 40 ENDING AT (X'004FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 41 ENDING AT (X'0051FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 42 ENDING AT (X'0053FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 43 ENDING AT (X'0055FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 44 ENDING AT (X'0057FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 45 ENDING AT (X'0059FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 46 ENDING AT (X'005BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 47 ENDING AT (X'005DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 48 ENDING AT (X'005FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 49 ENDING AT (X'0061FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 50 ENDING AT (X'0063FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 51 ENDING AT (X'0065FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 52 ENDING AT (X'0067FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 53 ENDING AT (X'0069FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 54 ENDING AT (X'006BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 55 ENDING AT (X'006DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 56 ENDING AT (X'006FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 57 ENDING AT (X'0071FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 58 ENDING AT (X'0073FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 59 ENDING AT (X'0075FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 60 ENDING AT (X'0077FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 61 ENDING AT (X'0079FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 62 ENDING AT (X'007BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 63 ENDING AT (X'007DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 64 ENDING AT (X'007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 65 ENDING AT (X'0081FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 66 ENDING AT (X'0083FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 67 ENDING AT (X'0085FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 68 ENDING AT (X'0087FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 69 ENDING AT (X'0089FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 70 ENDING AT (X'008BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 71 ENDING AT (X'008DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 72 ENDING AT (X'008FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 73 ENDING AT (X'0091FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 74 ENDING AT (X'0093FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 75 ENDING AT (X'0095FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 76 ENDING AT (X'0097FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 77 ENDING AT (X'0099FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 78 ENDING AT (X'009BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 79 ENDING AT (X'009DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 80 ENDING AT (X'009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 81 ENDING AT (X'00A1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 82 ENDING AT (X'00A3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 83 ENDING AT (X'00A5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 84 ENDING AT (X'00A7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 85 ENDING AT (X'00A9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 86 ENDING AT (X'00ABFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 87 ENDING AT (X'00ADFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 88 ENDING AT (X'00AFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 89 ENDING AT (X'00B1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 90 ENDING AT (X'00B3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 91 ENDING AT (X'00B5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 92 ENDING AT (X'00B7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 93 ENDING AT (X'00B9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 94 ENDING AT (X'00BBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 95 ENDING AT (X'00BDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 96 ENDING AT (X'00BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 97 ENDING AT (X'00C1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 98 ENDING AT (X'00C3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 99 ENDING AT (X'00C5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 100 ENDING AT (X'00C7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 101 ENDING AT (X'00C9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 102 ENDING AT (X'00CBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 103 ENDING AT (X'00CDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 104 ENDING AT (X'00CFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 105 ENDING AT (X'00D1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 106 ENDING AT (X'00D3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 107 ENDING AT (X'00D5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 108 ENDING AT (X'00D7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 109 ENDING AT (X'00D9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 110 ENDING AT (X'00DBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 111 ENDING AT (X'00DDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 112 ENDING AT (X'00DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 113 ENDING AT (X'00E1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 114 ENDING AT (X'00E3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 115 ENDING AT (X'00E5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 116 ENDING AT (X'00E7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 117 ENDING AT (X'00E9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 118 ENDING AT (X'00EBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 119 ENDING AT (X'00EDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 120 ENDING AT (X'00EFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 121 ENDING AT (X'00F1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 122 ENDING AT (X'00F3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 123 ENDING AT (X'00F5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 124 ENDING AT (X'00F7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 125 ENDING AT (X'00F9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 126 ENDING AT (X'00FBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 127 ENDING AT (X'00FDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
),
PARTITION 128 ENDING AT (X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
))
AUDIT NONE
DATA CAPTURE NONE
WITH RESTRICT ON DROP
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
COMMIT;