zOs/SQL/FRANZDDL
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBOF (810) Extract time : 2006-10-23 16:35 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=N AL=N LB=Y CM=Y FK=Y --
-- TG=N UT=N UF=N SP=N SQ=N --
-- Grants : SG=N DB=Y TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Tablespace=A242A In Database DA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769 Stogroup=GSMS (for partition 1)
-- Tablespace=DA540769.A242A
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
--
drop TABLESPACE dA540769.A242A;
commit;
CREATE TABLESPACE A242A
IN DA540769
USING STOGROUP GSMS
PRIQTY 360000 SECQTY 28800
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
DSSIZE 4 G
NUMPARTS 60
(PART 2 USING STOGROUP GSMS PRIQTY 360000 SECQTY 57600,
PART 3 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 4 USING STOGROUP GSMS PRIQTY 360000 SECQTY 266400,
PART 5 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 6 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 7 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 8 USING STOGROUP GSMS PRIQTY 360000 SECQTY 43200,
PART 9 USING STOGROUP GSMS PRIQTY 360000 SECQTY 43200,
PART 10 USING STOGROUP GSMS PRIQTY 198000 SECQTY 10800,
PART 11 USING STOGROUP GSMS PRIQTY 216000 SECQTY 14400,
PART 12 USING STOGROUP GSMS PRIQTY 360000 SECQTY 72000,
PART 13 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 14 USING STOGROUP GSMS PRIQTY 360000 SECQTY 72000,
PART 15 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 16 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 17 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 18 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 19 USING STOGROUP GSMS PRIQTY 360000 SECQTY 72000,
PART 20 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 21 USING STOGROUP GSMS PRIQTY 360000 SECQTY 18000,
PART 22 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 23 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 24 USING STOGROUP GSMS PRIQTY 216000 SECQTY 14400,
PART 25 USING STOGROUP GSMS PRIQTY 360000 SECQTY 18000,
PART 26 USING STOGROUP GSMS PRIQTY 360000 SECQTY 43200,
PART 27 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 28 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 29 USING STOGROUP GSMS PRIQTY 360000 SECQTY 18000,
PART 30 USING STOGROUP GSMS PRIQTY 360000 SECQTY 72000,
PART 31 USING STOGROUP GSMS PRIQTY 360000 SECQTY 72000,
PART 32 USING STOGROUP GSMS PRIQTY 360000 SECQTY 72000,
PART 33 USING STOGROUP GSMS PRIQTY 360000 SECQTY 18000,
PART 34 USING STOGROUP GSMS PRIQTY 216000 SECQTY 14400,
PART 35 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 36 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 37 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 38 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 39 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 40 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 41 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 42 USING STOGROUP GSMS PRIQTY 360000 SECQTY 18000,
PART 43 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 44 USING STOGROUP GSMS PRIQTY 360000 SECQTY 93600,
PART 45 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 46 USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 47 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 48 USING STOGROUP GSMS PRIQTY 360000 SECQTY 43200,
PART 49 USING STOGROUP GSMS PRIQTY 360000 SECQTY 93600,
PART 50 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 51 USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 52 USING STOGROUP GSMS PRIQTY 360000 SECQTY 43200,
PART 53 USING STOGROUP GSMS PRIQTY 360000 SECQTY 43200,
PART 54 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 55 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 56 USING STOGROUP GSMS PRIQTY 252000 SECQTY 14400,
PART 57 USING STOGROUP GSMS PRIQTY 360000 SECQTY 43200,
PART 58 USING STOGROUP GSMS PRIQTY 360000 SECQTY 100800,
PART 59 USING STOGROUP GSMS PRIQTY 360000 SECQTY 64800,
PART 60 USING STOGROUP GSMS PRIQTY 360000 SECQTY 273600
FREEPAGE 20 PCTFREE 10)
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=A540769.TNZ242A1 In DA540769.A242A
------------------------------------------------------------------------
--
SET CURRENT SQLID='A540769';
--
CREATE TABLE A540769.TNZ242A1
(NZ242001 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242002 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242003 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242004 CHAR(10) FOR SBCS DATA NOT NULL,
NZ242005 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242006 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242007 CHAR(10) FOR SBCS DATA NOT NULL,
NZ242008 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242009 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242010 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242011 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242012 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242013 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242014 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242015 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242016 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242017 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242018 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242019 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242020 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242021 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242022 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242023 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242024 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242025 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242026 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242027 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242028 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242029 CHAR(10) FOR SBCS DATA NOT NULL,
NZ242030 CHAR(26) FOR SBCS DATA NOT NULL,
NZ242031 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242032 CHAR(1) FOR SBCS DATA NOT NULL,
NZ242033 VARCHAR(3100) FOR SBCS DATA NOT NULL)
IN DA540769.A242A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE A540769.TNZ242A1 IS 'ZV Histo: HistoData';
--
COMMENT ON A540769.TNZ242A1
(NZ242033 IS 'SERIALISIERTE OBJEKTE BZW DER DATENTEIL',
NZ242032 IS 'SOLL/HABEN IDENTIFIKATION',
NZ242031 IS 'STRUKTURTYP DES OBJEKTS',
NZ242030 IS 'TIMESTAMP ERSTELLZEITPUNKT',
NZ242029 IS 'VERSION DES OBJEKTES BZW. SOFTWARESTAND DER STRUKTUR',
NZ242028 IS 'BESCHREIBUNG SUCHWERT 10',
NZ242027 IS 'SUCHWERT 10',
NZ242026 IS 'BESCHREIBUNG SUCHWERT 09',
NZ242025 IS 'SUCHWERT 09',
NZ242024 IS 'BESCHREIBUNG SUCHWERT 08',
NZ242023 IS 'SUCHWERT 08',
NZ242022 IS 'BESCHREIBUNG SUCHWERT 07',
NZ242021 IS 'SUCHWERT 07',
NZ242020 IS 'BESCHREIBUNG SUCHWERT 06',
NZ242019 IS 'SUCHWERT 06',
NZ242018 IS 'BESCHREIBUNG SUCHWERT 05',
NZ242017 IS 'SUCHWERT 05',
NZ242016 IS 'BESCHREIBUNG SUCHWERT 04',
NZ242015 IS 'SUCHWERT 04',
NZ242014 IS 'BESCHREIBUNG SUCHWERT 03',
NZ242013 IS 'SUCHWERT 03',
NZ242012 IS 'BESCHREIBUNG SUCHWERT 02',
NZ242011 IS 'SUCHWERT 02',
NZ242010 IS 'BESCHREIBUNG SUCHWERT 01',
NZ242009 IS 'SUCHWERT 01',
NZ242008 IS 'OBJEKTTYP',
NZ242007 IS 'GESCHAEFTSFALLTYP',
NZ242006 IS 'ID DES STATUSAUSLOESERS ODER BEARBEITUNGSMITTEL',
NZ242005 IS 'STATUSANGABE',
NZ242004 IS 'IDENTIFIKATIONSNUMMER',
NZ242003 IS 'REFERENZNUMMER DES SENDEOBJEKTES',
NZ242002 IS 'TECHNISCHER IDENTIFIKATIONSSCHLUESSEL UNIQUE',
NZ242001 IS 'TECHNISCHER SCHLUESSEL ZUM HISTO HEADERTEIL');
--
LABEL ON A540769.TNZ242A1
(NZ242033 IS 'Object',
NZ242032 IS 'SideType',
NZ242031 IS 'ObjDescType',
NZ242030 IS 'CreateDateTime',
NZ242029 IS 'ObjTypeVersion',
NZ242028 IS 'SearchType10',
NZ242027 IS 'SearchValue10',
NZ242026 IS 'SearchType09',
NZ242025 IS 'SearchValue09',
NZ242024 IS 'SearchType08',
NZ242023 IS 'SearchValue08',
NZ242022 IS 'SearchType07',
NZ242021 IS 'SearchValue07',
NZ242020 IS 'SearchType06',
NZ242019 IS 'SearchValue06',
NZ242018 IS 'SearchType05',
NZ242017 IS 'SearchValue05',
NZ242016 IS 'SearchType04',
NZ242015 IS 'SearchValue04',
NZ242014 IS 'SearchType03',
NZ242013 IS 'SearchValue03',
NZ242012 IS 'SearchType02',
NZ242011 IS 'SearchValue02',
NZ242010 IS 'SearchType01',
NZ242009 IS 'SearchValue01',
NZ242008 IS 'ObjType',
NZ242007 IS 'GfsType',
NZ242006 IS 'ProcesserId',
NZ242005 IS 'ProcessStatus',
NZ242004 IS 'IdentNumber',
NZ242003 IS 'RefId',
NZ242002 IS 'IdentUwi',
NZ242001 IS 'HeaderUwi');
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.INZ242A1 On A540769.TNZ242A1
------------------------------------------------------------------------
--
CREATE INDEX A540769.INZ242A1
ON A540769.TNZ242A1
(NZ242001 ASC,
NZ242003 ASC,
NZ242004 ASC,
NZ242005 ASC,
NZ242006 ASC,
NZ242007 ASC,
NZ242008 ASC)
USING STOGROUP GSMS
PRIQTY 324000 SECQTY 18000
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES(X'0002FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 2 VALUES(X'0005FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 3 VALUES(X'0009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 4 VALUES(X'0011FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 86400,
PART 5 VALUES(X'0015FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 6 VALUES(X'0019FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 28800,
PART 7 VALUES(X'001DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 8 VALUES(X'0021FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 9 VALUES(X'0025FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 10 VALUES(X'0029FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 11 VALUES(X'002DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 252000 SECQTY 14400,
PART 12 VALUES(X'0031FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 13 VALUES(X'0035FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 14 VALUES(X'0039FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 28800,
PART 15 VALUES(X'003DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 16 VALUES(X'0041FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 17 VALUES(X'0045FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 28800,
PART 18 VALUES(X'0049FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 19 VALUES(X'004DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 20 VALUES(X'0051FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 21 VALUES(X'0055FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 252000 SECQTY 14400,
PART 22 VALUES(X'0059FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 23 VALUES(X'005DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 28800,
PART 24 VALUES(X'0061FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 28800,
PART 25 VALUES(X'0065FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 26 VALUES(X'0069FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 27 VALUES(X'006DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 28 VALUES(X'0071FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 29 VALUES(X'0075FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 30 VALUES(X'0079FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 252000 SECQTY 14400,
PART 31 VALUES(X'007DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 32 VALUES(X'0081FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 33 VALUES(X'0085FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 720 SECQTY 7200,
PART 34 VALUES(X'0089FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 252000 SECQTY 14400,
PART 35 VALUES(X'008DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 36 VALUES(X'0091FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 37 VALUES(X'0095FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 38 VALUES(X'0099FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 39 VALUES(X'009DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 40 VALUES(X'00A1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 41 VALUES(X'00A5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 42 VALUES(X'00A9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 43 VALUES(X'00ADFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 44 VALUES(X'00B1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 45 VALUES(X'00B5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 46 VALUES(X'00B9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 47 VALUES(X'00BDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 48 VALUES(X'00C1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 49 VALUES(X'00C5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 252000 SECQTY 14400,
PART 50 VALUES(X'00C9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 28800,
PART 51 VALUES(X'00CDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 52 VALUES(X'00D1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 252000 SECQTY 14400,
PART 53 VALUES(X'00D5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 54 VALUES(X'00D9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 55 VALUES(X'00DDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 56 VALUES(X'00E1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 18000,
PART 57 VALUES(X'00E5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 58 VALUES(X'00E9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 25200,
PART 59 VALUES(X'00EDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 21600,
PART 60 VALUES(X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')
USING STOGROUP GSMS PRIQTY 360000 SECQTY 288000)
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES;
--
------------------------------------------------------------------------
-- View=A540769.VNZ242A1V
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","GDB0283" ;
--
CREATE VIEW A540769.VNZ242A1V(HEADERUWI, IDENTUWI, REFID, IDENTNUMBER,
PROCESSSTATUS, PROCESSERID, GFSTYPE, OBJTYPE, SEARCHVALUE01,
SEARCHTYPE01, SEARCHVALUE02, SEARCHTYPE02, SEARCHVALUE03,
SEARCHTYPE03, SEARCHVALUE04, SEARCHTYPE04, SEARCHVALUE05,
SEARCHTYPE05, SEARCHVALUE06, SEARCHTYPE06, SEARCHVALUE07,
SEARCHTYPE07, SEARCHVALUE08, SEARCHTYPE08, SEARCHVALUE09,
SEARCHTYPE09, SEARCHVALUE10, SEARCHTYPE10, OBJTYPEVERSION,
CREATEDATETIME, OBJDESCTYPE, SIDETYPE, OBJECT) AS
SELECT ALL NZ242001, NZ242002, NZ242003, NZ242004, NZ242005,
NZ242006, NZ242007, NZ242008, NZ242009, NZ242010, NZ242011,
NZ242012, NZ242013, NZ242014, NZ242015, NZ242016, NZ242017,
NZ242018, NZ242019, NZ242020, NZ242021, NZ242022, NZ242023,
NZ242024, NZ242025, NZ242026, NZ242027, NZ242028, NZ242029,
NZ242030, NZ242031, NZ242032, NZ242033
FROM A540769.TNZ242A1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--