zOs/WK/NZ24DNEW
PARTITION BY
( NZ240003
)
( 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' )
)
CCSID EBCDIC
;
COMMENT ON A540769.TPER21A1
( NZ240001 IS 'REFERENZNUMMER DES SENDEOBJEKTES'
, NZ240002 IS 'REFERENZNUMMER DES PARENT VOM SENDEOBJEKTES'
, NZ240003 IS
'TABELLEN ID IN WELCHER SICH DER DATENTEIL BEFINDET'
, NZ240004 IS 'DB-VIEW IDENTIFIKATION'
, NZ240005 IS 'STATUSINFORMATION'
, NZ240006 IS 'IDENTIFIKTAION DES OWNERS'
, NZ240007 IS 'GESCHAEFTSFALLOBJEKTART'
, NZ240008 IS 'LIEFERANT/ SYSTEM'
, NZ240009 IS 'IDENTIFIKATION DES EINGANGSKANAL'
, NZ240010 IS 'SUCHWERT 01'
, NZ240011 IS 'BESCHREIBUNG SUCHWERT 01'
, NZ240012 IS 'SUCHWERT 02'
, NZ240013 IS 'BESCHREIBUNG SUCHWERT 02'
, NZ240014 IS 'SUCHWERT 03'
, NZ240015 IS 'BESCHREIBUNG SUCHWERT 03'
, NZ240016 IS 'SUCHWERT 04'
, NZ240017 IS 'BESCHREIBUNG SUCHWERT 04'
, NZ240018 IS 'SUCHWERT 05'
, NZ240019 IS 'BESCHREIBUNG SUCHWERT 05'
, NZ240020 IS 'SUCHWERT 06'
, NZ240021 IS 'BESCHREIBUNG SUCHWERT 06'
, NZ240022 IS 'SUCHWERT 07'
, NZ240023 IS 'BESCHREIBUNG SUCHWERT 07'
, NZ240024 IS 'SUCHWERT 08'
, NZ240025 IS 'BESCHREIBUNG SUCHWERT 08'
, NZ240026 IS 'SUCHWERT 09'
, NZ240027 IS 'BESCHREIBUNG SUCHWERT 09'
, NZ240028 IS 'SUCHWERT 10'
, NZ240029 IS 'BESCHREIBUNG SUCHWERT 10'
, NZ240030 IS 'TIMESTAMP ERSTELLUNGSZEITPUNKT'
, NZ240031 IS 'TIMESTAMP STATUS GEAENDERT'
, NZ240032 IS 'IDENTIFIKTAION DES STATUSBEARBEITERS'
, NZ240033 IS 'IDENTFIKATIONSTYPE DER ERGAENZENDEN BESCHREIBUNG'
, NZ240034 IS 'STATUS DES AUFTRAGES'
, NZ240035 IS 'ERGAENZENDE BESCHREIBUNG'
) ;
LABEL ON A540769.TPER21A1
( NZ240001 IS 'REFID'
, NZ240002 IS 'PARENTREFID'
, NZ240003 IS 'HEADERUWI'
, NZ240004 IS 'DBVIEWID'
, NZ240005 IS 'STATUS'
, NZ240006 IS 'OWNERID'
, NZ240007 IS 'OBJTYPE'
, NZ240008 IS 'DELIVERERID'
, NZ240009 IS 'OWNERCHANNEL'
, NZ240010 IS 'SEARCHVALUE01'
, NZ240011 IS 'SEARCHTYPE01'
, NZ240012 IS 'SEARCHVALUE02'
, NZ240013 IS 'SEARCHTYPE02'
, NZ240014 IS 'SEARCHVALUE03'
, NZ240015 IS 'SEARCHTYPE03'
, NZ240016 IS 'SEARCHVALUE04'
, NZ240017 IS 'SEARCHTYPE04'
, NZ240018 IS 'SEARCHVALUE05'
, NZ240019 IS 'SEARCHTYPE05'
, NZ240020 IS 'SEARCHVALUE06'
, NZ240021 IS 'SEARCHTYPE06'
, NZ240022 IS 'SEARCHVALUE07'
, NZ240023 IS 'SEARCHTYPE07'
, NZ240024 IS 'SEARCHVALUE08'
, NZ240025 IS 'SEARCHTYPE08'
, NZ240026 IS 'SEARCHVALUE09'
, NZ240027 IS 'SEARCHTYPE09'
, NZ240028 IS 'SEARCHVALUE10'
, NZ240029 IS 'SEARCHTYPE10'
, NZ240030 IS 'CREATEDATETIME'
, NZ240031 IS 'CHANGEDATETIME'
, NZ240032 IS 'CHANGEID'
, NZ240033 IS 'HEADERDESCTYPE'
, NZ240034 IS 'ORDERSTATE'
, NZ240035 IS 'HEADERDESC'
) ;
LABEL ON TABLE A540769.TPER21A1 IS 'ZV HISTO: HISTOHEADER' ;
-- **************************************************************
-- * *
-- * INDEX CREATE AND ALTER STATEMENTS *
-- * *
-- **************************************************************
-- RMA630W THE RECOVER INDEX UTILITY HAS NOT BEEN REQUESTED. THE INDEX
-- A540769.IPER21A0 WILL BE PLACED IN A REBUILD
-- PENDING STATUS. PLEASE RE-ANALYZE WITH RECOVER INDEX OPTION OR
-- RUN REBUILD INDEX UTILITY AFTER EXECUTING THE ANALYSIS.
-- A540769.IPER21A0 WILL BE CREATED VIA THESE NATIVE DB2 COMMANDS.
CREATE UNIQUE INDEX A540769.IPER21A0 ON A540769.TPER21A1
( NZ240003 ASC
)
PARTITIONED
USING STOGROUP GSMS
ERASE NO
FREEPAGE 10
PCTFREE 10
CLUSTER
BUFFERPOOL BP1
CLOSE YES
DEFER YES
;
-- RMA630W THE RECOVER INDEX UTILITY HAS NOT BEEN REQUESTED. THE INDEX
-- A540769.IPER21A1 WILL BE PLACED IN A REBUILD
-- PENDING STATUS. PLEASE RE-ANALYZE WITH RECOVER INDEX OPTION OR
-- RUN REBUILD INDEX UTILITY AFTER EXECUTING THE ANALYSIS.
-- A540769.IPER21A1 WILL BE CREATED VIA THESE NATIVE DB2 COMMANDS.
CREATE INDEX A540769.IPER21A1 ON A540769.TPER21A1
( NZ240001 ASC
, NZ240005 ASC
, NZ240034 ASC
, NZ240006 ASC
, NZ240008 ASC
, NZ240009 ASC
)
USING STOGROUP GSMS
ERASE NO
FREEPAGE 10
PCTFREE 10
BUFFERPOOL BP1
CLOSE YES
DEFER YES
PIECESIZE 2G
;
-- RMA630W THE RECOVER INDEX UTILITY HAS NOT BEEN REQUESTED. THE INDEX
-- A540769.IPER21A2 WILL BE PLACED IN A REBUILD
-- PENDING STATUS. PLEASE RE-ANALYZE WITH RECOVER INDEX OPTION OR
-- RUN REBUILD INDEX UTILITY AFTER EXECUTING THE ANALYSIS.
-- A540769.IPER21A2 WILL BE CREATED VIA THESE NATIVE DB2 COMMANDS.
CREATE INDEX A540769.IPER21A2 ON A540769.TPER21A1
( NZ240010 ASC
, NZ240012 ASC
, NZ240014 ASC
, NZ240005 ASC
, NZ240034 ASC
)
USING STOGROUP GSMS
ERASE NO
FREEPAGE 10
PCTFREE 10
BUFFERPOOL BP1
CLOSE YES
DEFER YES
PIECESIZE 2G
;
-- RMA630W THE RECOVER INDEX UTILITY HAS NOT BEEN REQUESTED. THE INDEX
-- A540769.IPER21A3 WILL BE PLACED IN A REBUILD
-- PENDING STATUS. PLEASE RE-ANALYZE WITH RECOVER INDEX OPTION OR
-- RUN REBUILD INDEX UTILITY AFTER EXECUTING THE ANALYSIS.
-- A540769.IPER21A3 WILL BE CREATED VIA THESE NATIVE DB2 COMMANDS.
CREATE INDEX A540769.IPER21A3 ON A540769.TPER21A1
( NZ240006 ASC
, NZ240012 ASC
, NZ240014 ASC
, NZ240005 ASC
, NZ240034 ASC
)
USING STOGROUP GSMS
ERASE NO
FREEPAGE 10
PCTFREE 10
BUFFERPOOL BP1
CLOSE YES
DEFER YES
PIECESIZE 2G
;
-- RMA630W THE RECOVER INDEX UTILITY HAS NOT BEEN REQUESTED. THE INDEX
-- A540769.IPER21A4 WILL BE PLACED IN A REBUILD
-- PENDING STATUS. PLEASE RE-ANALYZE WITH RECOVER INDEX OPTION OR
-- RUN REBUILD INDEX UTILITY AFTER EXECUTING THE ANALYSIS.
-- A540769.IPER21A4 WILL BE CREATED VIA THESE NATIVE DB2 COMMANDS.
CREATE INDEX A540769.IPER21A4 ON A540769.TPER21A1
( NZ240028 ASC
, NZ240007 ASC
)
USING STOGROUP GSMS
ERASE NO
FREEPAGE 10
PCTFREE 10
BUFFERPOOL BP1
CLOSE YES
DEFER YES
PIECESIZE 4G
;
-- RMA630W THE RECOVER INDEX UTILITY HAS NOT BEEN REQUESTED. THE INDEX
-- A540769.IPER21A5 WILL BE PLACED IN A REBUILD
-- PENDING STATUS. PLEASE RE-ANALYZE WITH RECOVER INDEX OPTION OR
-- RUN REBUILD INDEX UTILITY AFTER EXECUTING THE ANALYSIS.
-- A540769.IPER21A5 WILL BE CREATED VIA THESE NATIVE DB2 COMMANDS.
CREATE INDEX A540769.IPER21A5 ON A540769.TPER21A1
( NZ240022 ASC
, NZ240012 ASC
, NZ240014 ASC
, NZ240005 ASC
, NZ240034 ASC
)
USING STOGROUP GSMS
ERASE NO
FREEPAGE 10
PCTFREE 10
BUFFERPOOL BP1
CLOSE YES
DEFER YES
PIECESIZE 2G
;
-- **************************************************************
-- * *
-- * VIEW CREATE AND ALTER STATEMENTS *
-- * *
-- **************************************************************
-- A540769.VNZ240A1V WILL BE CREATED VIA THESE NATIVE DB2 COMMANDS.
SET CURRENT SQLID = 'A540769';
CREATE VIEW A540769.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 A540769.tper21A1
;
SET CURRENT SQLID = USER;