zOs/SQL/HYPX
set current sqlid = 's100447';
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBAF (810) Extract time : 2006-08-11 16:04 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=N UF=N SP=N SQ=N --
-- Grants : SG=Y DB=Y TS=Y TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table=GDB0366.THY126G1
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Table=GDB0366.THY126G1 In DGDB0366.A126A
------------------------------------------------------------------------
--
drop TABLE GDB0366.THY126G1;
commit;
CREATE TABLE GDB0366.THY126G1
(HY126001 CHAR(16) FOR SBCS DATA NOT NULL,
HY126002 DATE NOT NULL,
HY126003 DATE NOT NULL,
HY126004 DATE NOT NULL,
HY126005 DATE NOT NULL,
HY126006 SMALLINT NOT NULL,
HY126007 CHAR(12) FOR SBCS DATA NOT NULL,
HY126008 CHAR(20) FOR SBCS DATA NOT NULL,
HY126009 DECIMAL(15, 3) NOT NULL,
HY126010 DECIMAL(15, 3) NOT NULL,
HY126011 DECIMAL(15, 3) NOT NULL,
HY126012 CHAR(3) FOR SBCS DATA NOT NULL,
HY126013 CHAR(1) FOR SBCS DATA NOT NULL,
CONSTRAINT HY126001
PRIMARY KEY (HY126001,
HY126002,
HY126003,
HY126004,
HY126005,
HY126006))
IN DGDB0366.A126A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE GDB0366.THY126G1 IS 'ERWEITERTE ABSCHLUESSE ALL';
--
LABEL ON GDB0366.THY126G1
(HY126013 IS 'C_BOLLO',
HY126012 IS 'C_KAS',
HY126011 IS 'A_FEES_EXPNCS',
HY126010 IS 'A_CMMSSN',
HY126009 IS 'A_INTRST',
HY126008 IS 'I_MRTGE_MSTR_20',
HY126007 IS 'I_CIF',
HY126006 IS 'I_CLSRE_T',
HY126005 IS 'D_BOOKING',
HY126004 IS 'D_INT_PRCPL_STMT_1',
HY126003 IS 'D_VALUE_TO',
HY126002 IS 'D_VALUE_FROM',
HY126001 IS 'I_ACNT_16');
--
COMMIT;
--
GRANT USE OF STOGROUP GSMS TO PUBLIC;
--
------------------------------------------------------------------------
-- Database=DGDB0366
-- Index=GDB0366.IHY126A0 On GDB0366.THY126G1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX GDB0366.IHY126G0
ON GDB0366.THY126G1
(HY126001 ASC,
HY126002 ASC,
HY126003 ASC,
HY126004 ASC,
HY126005 ASC,
HY126006 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP0
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0366
-- Index=GDB0366.IHY126A2 On GDB0366.THY126G1
------------------------------------------------------------------------
--
CREATE INDEX GDB0366.IHY126G2
ON GDB0366.THY126G1
(HY126007 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP0
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0366
-- Index=GDB0366.IHY126G1 On GDB0366.THY126G1
------------------------------------------------------------------------
--
CREATE INDEX GDB0366.IHY126G1
ON GDB0366.THY126G1
(HY126008 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP0
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=GDB0366.VHY126G1V
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","GDB0235" ;
--
CREATE VIEW GDB0366.VHY126G1V(I_ACNT_16, D_VALUE_FROM, D_VALUE_TO,
D_INT_PRCPL_STMT_1, D_BOOKING, I_CLSRE_T, I_CIF,
I_MRTGE_MSTR_20, A_INTRST, A_CMMSSN, A_FEES_EXPNCS, C_KAS,
C_BOLLO) AS
SELECT ALL GDB0366.THY126G1.HY126001, GDB0366.THY126G1.HY126002,
GDB0366.THY126G1.HY126003, GDB0366.THY126G1.HY126004,
GDB0366.THY126G1.HY126005, GDB0366.THY126G1.HY126006,
GDB0366.THY126G1.HY126007, GDB0366.THY126G1.HY126008,
GDB0366.THY126G1.HY126009, GDB0366.THY126G1.HY126010,
GDB0366.THY126G1.HY126011, GDB0366.THY126G1.HY126012,
GDB0366.THY126G1.HY126013
FROM GDB0366.THY126G1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--