zOs/SQL/TWL800NE
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBOL (810) Extract time : 2007-06-28 14:58 --
-- --
-- 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=N DB=Y TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Tablespace=S800A In Database DA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769 Stogroup=GSMS (for partition 1)
-- Tablespace=DA540769.S800A
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
--
CREATE DATABASE DA540769
BUFFERPOOL BP2
INDEXBP BP1
CCSID EBCDIC
STOGROUP GSMS;
COMMIT;
CREATE TABLESPACE S800A
IN DA540769
USING STOGROUP GSMS
PRIQTY 129600 SECQTY 129600
FREEPAGE 0 PCTFREE 0
NUMPARTS 11
BUFFERPOOL BP2
LOCKSIZE ANY
COMPRESS YES DSSIZE 4G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=A540769.TXY800A1 In DA540769.S800A
------------------------------------------------------------------------
--
SET CURRENT SQLID='A540769';
--
CREATE TABLE A540769.TXY800A1
(XY80000 CHAR(13) NOT NULL,
XY80001 CHAR(13) NOT NULL,
XY80002 CHAR(6) NOT NULL,
XY80003 CHAR(1) NOT NULL,
XY80004 CHAR(2) NOT NULL,
XY80005 CHAR(2) NOT NULL,
XY80006 DECIMAL(15, 3) NOT NULL,
XY80007 CHAR(1) NOT NULL,
XY80008 CHAR(3) NOT NULL,
XY80009 CHAR(2) NOT NULL,
XY80010 CHAR(2) NOT NULL,
XY80011 CHAR(13) NOT NULL,
XY80012 CHAR(24) NOT NULL,
XY80013 CHAR(24) NOT NULL,
XY80014 CHAR(2) NOT NULL,
XY80015 CHAR(3) NOT NULL,
XY80016 DATE NOT NULL,
XY80017 DATE NOT NULL,
XY80018 CHAR(1) NOT NULL,
XY80019 DECIMAL(15, 3) NOT NULL,
XY80020 CHAR(3) NOT NULL,
XY80021 DECIMAL(15, 3) NOT NULL,
XY80022 CHAR(2) NOT NULL,
XY80023 CHAR(2) NOT NULL,
XY80025 CHAR(1) NOT NULL,
XY80027 CHAR(12) NOT NULL,
XY80028 CHAR(50) NOT NULL,
XY80029 CHAR(12) NOT NULL,
XY80030 CHAR(33) NOT NULL,
XY80031 CHAR(33) NOT NULL,
XY80032 CHAR(2) NOT NULL,
XY80033 CHAR(4) NOT NULL,
XY80034 CHAR(1) NOT NULL,
XY80035 CHAR(16) NOT NULL,
XY80036 CHAR(2) NOT NULL WITH DEFAULT,
XY80037 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
XY80038 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
XY80039 CHAR(2) NOT NULL WITH DEFAULT,
XY80040 CHAR(16) NOT NULL WITH DEFAULT,
XY80041 CHAR(16) NOT NULL WITH DEFAULT,
XY80042 CHAR(4) NOT NULL WITH DEFAULT,
XY80043 CHAR(1) NOT NULL WITH DEFAULT,
XY80044 CHAR(2) NOT NULL WITH DEFAULT,
XY80045 CHAR(1) NOT NULL WITH DEFAULT)
IN DA540769.S800A;
--
LABEL ON TABLE A540769.TXY800A1 IS 'Journaleintrag';
--
LABEL ON A540769.TXY800A1
(XY80045 IS 'Herkunfts-RZ',
XY80044 IS 'Anlagebestand',
XY80043 IS 'Botengeschäft',
XY80042 IS 'BUID Kunde',
XY80041 IS 'HB-Konto 2',
XY80040 IS 'HB-Konto 1',
XY80039 IS 'Abgleichcode',
XY80038 IS 'abgerechneter Betrag 2',
XY80037 IS 'abgerechneter Betrag 1',
XY80036 IS 'Mandantencode/Legal Entity',
XY80035 IS 'Depotnummer',
XY80034 IS 'Nominal-/Stück-Notiz',
XY80033 IS 'Kant. Händler',
XY80032 IS 'Partnercode',
XY80031 IS 'Kundendomizil',
XY80030 IS 'Kundenadresse',
XY80029 IS 'CIF-Nummer',
XY80028 IS 'Valorentext',
XY80027 IS 'WS80-Valorennummer',
XY80025 IS 'Titelherkunft',
XY80023 IS 'Terminmonat',
XY80022 IS 'Handelsbankstelle',
XY80021 IS 'Börsenkurs',
XY80020 IS 'Transaktionswährung',
XY80019 IS 'Nominal/Stück',
XY80018 IS 'Liefercode',
XY80017 IS 'Abrechnungsdatum',
XY80016 IS 'Abschlussdatum',
XY80015 IS 'Börsenplatz',
XY80014 IS 'WS80-GA',
XY80013 IS 'Auftragsnummer',
XY80012 IS 'Storno: Auftragsnr. Original',
XY80011 IS 'Storno: ID Original',
XY80010 IS 'Journalkorrektur',
XY80009 IS 'Stempelübersteuerung',
XY80008 IS 'Kant. Gebühr',
XY80007 IS 'Eidg. Abgabe',
XY80006 IS 'Entgelt',
XY80005 IS 'Nachtrag aus Storno',
XY80004 IS 'Journalrubrik',
XY80003 IS 'Achat/Vente',
XY80002 IS 'Journalmonat',
XY80001 IS 'ID Paarung',
XY80000 IS 'Identifikation');
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IXY800A1 On A540769.TXY800A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX A540769.IXY800A1
ON A540769.TXY800A1
(XY80000 ASC)
USING STOGROUP GSMS
PRIQTY 129600 SECQTY 129600
FREEPAGE 8 PCTFREE 25
BUFFERPOOL BP1 COPY NO;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IXY800A2 On A540769.TXY800A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX A540769.IXY800A2
ON A540769.TXY800A1
(XY80004 ASC,
XY80002 ASC,
XY80027 ASC,
XY80003 DESC,
XY80016 ASC,
XY80017 ASC,
XY80000 ASC)
USING STOGROUP GSMS
PRIQTY 129600 SECQTY 129600
FREEPAGE 8 PCTFREE 25
BUFFERPOOL BP1 COPY NO;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IXY800A3 On A540769.TXY800A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX A540769.IXY800A3
ON A540769.TXY800A1
(XY80004 ASC,
XY80016 ASC,
XY80027 ASC,
XY80000 ASC)
USING STOGROUP GSMS
PRIQTY 129600 SECQTY 129600
FREEPAGE 8 PCTFREE 25
BUFFERPOOL BP1 COPY NO;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IXY800A4 On A540769.TXY800A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX A540769.IXY800A4
ON A540769.TXY800A1
(XY80013 ASC,
XY80000 ASC)
USING STOGROUP GSMS
PRIQTY 129600 SECQTY 129600
FREEPAGE 8 PCTFREE 25
BUFFERPOOL BP1 COPY NO;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IXY800A5 On A540769.TXY800A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX A540769.IXY800A5
ON A540769.TXY800A1
(XY80027 ASC,
XY80003 DESC,
XY80016 ASC,
XY80017 ASC,
XY80004 ASC,
XY80000 ASC)
USING STOGROUP GSMS
PRIQTY 7200 SECQTY 129600
FREEPAGE 8 PCTFREE 20
CLUSTER
(PART 1 VALUES('000099999999'),
PART 2 VALUES('000199999999'),
PART 3 VALUES('000299999999'),
PART 4 VALUES('000399999999'),
PART 5 VALUES('000499999999'),
PART 6 VALUES('000599999999'),
PART 7 VALUES('000699999999'),
PART 8 VALUES('000799999999'),
PART 9 VALUES('000899999999'),
PART 10 VALUES('000999999999'),
PART 11 VALUES('999999999999'))
BUFFERPOOL BP1 COPY NO;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IXY800A6 On A540769.TXY800A1
------------------------------------------------------------------------
--
CREATE INDEX A540769.IXY800A6
ON A540769.TXY800A1
(XY80002 ASC,
XY80003 ASC,
XY80014 ASC,
XY80027 ASC,
XY80004 ASC)
USING STOGROUP GSMS
PRIQTY 129600 SECQTY 129600
FREEPAGE 8 PCTFREE 25
BUFFERPOOL BP1 COPY NO;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IXY800A8 On A540769.TXY800A1
------------------------------------------------------------------------
--
CREATE INDEX A540769.IXY800A8
ON A540769.TXY800A1
(XY80035 ASC,
XY80000 ASC,
XY80036 ASC,
XY80004 ASC)
USING STOGROUP GSMS
PRIQTY 129600 SECQTY 129600
FREEPAGE 16 PCTFREE 15
BUFFERPOOL BP1 COPY NO;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--