zOs/TX/PER21DD1
-- testcase tnz240 repartitionierung -------------------------
set current sqlid = 'S100447';
DROP TABLESPACE $db.aPer21 ;
COMMIT ;
;
$@[
say 'npi='$npi'|'
if $phase >= 1 then $@=[
--
CREATE TABLESPACE aPer21
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD NO
LOGGED
$@[
if $phase = 1 then $@=[
DSSIZE 4 G
NUMPARTS 60
$] else if $phase = 2 then $@=[
DSSIZE 16 G
NUMPARTS 64
$] else if $phase >= 3 then $@=[
DSSIZE 16 G
NUMPARTS 128
$]
$]
SEGSIZE 0
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
CREATE TABLE $creator.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 $db.aPer21
$@[
if $phase = 1 then $@=[
$] else if $phase = 2 then $@=[
PARTITION BY (NZ240003 ASC)
( PARTITION 1 ENDING AT (X'0002FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 2 ENDING AT (X'0005FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 3 ENDING AT (X'0009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 4 ENDING AT (X'0011FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 5 ENDING AT (X'0015FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 6 ENDING AT (X'0019FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 7 ENDING AT (X'001DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 8 ENDING AT (X'0021FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 9 ENDING AT (X'0025FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 10 ENDING AT (X'0029FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 11 ENDING AT (X'002DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 12 ENDING AT (X'0031FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 13 ENDING AT (X'0035FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 14 ENDING AT (X'0039FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 15 ENDING AT (X'003DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 16 ENDING AT (X'0041FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 17 ENDING AT (X'0045FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 18 ENDING AT (X'0049FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 19 ENDING AT (X'004DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 20 ENDING AT (X'0051FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 21 ENDING AT (X'0055FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 22 ENDING AT (X'0059FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 23 ENDING AT (X'005DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 24 ENDING AT (X'0061FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 25 ENDING AT (X'0065FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 26 ENDING AT (X'0069FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 27 ENDING AT (X'006DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 28 ENDING AT (X'0071FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 29 ENDING AT (X'0075FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 30 ENDING AT (X'0079FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 31 ENDING AT (X'007DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 32 ENDING AT (X'0081FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 33 ENDING AT (X'0085FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 34 ENDING AT (X'0089FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 35 ENDING AT (X'008DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 36 ENDING AT (X'0091FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 37 ENDING AT (X'0095FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 38 ENDING AT (X'0099FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 39 ENDING AT (X'009DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 40 ENDING AT (X'00A1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 41 ENDING AT (X'00A5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 42 ENDING AT (X'00A9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 43 ENDING AT (X'00ADFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 44 ENDING AT (X'00B1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 45 ENDING AT (X'00B5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 46 ENDING AT (X'00B9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 47 ENDING AT (X'00BDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 48 ENDING AT (X'00C1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 49 ENDING AT (X'00C5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 50 ENDING AT (X'00C9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 51 ENDING AT (X'00CDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 52 ENDING AT (X'00D1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 53 ENDING AT (X'00D5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 54 ENDING AT (X'00D9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 55 ENDING AT (X'00DDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 56 ENDING AT (X'00E1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 57 ENDING AT (X'00E5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 58 ENDING AT (X'00E9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 59 ENDING AT (X'00EDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 60 ENDING AT (X'00EFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 61 ENDING AT (X'00F3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 62 ENDING AT (X'00F7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 63 ENDING AT (X'00FBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 64 ENDING AT (X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
)
$] else if $phase >= 3 then $@=[
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 ;
--
LABEL ON TABLE $creator.tper21A1 IS 'ZV HISTO: HISTOHEADER';
--
COMMENT ON $creator.tper21A1
(NZ240035 IS 'ERGAENZENDE BESCHREIBUNG',
NZ240034 IS 'STATUS DES AUFTRAGES',
NZ240033 IS 'IDENTFIKATIONSTYPE DER ERGAENZENDEN BESCHREIBUNG',
NZ240032 IS 'IDENTIFIKTAION DES STATUSBEARBEITERS',
NZ240031 IS 'TIMESTAMP STATUS GEAENDERT',
NZ240030 IS 'TIMESTAMP ERSTELLUNGSZEITPUNKT',
NZ240029 IS 'BESCHREIBUNG SUCHWERT 10',
NZ240028 IS 'SUCHWERT 10',
NZ240027 IS 'BESCHREIBUNG SUCHWERT 09',
NZ240026 IS 'SUCHWERT 09',
NZ240025 IS 'BESCHREIBUNG SUCHWERT 08',
NZ240024 IS 'SUCHWERT 08',
NZ240023 IS 'BESCHREIBUNG SUCHWERT 07',
NZ240022 IS 'SUCHWERT 07',
NZ240021 IS 'BESCHREIBUNG SUCHWERT 06',
NZ240020 IS 'SUCHWERT 06',
NZ240019 IS 'BESCHREIBUNG SUCHWERT 05',
NZ240018 IS 'SUCHWERT 05',
NZ240017 IS 'BESCHREIBUNG SUCHWERT 04',
NZ240016 IS 'SUCHWERT 04',
NZ240015 IS 'BESCHREIBUNG SUCHWERT 03',
NZ240014 IS 'SUCHWERT 03',
NZ240013 IS 'BESCHREIBUNG SUCHWERT 02',
NZ240012 IS 'SUCHWERT 02',
NZ240011 IS 'BESCHREIBUNG SUCHWERT 01',
NZ240010 IS 'SUCHWERT 01',
NZ240009 IS 'IDENTIFIKATION DES EINGANGSKANAL',
NZ240008 IS 'LIEFERANT/ SYSTEM',
NZ240007 IS 'GESCHAEFTSFALLOBJEKTART',
NZ240006 IS 'IDENTIFIKTAION DES OWNERS',
NZ240005 IS 'STATUSINFORMATION',
NZ240004 IS 'DB-VIEW IDENTIFIKATION',
NZ240003 IS 'TABELLEN ID IN WELCHER SICH DER DATENTEIL BEFINDET',
NZ240002 IS 'REFERENZNUMMER DES PARENT VOM SENDEOBJEKTES',
NZ240001 IS 'REFERENZNUMMER DES SENDEOBJEKTES');
--
LABEL ON $creator.tper21A1
(NZ240035 IS 'HEADERDESC',
NZ240034 IS 'ORDERSTATE',
NZ240033 IS 'HEADERDESCTYPE',
NZ240032 IS 'CHANGEID',
NZ240031 IS 'CHANGEDATETIME',
NZ240030 IS 'CREATEDATETIME',
NZ240029 IS 'SEARCHTYPE10',
NZ240028 IS 'SEARCHVALUE10',
NZ240027 IS 'SEARCHTYPE09',
NZ240026 IS 'SEARCHVALUE09',
NZ240025 IS 'SEARCHTYPE08',
NZ240024 IS 'SEARCHVALUE08',
NZ240023 IS 'SEARCHTYPE07',
NZ240022 IS 'SEARCHVALUE07',
NZ240021 IS 'SEARCHTYPE06',
NZ240020 IS 'SEARCHVALUE06',
NZ240019 IS 'SEARCHTYPE05',
NZ240018 IS 'SEARCHVALUE05',
NZ240017 IS 'SEARCHTYPE04',
NZ240016 IS 'SEARCHVALUE04',
NZ240015 IS 'SEARCHTYPE03',
NZ240014 IS 'SEARCHVALUE03',
NZ240013 IS 'SEARCHTYPE02',
NZ240012 IS 'SEARCHVALUE02',
NZ240011 IS 'SEARCHTYPE01',
NZ240010 IS 'SEARCHVALUE01',
NZ240009 IS 'OWNERCHANNEL',
NZ240008 IS 'DELIVERERID',
NZ240007 IS 'OBJTYPE',
NZ240006 IS 'OWNERID',
NZ240005 IS 'STATUS',
NZ240004 IS 'DBVIEWID',
NZ240003 IS 'HEADERUWI',
NZ240002 IS 'PARENTREFID',
NZ240001 IS 'REFID');
--
CREATE UNIQUE INDEX $creator.iper21A0
ON $creator.tper21A1
(NZ240003 ASC)
$@[
if $phase > 1 then $@=[
PARTITIONED
$] else if $phase = 1 then $@=[
( PARTITION 1 ENDING AT (X'0002FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 2 ENDING AT (X'0005FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 3 ENDING AT (X'0009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 4 ENDING AT (X'0011FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 5 ENDING AT (X'0015FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 6 ENDING AT (X'0019FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 7 ENDING AT (X'001DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 8 ENDING AT (X'0021FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 9 ENDING AT (X'0025FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 10 ENDING AT (X'0029FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 11 ENDING AT (X'002DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 12 ENDING AT (X'0031FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 13 ENDING AT (X'0035FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 14 ENDING AT (X'0039FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 15 ENDING AT (X'003DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 16 ENDING AT (X'0041FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 17 ENDING AT (X'0045FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 18 ENDING AT (X'0049FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 19 ENDING AT (X'004DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 20 ENDING AT (X'0051FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 21 ENDING AT (X'0055FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 22 ENDING AT (X'0059FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 23 ENDING AT (X'005DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 24 ENDING AT (X'0061FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 25 ENDING AT (X'0065FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 26 ENDING AT (X'0069FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 27 ENDING AT (X'006DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 28 ENDING AT (X'0071FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 29 ENDING AT (X'0075FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 30 ENDING AT (X'0079FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 31 ENDING AT (X'007DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 32 ENDING AT (X'0081FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 33 ENDING AT (X'0085FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 34 ENDING AT (X'0089FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 35 ENDING AT (X'008DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 36 ENDING AT (X'0091FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 37 ENDING AT (X'0095FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 38 ENDING AT (X'0099FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 39 ENDING AT (X'009DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 40 ENDING AT (X'00A1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 41 ENDING AT (X'00A5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 42 ENDING AT (X'00A9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 43 ENDING AT (X'00ADFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 44 ENDING AT (X'00B1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 45 ENDING AT (X'00B5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 46 ENDING AT (X'00B9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 47 ENDING AT (X'00BDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 48 ENDING AT (X'00C1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 49 ENDING AT (X'00C5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 50 ENDING AT (X'00C9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 51 ENDING AT (X'00CDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 52 ENDING AT (X'00D1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 53 ENDING AT (X'00D5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 54 ENDING AT (X'00D9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 55 ENDING AT (X'00DDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 56 ENDING AT (X'00E1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 57 ENDING AT (X'00E5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 58 ENDING AT (X'00E9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 59 ENDING AT (X'00EDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
,
PARTITION 60 ENDING AT (X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
)
$]
$]
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
--
$@[
if $npi then $@=[
CREATE INDEX $creator.iper21A1
ON $creator.tper21A1
(NZ240001 ASC,
NZ240005 ASC,
NZ240034 ASC,
NZ240006 ASC,
NZ240008 ASC,
NZ240009 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
CREATE INDEX $creator.iper21A2
ON $creator.tper21A1
(NZ240010 ASC,
NZ240012 ASC,
NZ240014 ASC,
NZ240005 ASC,
NZ240034 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
CREATE INDEX $creator.iper21A3
ON $creator.tper21A1
(NZ240006 ASC,
NZ240012 ASC,
NZ240014 ASC,
NZ240005 ASC,
NZ240034 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
CREATE INDEX $creator.iper21A4
ON $creator.tper21A1
(NZ240028 ASC,
NZ240007 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 4 G;
--
CREATE INDEX $creator.iper21A5
ON $creator.tper21A1
(NZ240022 ASC,
NZ240012 ASC,
NZ240014 ASC,
NZ240005 ASC,
NZ240034 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
$]
$]
--
CREATE VIEW $creator.VNZ240A1V(REFID,
PARENTREFID, HEADERUWI, DBVIEWID,
STATUS, PURGEDATE, OWNERID, OBJTYPE, DELIVERERID, OWNERCHANNEL,
SEARCHVALUE01, SEARCHTYPE01, SEARCHVALUE02, SEARCHTYPE02,
SEARCHVALUE03, SEARCHTYPE03, SEARCHVALUE04, SEARCHTYPE04,
SEARCHVALUE05, SEARCHTYPE05, SEARCHVALUE06, SEARCHTYPE06,
SEARCHVALUE07, SEARCHTYPE07, SEARCHVALUE08, SEARCHTYPE08,
SEARCHVALUE09, SEARCHTYPE09, SEARCHVALUE10, SEARCHTYPE10,
CREATEDATETIME, CHANGEDATETIME, CHANGEID, HEADERDESCTYPE,
ORDERSTATE, HEADERDESC) AS
SELECT ALL NZ240001, NZ240002, NZ240003, NZ240004, NZ240005,
NZ240036, NZ240006, NZ240007, NZ240008, NZ240009, NZ240010,
NZ240011, NZ240012, NZ240013, NZ240014, NZ240015, NZ240016,
NZ240017, NZ240018, NZ240019, NZ240020, NZ240021, NZ240022,
NZ240023, NZ240024, NZ240025, NZ240026, NZ240027, NZ240028,
NZ240029, NZ240030, NZ240031, NZ240032, NZ240033, NZ240034,
NZ240035
FROM $creator.tper21A1 ;
--
COMMIT;
$]
$]