zOs/WK/NZ25DOLD
--
CREATE TABLESPACE A240A
IN NZ06A1T
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
DSSIZE 4 G
NUMPARTS 60
SEGSIZE 0
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=OA1T.TNZ240A1 In NZ06A1T.A240A
------------------------------------------------------------------------
--
CREATE TABLE OA1T.TNZ240A1
(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 NZ06A1T.A240A
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'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
)
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
LABEL ON TABLE OA1T.TNZ240A1 IS 'ZV HISTO: HISTOHEADER';
--
COMMENT ON OA1T.TNZ240A1
(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 OA1T.TNZ240A1
(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');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=NZ06A1T
-- Index=OA1T.INZ240A0 On OA1T.TNZ240A1
------------------------------------------------------------------------
--