zOs/TX/WK962DDL
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : SRC WA01018C 2 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2010-08-02 09:45 --
-- --
-- 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=Y UF=Y SP=Y SQ=Y RO=N TC=N --
-- Grants : SG=N DB=N TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=a962a In Database $db --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=$db Stogroup=GSMS (for partition 1)
-- Table space=$db.a962a
------------------------------------------------------------------------
--
drop tablespace $db.a962a;
drop tablespace $db.a962h;
drop tablespace $db.a962hhh;
drop tablespace $db.a962k;
drop tablespace $db.a962kkk;
drop tablespace $db.a962l ;
drop tablespace $db.a962lll;
commit;
$@[
if $phase = 1 then $@=[
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : TRG WA01018C 2 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2010-08-02 09:45 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=Y DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=Y UF=Y SP=Y SQ=Y RO=Y TC=Y --
-- Grants : SG=N DB=Y TS=Y TB=Y VW=Y SC=Y UT=Y UF=Y SP=Y SQ=Y --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A962A In Database $db --
-- --
------------------------------------------------------------------------
--
--
--
------------------------------------------------------------------------
-- Database=$db Stogroup=GSMS (for partition 1)
-- Table space=$db.A962A
------------------------------------------------------------------------
--
CREATE TABLESPACE A962A
IN $db
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
NUMPARTS 2
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=$creator.TWK962A1 In $db.A962A
------------------------------------------------------------------------
--
CREATE TABLE $creator.TWK962A1
(WA0102 TIMESTAMP NOT NULL,
WA0104I INTEGER NOT NULL,
WA0104K CHAR(1) FOR SBCS DATA NOT NULL,
WA0104V DECIMAL(15, 0) NOT NULL,
WA0104L SMALLINT NOT NULL,
WA0104A CHAR(4) FOR SBCS DATA NOT NULL,
WA0104B DECIMAL(15, 0) NOT NULL,
WA0110 CHAR(5) FOR SBCS DATA NOT NULL,
WA0112 INTEGER NOT NULL,
WA0112D CHAR(4) FOR SBCS DATA NOT NULL,
WA0112E CHAR(4) FOR SBCS DATA NOT NULL,
WA01123 CHAR(4) FOR SBCS DATA NOT NULL,
WA0112R CHAR(4) FOR SBCS DATA NOT NULL,
WA0120 CHAR(1) FOR SBCS DATA NOT NULL,
WA0122 DECIMAL(15, 3) NOT NULL,
WA0124 DECIMAL(15, 3) NOT NULL,
WA0126 DECIMAL(15, 3) NOT NULL,
WA0128 DECIMAL(15, 3) NOT NULL,
WA0130 DECIMAL(15, 3) NOT NULL,
WA0132 DECIMAL(15, 3) NOT NULL,
WA0134 DECIMAL(15, 3) NOT NULL,
WA0136 CHAR(1) FOR SBCS DATA NOT NULL,
WA0138 DECIMAL(15, 3) NOT NULL,
WA0140 DECIMAL(15, 3) NOT NULL,
WA0142 DECIMAL(15, 3) NOT NULL,
WA0144 DECIMAL(15, 3) NOT NULL,
WA0146 FLOAT NOT NULL,
WA0148 DECIMAL(15, 3) NOT NULL,
WA0170Q CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA0170B DECIMAL(15, 3) NOT NULL WITH DEFAULT,
WA0180S CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT)
IN $db.A962A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON $creator.TWK962A1
(WA0180S IS 'MUTTER VALOR SEQUENZ',
WA0170B IS 'BERECH.BASIS UMSATZABGABE',
WA0170Q IS 'P-PROZENT M-MAXIMAL',
WA0148 IS 'BESTAND VERFALLEN LASSEN',
WA0146 IS 'UEBERGABE N/STK VEGA:WA18-WI01',
WA0144 IS 'BESTAND NICHTS UNTERNEHMEN',
WA0142 IS 'BOERSE DISPOSITION N/STK',
WA0140 IS 'AUFTEILUNG FRAKTIONSANTEIL',
WA0138 IS 'AUFTEILUNG GANZZAHLIG',
WA0136 IS 'KENNZEICHEN FRAKTIONSBESTAND',
WA0134 IS 'BESTAND COUPEX N/STK',
WA0132 IS 'BESTAND PROV.DISPONIERT N/STK',
WA0130 IS 'BESTAND VEGA ABGERECHNETN/STK',
WA0128 IS 'BESTAND ZUGETEILT N/STK',
WA0126 IS 'BESTAND VEGA DISPONIERT N/STK',
WA0124 IS 'BESTAND BERECHTIGT N/STK',
WA0122 IS 'BESTAND PER EX N/STK',
WA0120 IS 'BESTANDESTYP',
WA0112R IS 'RUBRIK',
WA01123 IS '3RD DEPOTSTELLEN',
WA0112E IS 'EFFECTIVE DEPOTSTELLEN',
WA0112D IS 'DEPOTSTELLEN',
WA0112 IS 'ID_LFNR DER DEPOTSTELLEN',
WA0110 IS 'SEQUENZNR',
WA0104B IS 'AUFTRAG NO DATUM+LFNR',
WA0104A IS 'AUFTRAG NO TERM_ID',
WA0104L IS 'VV_SEG_LFNR',
WA0104V IS 'VALORENNR',
WA0104K IS 'VALOREN KENNZEICHNUNG',
WA0104I IS 'AKTIONSNR-ID',
WA0102 IS 'MUTATIONSDATUM');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962A0 On $creator.TWK962A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.IWK962A0
ON $creator.TWK962A1
(WA0104I ASC,
WA0104K ASC,
WA0104V ASC,
WA0104L ASC,
WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES(2147483647, 'M'),
PART 2 VALUES(2147483647, 'Z'))
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962A1 On $creator.TWK962A1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962A1
ON $creator.TWK962A1
(WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962A2 On $creator.TWK962A1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962A2
ON $creator.TWK962A1
(WA0104I ASC,
WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962A6 On $creator.TWK962A1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962A6
ON $creator.TWK962A1
(WA0136 ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
$*(
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table=$creator.TWK962H1
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Table=$creator.TWK962H1 In $db.A101H
------------------------------------------------------------------------
--
CREATE TABLESPACE A962HHH
IN $db
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
NUMPARTS 2
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
CREATE TABLE $creator.TWK962H1
(WA0101 DATE NOT NULL,
WA0102 TIMESTAMP NOT NULL,
WA0104I INTEGER NOT NULL,
WA0104K CHAR(1) FOR SBCS DATA NOT NULL,
WA0104V DECIMAL(15, 0) NOT NULL,
WA0104L SMALLINT NOT NULL,
WA0104A CHAR(4) FOR SBCS DATA NOT NULL,
WA0104B DECIMAL(15, 0) NOT NULL,
WA0110 CHAR(5) FOR SBCS DATA NOT NULL,
WA0112 INTEGER NOT NULL,
WA0112D CHAR(4) FOR SBCS DATA NOT NULL,
WA0112E CHAR(4) FOR SBCS DATA NOT NULL,
WA01123 CHAR(4) FOR SBCS DATA NOT NULL,
WA0112R CHAR(4) FOR SBCS DATA NOT NULL,
WA0120 CHAR(1) FOR SBCS DATA NOT NULL,
WA0122 DECIMAL(15, 3) NOT NULL,
WA0124 DECIMAL(15, 3) NOT NULL,
WA0126 DECIMAL(15, 3) NOT NULL,
WA0128 DECIMAL(15, 3) NOT NULL,
WA0130 DECIMAL(15, 3) NOT NULL,
WA0132 DECIMAL(15, 3) NOT NULL,
WA0134 DECIMAL(15, 3) NOT NULL,
WA0136 CHAR(1) FOR SBCS DATA NOT NULL,
WA0138 DECIMAL(15, 3) NOT NULL,
WA0140 DECIMAL(15, 3) NOT NULL,
WA0142 DECIMAL(15, 3) NOT NULL,
WA0144 DECIMAL(15, 3) NOT NULL,
WA0146 FLOAT NOT NULL,
WA0148 DECIMAL(15, 3) NOT NULL,
WA0170Q CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA0170B DECIMAL(15, 3) NOT NULL WITH DEFAULT,
WA0180S CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT)
IN $db.A962HHH
PARTITION BY (WA0104K ASC)
(PART 1 VALUES('M'),
PART 2 VALUES('Z'))
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON $creator.TWK962H1
(WA0180S IS 'MUTTER VALOR SEQUENZ',
WA0170B IS 'BERECH.BASIS UMSATZABGABE',
WA0170Q IS 'P-PROZENT M-MAXIMAL',
WA0148 IS 'BESTAND VERFALLEN LASSEN',
WA0146 IS 'UEBERGABE N/STK VEGA:WA18-WI01',
WA0144 IS 'BESTAND NICHTS UNTERNEHMEN',
WA0142 IS 'BOERSE DISPOSITION N/STK',
WA0140 IS 'AUFTEILUNG FRAKTIONSANTEIL',
WA0138 IS 'AUFTEILUNG GANZZAHLIG',
WA0136 IS 'KENNZEICHEN FRAKTIONSBESTAND',
WA0134 IS 'BESTAND COUPEX N/STK',
WA0132 IS 'BESTAND PROV.DISPONIERT N/STK',
WA0130 IS 'BESTAND VEGA ABGERECHNETN/STK',
WA0128 IS 'BESTAND ZUGETEILT N/STK',
WA0126 IS 'BESTAND VEGA DISPONIERT N/STK',
WA0124 IS 'BESTAND BERECHTIGT N/STK',
WA0122 IS 'BESTAND PER EX N/STK',
WA0120 IS 'BESTANDESTYP',
WA0112R IS 'RUBRIK',
WA01123 IS '3RD DEPOTSTELLEN',
WA0112E IS 'EFFECTIVE DEPOTSTELLEN',
WA0112D IS 'DEPOTSTELLEN',
WA0112 IS 'ID_LFNR DER DEPOTSTELLEN',
WA0110 IS 'SEQUENZNR',
WA0104B IS 'AUFTRAG NO DATUM+LFNR',
WA0104A IS 'AUFTRAG NO TERM_ID',
WA0104L IS 'VV_SEG_LFNR',
WA0104V IS 'VALORENNR',
WA0104K IS 'VALOREN KENNZEICHNUNG',
WA0104I IS 'AKTIONSNR-ID',
WA0102 IS 'MUTATIONSDATUM',
WA0101 IS 'ARCHIVIERUNGSDATUM');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962H0 On $creator.TWK962H1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.IWK962H0
ON $creator.TWK962H1
(WA0104I ASC,
WA0104K ASC,
WA0104V ASC,
WA0104L ASC,
WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962H1 On $creator.TWK962H1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962H1
ON $creator.TWK962H1
(WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962H2 On $creator.TWK962H1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962H2
ON $creator.TWK962H1
(WA0104I ASC,
WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962H6 On $creator.TWK962H1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962H6
ON $creator.TWK962H1
(WA0136 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962H9 On $creator.TWK962H1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962H9
ON $creator.TWK962H1
(WA0101 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A962K In Database $db --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=$db Stogroup=GSMS
-- Table space=$db.A962K
------------------------------------------------------------------------
--
CREATE TABLESPACE A962k
IN $db
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ROW
LOCKMAX 0
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=$creator.TWK962K1 In $db.A962K
------------------------------------------------------------------------
--
CREATE TABLE $creator.TWK962K1
(WA1604 CHAR(20) FOR SBCS DATA NOT NULL,
WA1606 CHAR(16) FOR SBCS DATA NOT NULL,
WA1608 CHAR(12) FOR SBCS DATA NOT NULL,
WA1610 CHAR(5) FOR SBCS DATA NOT NULL,
WA1612 DECIMAL(7, 0) NOT NULL,
WA1620 DECIMAL(15, 0) NOT NULL,
WA1621 SMALLINT NOT NULL,
WA1622 CHAR(4) FOR SBCS DATA NOT NULL,
WA1623 DECIMAL(15, 0) NOT NULL,
WA1624 DECIMAL(15, 3) NOT NULL,
WA1625 DECIMAL(15, 3) NOT NULL,
WA1626 CHAR(1) FOR SBCS DATA NOT NULL,
WA1627 CHAR(1) FOR SBCS DATA NOT NULL,
WA1628 CHAR(3) FOR SBCS DATA NOT NULL,
WA1629 CHAR(3) FOR SBCS DATA NOT NULL,
WA1630 CHAR(3) FOR SBCS DATA NOT NULL,
WA1631 CHAR(3) FOR SBCS DATA NOT NULL,
WA1632 CHAR(2) FOR SBCS DATA NOT NULL,
WA1633 CHAR(4) FOR SBCS DATA NOT NULL,
WA1634 CHAR(4) FOR SBCS DATA NOT NULL,
WA1635 CHAR(4) FOR SBCS DATA NOT NULL,
WA1636 CHAR(4) FOR SBCS DATA NOT NULL,
WA1637 CHAR(4) FOR SBCS DATA NOT NULL,
WA1638 CHAR(4) FOR SBCS DATA NOT NULL,
WA1639 CHAR(4) FOR SBCS DATA NOT NULL,
WA1640 CHAR(3) FOR SBCS DATA NOT NULL,
WA1641 CHAR(8) FOR SBCS DATA NOT NULL,
WA1642 CHAR(4) FOR SBCS DATA NOT NULL,
WA1643 CHAR(16) FOR SBCS DATA NOT NULL,
WA1644 CHAR(16) FOR SBCS DATA NOT NULL,
WA1645 CHAR(3) FOR SBCS DATA NOT NULL,
WA1646 CHAR(4) FOR SBCS DATA NOT NULL,
WA1647 CHAR(4) FOR SBCS DATA NOT NULL,
WA1648 CHAR(4) FOR SBCS DATA NOT NULL,
WA1649 CHAR(1) FOR SBCS DATA NOT NULL,
WA1650 CHAR(25) FOR SBCS DATA NOT NULL,
WA1651 CHAR(1) FOR SBCS DATA NOT NULL,
WA1652 CHAR(3) FOR SBCS DATA NOT NULL,
WA1653 CHAR(2) FOR SBCS DATA NOT NULL,
WA1654 CHAR(1) FOR SBCS DATA NOT NULL,
WA1655 CHAR(2) FOR SBCS DATA NOT NULL,
WA1656 CHAR(1) FOR SBCS DATA NOT NULL,
WA1657 CHAR(2) FOR SBCS DATA NOT NULL,
WA1658 TIMESTAMP NOT NULL,
WA1659 TIMESTAMP NOT NULL,
WA1660 TIMESTAMP NOT NULL,
WA1661 DECIMAL(15, 3) NOT NULL,
WA1662 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1663 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1664 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1665 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1666 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1667 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1668 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT WA1604
PRIMARY KEY (WA1604,
WA1606,
WA1608,
WA1610,
WA1612))
IN $db.A962k
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE $creator.TWK962K1 IS 'Daten Grundbestand VEGA AM';
--
LABEL ON $creator.TWK962K1
(WA1668 IS 'Custody-Account',
WA1667 IS 'US-Person',
WA1666 IS 'Relationship Manager',
WA1665 IS 'Betr-.Stelle alt',
WA1664 IS 'Sprachcode',
WA1663 IS 'FC',
WA1662 IS 'Auftrags-Nr. GUI',
WA1661 IS 'Nom/Stk der Bewegung',
WA1660 IS 'Timestamp POS',
WA1659 IS 'Timestamp MOD',
WA1658 IS 'Timestamp INS',
WA1657 IS 'Verfügbarkeitsgrund',
WA1656 IS 'Verfügbarkeitsstatus',
WA1655 IS 'Selektionsgrund',
WA1654 IS 'Selektionsstatus',
WA1653 IS 'Bew. Abrechnungs-Phase',
WA1652 IS 'Bew. Abrechnungs-GA',
WA1651 IS 'Bew. Abrechnungsart',
WA1650 IS 'Bew. Auftragsnummer',
WA1649 IS 'Depotflag 4',
WA1648 IS 'Depotflag 3',
WA1647 IS 'Depotflag 2',
WA1646 IS 'Depotflag 1',
WA1645 IS 'Titelart',
WA1644 IS 'PM-Betreuungsstelle',
WA1643 IS 'Kundenbüro',
WA1642 IS 'Depotstellenrubrik',
WA1641 IS 'Verfall',
WA1640 IS 'Depotstellenland',
WA1639 IS 'Eff. Depotstelle',
WA1638 IS 'Depotstelle',
WA1637 IS 'BUID',
WA1636 IS 'Vollmacht 5',
WA1635 IS 'Vollmacht 4',
WA1634 IS 'Vollmacht 3',
WA1633 IS 'Vollmacht 2',
WA1632 IS 'Vollmacht 1',
WA1631 IS 'Kundenart',
WA1630 IS 'Depotart',
WA1629 IS 'Nationalität',
WA1628 IS 'Domizil',
WA1627 IS 'Herkunft',
WA1626 IS 'Global Custodian',
WA1625 IS 'Nom/Stk verfügbar',
WA1624 IS 'Nom/Stk',
WA1623 IS 'AuftrNr VEGA-Auftrag',
WA1622 IS 'Term-Id VEGA-Auftrag',
WA1621 IS 'Priorität',
WA1620 IS 'Packet-Id',
WA1612 IS 'Laufnummer',
WA1610 IS 'Sequenznummer',
WA1608 IS 'Valorennummer',
WA1606 IS 'Depotnummer',
WA1604 IS 'Aktionsnummer');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962K01 On $creator.TWK962K1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.IWK962K01
ON $creator.TWK962K1
(WA1604 ASC,
WA1606 ASC,
WA1608 ASC,
WA1610 ASC,
WA1612 ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table=$creator.TWK962L1
-- --
------------------------------------------------------------------------
--
CREATE TABLESPACE A962LLL
IN $db
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ROW
LOCKMAX 0
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
------------------------------------------------------------------------
-- Table=$creator.TWK962L1 In $db.A116H
------------------------------------------------------------------------
--
CREATE TABLE $creator.TWK962L1
(WA1601 DATE NOT NULL,
WA1604 CHAR(20) FOR SBCS DATA NOT NULL,
WA1606 CHAR(16) FOR SBCS DATA NOT NULL,
WA1608 CHAR(12) FOR SBCS DATA NOT NULL,
WA1610 CHAR(5) FOR SBCS DATA NOT NULL,
WA1612 DECIMAL(7, 0) NOT NULL,
WA1620 DECIMAL(15, 0) NOT NULL,
WA1621 SMALLINT NOT NULL,
WA1622 CHAR(4) FOR SBCS DATA NOT NULL,
WA1623 DECIMAL(15, 0) NOT NULL,
WA1624 DECIMAL(15, 3) NOT NULL,
WA1625 DECIMAL(15, 3) NOT NULL,
WA1626 CHAR(1) FOR SBCS DATA NOT NULL,
WA1627 CHAR(1) FOR SBCS DATA NOT NULL,
WA1628 CHAR(3) FOR SBCS DATA NOT NULL,
WA1629 CHAR(3) FOR SBCS DATA NOT NULL,
WA1630 CHAR(3) FOR SBCS DATA NOT NULL,
WA1631 CHAR(3) FOR SBCS DATA NOT NULL,
WA1632 CHAR(2) FOR SBCS DATA NOT NULL,
WA1633 CHAR(4) FOR SBCS DATA NOT NULL,
WA1634 CHAR(4) FOR SBCS DATA NOT NULL,
WA1635 CHAR(4) FOR SBCS DATA NOT NULL,
WA1636 CHAR(4) FOR SBCS DATA NOT NULL,
WA1637 CHAR(4) FOR SBCS DATA NOT NULL,
WA1638 CHAR(4) FOR SBCS DATA NOT NULL,
WA1639 CHAR(4) FOR SBCS DATA NOT NULL,
WA1640 CHAR(3) FOR SBCS DATA NOT NULL,
WA1641 CHAR(8) FOR SBCS DATA NOT NULL,
WA1642 CHAR(4) FOR SBCS DATA NOT NULL,
WA1643 CHAR(16) FOR SBCS DATA NOT NULL,
WA1644 CHAR(16) FOR SBCS DATA NOT NULL,
WA1645 CHAR(3) FOR SBCS DATA NOT NULL,
WA1646 CHAR(4) FOR SBCS DATA NOT NULL,
WA1647 CHAR(4) FOR SBCS DATA NOT NULL,
WA1648 CHAR(4) FOR SBCS DATA NOT NULL,
WA1649 CHAR(1) FOR SBCS DATA NOT NULL,
WA1650 CHAR(25) FOR SBCS DATA NOT NULL,
WA1651 CHAR(1) FOR SBCS DATA NOT NULL,
WA1652 CHAR(3) FOR SBCS DATA NOT NULL,
WA1653 CHAR(2) FOR SBCS DATA NOT NULL,
WA1654 CHAR(1) FOR SBCS DATA NOT NULL,
WA1655 CHAR(2) FOR SBCS DATA NOT NULL,
WA1656 CHAR(1) FOR SBCS DATA NOT NULL,
WA1657 CHAR(2) FOR SBCS DATA NOT NULL,
WA1658 TIMESTAMP NOT NULL,
WA1659 TIMESTAMP NOT NULL,
WA1660 TIMESTAMP NOT NULL,
WA1661 DECIMAL(15, 3) NOT NULL,
WA1662 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1663 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1664 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1665 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1666 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1667 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1668 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT WA1604
PRIMARY KEY (WA1604,
WA1606,
WA1608,
WA1610,
WA1612))
IN $db.A962LLL
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE $creator.TWK962L1 IS 'Daten Grundbestand VEGA AM';
--
LABEL ON $creator.TWK962L1
(WA1668 IS 'Custody-Account',
WA1667 IS 'US-Person',
WA1666 IS 'Relationship Manager',
WA1665 IS 'Betr-.Stelle alt',
WA1664 IS 'Sprachcode',
WA1663 IS 'FC',
WA1662 IS 'Auftrags-Nr. GUI',
WA1661 IS 'Nom/Stk der Bewegung',
WA1660 IS 'Timestamp POS',
WA1659 IS 'Timestamp MOD',
WA1658 IS 'Timestamp INS',
WA1657 IS 'Verfügbarkeitsgrund',
WA1656 IS 'Verfügbarkeitsstatus',
WA1655 IS 'Selektionsgrund',
WA1654 IS 'Selektionsstatus',
WA1653 IS 'Bew. Abrechnungs-Phase',
WA1652 IS 'Bew. Abrechnungs-GA',
WA1651 IS 'Bew. Abrechnungsart',
WA1650 IS 'Bew. Auftragsnummer',
WA1649 IS 'Depotflag 4',
WA1648 IS 'Depotflag 3',
WA1647 IS 'Depotflag 2',
WA1646 IS 'Depotflag 1',
WA1645 IS 'Titelart',
WA1644 IS 'PM-Betreuungsstelle',
WA1643 IS 'Kundenbüro',
WA1642 IS 'Depotstellenrubrik',
WA1641 IS 'Verfall',
WA1640 IS 'Depotstellenland',
WA1639 IS 'Eff. Depotstelle',
WA1638 IS 'Depotstelle',
WA1637 IS 'BUID',
WA1636 IS 'Vollmacht 5',
WA1635 IS 'Vollmacht 4',
WA1634 IS 'Vollmacht 3',
WA1633 IS 'Vollmacht 2',
WA1632 IS 'Vollmacht 1',
WA1631 IS 'Kundenart',
WA1630 IS 'Depotart',
WA1629 IS 'Nationalität',
WA1628 IS 'Domizil',
WA1627 IS 'Herkunft',
WA1626 IS 'Global Custodian',
WA1625 IS 'Nom/Stk verfügbar',
WA1624 IS 'Nom/Stk',
WA1623 IS 'AuftrNr VEGA-Auftrag',
WA1622 IS 'Term-Id VEGA-Auftrag',
WA1621 IS 'Priorität',
WA1620 IS 'Packet-Id',
WA1612 IS 'Laufnummer',
WA1610 IS 'Sequenznummer',
WA1608 IS 'Valorennummer',
WA1606 IS 'Depotnummer',
WA1604 IS 'Aktionsnummer',
WA1601 IS 'ARCHIVIERUNGSDATUM');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962L02 On $creator.TWK962L1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.IWK962L02
ON $creator.TWK962L1
(WA1604 ASC,
WA1606 ASC,
WA1608 ASC,
WA1610 ASC,
WA1612 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
$*( --
------------------------------------------------------------------------
-- View=A242407.VWA030
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","A242407" ;
--
CREATE VIEW A242407.VWA030(K0, K1, K2, K3, K4, K5, K6, K7) AS
SELECT CURRENT TIMESTAMP, TA.C1, TA.C2, TA.C3, C4, TA.C5, TA.C6,
C7
FROM (SELECT DISTINCT oa1a.TWA002A1.WA0204I AS C1,
oa1a.TWA002A1.WA0212 AS C2,
oa1a.TWA002A1.WA0216 AS C3,
SUBSTR(CHAR(DEC($creator.TWK962A1.WA0104V)), 5, 9) ||
SUBSTR(CHAR(DEC($creator.TWK962A1.WA0104L)), 3, 3) AS
C4, $creator.TWK962A1.WA0110 AS C5,
oa1a.TWA002A1.WA0214 AS C6, CASE
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('213',
'222', '223', ' ') THEN 'A'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('251',
'252') THEN 'B'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('255',
'331', '332', '333', '432') THEN 'C'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('261',
'264') THEN 'D'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('321',
'322', '417', '421', '428') THEN 'E'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('422',
'423', '341', '344', '352', '353', '412', '414',
'482', '482', '483', '484') THEN 'F'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('431')
THEN 'G'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('216')
THEN 'H'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('315')
THEN 'J'
WHEN SUBSTR($creator.TWA004A1.WA0404, 13, 3) IN('262',
'265') THEN 'K' ELSE ' ' END AS C7
FROM $creator.TWK962A1,
oa1a.TWA002A1,
$creator.TWA004A1,
$creator.TWA014A1
WHERE NOT EXISTS(SELECT $creator.TWA030A1.WA3004B,
$creator.TWA030A1.WA3004D
FROM $creator.TWA030A1
WHERE oa1a.TWA002A1.WA0204I =
$creator.TWA030A1.WA3004I
AND oa1a.TWA002A1.WA0212 =
$creator.TWA030A1.WA3004B
AND oa1a.TWA002A1.WA0216 =
$creator.TWA030A1.WA3004D)
AND $creator.TWK962A1.WA0104I = oa1a.TWA002A1.WA0204I
AND $creator.TWK962A1.WA0104A = oa1a.TWA002A1.WA0204A
AND $creator.TWK962A1.WA0104B = oa1a.TWA002A1.WA0204B
AND $creator.TWK962A1.WA0104K = 'M'
AND $creator.TWK962A1.WA0110 > '00000'
AND oa1a.TWA002A1.WA0202 >
'2007-11-01-00.00.00.000001'
AND $creator.TWA004A1.WA0404 = $creator.TWA014A1.WA1404A
AND $creator.TWA004A1.WA0408 = oa1a.TWA002A1.WA0204I
AND $creator.TWA014A1.WA1496 = '1') AS TA ;
--
COMMIT;
$*)
--
------------------------------------------------------------------------
-- View=$creator.VWK962A1A
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","S100447" ;
--
CREATE VIEW $creator.VWK962A1A(WA0104I, WA0104K, WA0104V, WA0104L,
WA0104A, WA0104B, WA0110, WA0112D, WA0112E, WA0112R, WA0120,
WA0122, WA0124, WA0126, WA0128, WA0130, WA0134, WA0136, WA0142,
WA0144, WA0208, WA0210, WA0212, WA0216, WA0220, WA0221, WA0222,
WA0224, WA0226, WA0228, WA0230, WA0232, WA0234, WA0236, WA0240,
WA0244, WA0252, WA0253A, WA0253B, WA0254A, WA0254B, WA0256,
WA0258) AS
SELECT DISTINCT $creator.TWK962A1.WA0104I, $creator.TWK962A1.WA0104K,
$creator.TWK962A1.WA0104V, $creator.TWK962A1.WA0104L,
$creator.TWK962A1.WA0104A, $creator.TWK962A1.WA0104B,
$creator.TWK962A1.WA0110, $creator.TWK962A1.WA0112D,
$creator.TWK962A1.WA0112E, $creator.TWK962A1.WA0112R,
$creator.TWK962A1.WA0120, $creator.TWK962A1.WA0122,
$creator.TWK962A1.WA0124, $creator.TWK962A1.WA0126,
$creator.TWK962A1.WA0128, $creator.TWK962A1.WA0130,
$creator.TWK962A1.WA0134, $creator.TWK962A1.WA0136,
$creator.TWK962A1.WA0142, $creator.TWK962A1.WA0144,
oa1a.TWA002A1.WA0208, oa1a.TWA002A1.WA0210,
oa1a.TWA002A1.WA0212, oa1a.TWA002A1.WA0216,
oa1a.TWA002A1.WA0220, oa1a.TWA002A1.WA0221,
oa1a.TWA002A1.WA0222, oa1a.TWA002A1.WA0224,
oa1a.TWA002A1.WA0226, oa1a.TWA002A1.WA0228,
oa1a.TWA002A1.WA0230, oa1a.TWA002A1.WA0232,
oa1a.TWA002A1.WA0234, oa1a.TWA002A1.WA0236,
oa1a.TWA002A1.WA0240, oa1a.TWA002A1.WA0244,
oa1a.TWA002A1.WA0252, oa1a.TWA002A1.WA0253A,
oa1a.TWA002A1.WA0253B, oa1a.TWA002A1.WA0254A,
oa1a.TWA002A1.WA0254B, oa1a.TWA002A1.WA0256,
oa1a.TWA002A1.WA0258
FROM $creator.TWK962A1,
oa1a.TWA002A1
WHERE $creator.TWK962A1.WA0104I = oa1a.TWA002A1.WA0204I
AND $creator.TWK962A1.WA0104A = oa1a.TWA002A1.WA0204A
AND $creator.TWK962A1.WA0104B = oa1a.TWA002A1.WA0204B ;
--
LABEL ON TABLE $creator.VWK962A1A IS 'Join VSD alle MutterValoren';
--
LABEL ON $creator.VWK962A1A
(WA0258 IS 'Auftrag Source',
WA0256 IS 'Auftrag Status',
WA0254B IS 'AUFTR-NR FGA2 DATUM+LFNR',
WA0254A IS 'AUFTR-NR FGA2 TERM-ID',
WA0253B IS 'AUFTR-NR FGA1 DATUM+LFNR',
WA0253A IS 'AUFTR-NR FGA1 TERM-ID',
WA0252 IS 'Wahlmoeglichkeit',
WA0244 IS 'mehrere Aftraege zu Bestand',
WA0240 IS 'RundungsArt: `+` / `-`',
WA0236 IS 'Interessewahrung: N=nein/J=ja',
WA0234 IS 'Visum: `V` / `D` / blank=fehlt',
WA0232 IS 'gewaehlte Variante',
WA0230 IS 'Kundensegment',
WA0228 IS 'Nationalität',
WA0226 IS 'Domizil',
WA0224 IS 'AbrechnungsArt',
WA0222 IS 'KundenArt Kunden=2,Konform=4',
WA0221 IS 'DepotArt',
WA0220 IS 'Bereichsauswahl Identifikator',
WA0216 IS 'DepotStammNR',
WA0212 IS 'IBBB',
WA0208 IS 'BU-ID',
WA0144 IS 'Restbestand N/Stk',
WA0142 IS 'Reserviert fuer Boerse',
WA0136 IS 'Kennzeichen Fraktionsbestand',
WA0134 IS 'Valor Bestand andere N/Stk',
WA0130 IS 'Valor Bestand abgerechnetN/Stk',
WA0128 IS 'Valor Bestand zugeteilt N/Stk',
WA0126 IS 'Valor Bestand disponiert N/Stk',
WA0124 IS 'Valor Bestand berechtigt N/Stk',
WA0122 IS 'Valor Bestand per EX N/Stk',
WA0120 IS 'BestandesTyp',
WA0112R IS 'Rubrik',
WA0112E IS 'Effective DepotStellen',
WA0112D IS 'DepotStellen',
WA0110 IS 'SequenzNR',
WA0104B IS 'PKey Datum+LfNR',
WA0104A IS 'PKey Term_id',
WA0104L IS 'PKey Val.-Lf-Nr',
WA0104V IS 'PKey Val.-Nr',
WA0104K IS 'PKey Mutter/Ziel',
WA0104I IS 'PKey Akt.-Id');
--
GRANT SELECT ON TABLE $creator.VWK962A1A TO $creator;
--
GRANT SELECT ON TABLE $creator.VWK962A1A TO $creator;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA008A1V
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWA008A1V(WA0102, WA0104I, WA0104K, WA0104V,
WA0104L, WA0104A, WA0104B, WA0110, WA0112D, WA0112E, WA01123,
WA0112R, WA0120, WA0122, WA0124, WA0126, WA0128, WA0130, WA0132,
WA0134, WA0136, WA0138, WA0140, WA0142, WA0144, WA0146, WA0148,
WA0202, WA0208, WA0210, WA0212, WA0214, WA0216, WA0220, WA0221,
WA0222, WA0224, WA0226, WA0228, WA0230, WA0232, WA0234, WA0236,
WA0238, WA0240, WA0242, WA0244, WA0246, WA0248, WA0250, WA0252,
WA0253A, WA0253B, WA0254A, WA0254B, WA0256, WA0258) AS
SELECT DISTINCT $creator.TWK962A1.WA0102, $creator.TWK962A1.WA0104I,
$creator.TWK962A1.WA0104K, $creator.TWK962A1.WA0104V,
$creator.TWK962A1.WA0104L, $creator.TWK962A1.WA0104A,
$creator.TWK962A1.WA0104B, $creator.TWK962A1.WA0110,
$creator.TWK962A1.WA0112D, $creator.TWK962A1.WA0112E,
$creator.TWK962A1.WA01123, $creator.TWK962A1.WA0112R,
$creator.TWK962A1.WA0120, $creator.TWK962A1.WA0122,
$creator.TWK962A1.WA0124, $creator.TWK962A1.WA0126,
$creator.TWK962A1.WA0128, $creator.TWK962A1.WA0130,
$creator.TWK962A1.WA0132, $creator.TWK962A1.WA0134,
$creator.TWK962A1.WA0136, $creator.TWK962A1.WA0138,
$creator.TWK962A1.WA0140, $creator.TWK962A1.WA0142,
$creator.TWK962A1.WA0144, $creator.TWK962A1.WA0146,
$creator.TWK962A1.WA0148, oa1a.TWA002A1.WA0202,
oa1a.TWA002A1.WA0208, oa1a.TWA002A1.WA0210,
oa1a.TWA002A1.WA0212, oa1a.TWA002A1.WA0214,
oa1a.TWA002A1.WA0216, oa1a.TWA002A1.WA0220,
oa1a.TWA002A1.WA0221, oa1a.TWA002A1.WA0222,
oa1a.TWA002A1.WA0224, oa1a.TWA002A1.WA0226,
oa1a.TWA002A1.WA0228, oa1a.TWA002A1.WA0230,
oa1a.TWA002A1.WA0232, oa1a.TWA002A1.WA0234,
oa1a.TWA002A1.WA0236, oa1a.TWA002A1.WA0238,
oa1a.TWA002A1.WA0240, oa1a.TWA002A1.WA0242,
oa1a.TWA002A1.WA0244, oa1a.TWA002A1.WA0246,
oa1a.TWA002A1.WA0248, oa1a.TWA002A1.WA0250,
oa1a.TWA002A1.WA0252, oa1a.TWA002A1.WA0253A,
oa1a.TWA002A1.WA0253B, oa1a.TWA002A1.WA0254A,
oa1a.TWA002A1.WA0254B, oa1a.TWA002A1.WA0256,
oa1a.TWA002A1.WA0258
FROM $creator.TWK962A1,
oa1a.TWA002A1
WHERE $creator.TWK962A1.WA0104I = oa1a.TWA002A1.WA0204I
AND $creator.TWK962A1.WA0104A = oa1a.TWA002A1.WA0204A
AND $creator.TWK962A1.WA0104B = oa1a.TWA002A1.WA0204B ;
--
LABEL ON TABLE $creator.VWA008A1V IS 'JOIN VSD MUTTER+ZIELVALOREN';
--
LABEL ON $creator.VWA008A1V
(WA0258 IS 'Auftrag Source',
WA0256 IS 'Auftrag Status',
WA0254B IS 'AUFTR-NR FGA2 DATUM+LFNR',
WA0254A IS 'AUFTR-NR FGA2 TERM-ID',
WA0253B IS 'AUFTR-NR FGA1 DATUM+LFNR',
WA0253A IS 'AUFTR-NR FGA1 TERM-ID',
WA0252 IS 'Wahlmoeglichkeit',
WA0250 IS 'RZ-Zugehörigkeit: `2` / `3`',
WA0248 IS 'Auftrag auf P90 vorhanden J/N',
WA0246 IS 'AbrechDatum bei Auftragfreigab',
WA0244 IS 'mehrere Aftraege zu Bestand',
WA0242 IS 'DispositionsArt: `A` / `B`',
WA0240 IS 'RundungsArt: `+` / `-`',
WA0238 IS 'Satus Interessewahrung: 0,1,4',
WA0236 IS 'Interessewahrung: N=nein/J=ja',
WA0234 IS 'Visum: `V` / `D` / blank=fehlt',
WA0232 IS 'gewaehlte Variante',
WA0230 IS 'KundenSegment',
WA0228 IS 'Nationalitaet',
WA0226 IS 'Domizil',
WA0224 IS 'AbrechnungsArt',
WA0222 IS 'KundenArt Kunden=2,Konform=4',
WA0221 IS 'DepotArt',
WA0220 IS 'Bereichsauswahl Identifikator',
WA0216 IS 'DepotStammNR',
WA0214 IS 'CifNR',
WA0212 IS 'IBBB',
WA0210 IS 'KopfBankstelle',
WA0208 IS 'BU-ID',
WA0202 IS 'StammDaten TimeStamp',
WA0148 IS 'Bestand Verfallen Lassen',
WA0146 IS 'Uebergabe N/Stk VEGA:WA18-WI01',
WA0144 IS 'Bestand Nichts Unternehmen',
WA0142 IS 'Reserviert fuer Boerse',
WA0140 IS 'Aufteil. Fraktions Anteil',
WA0138 IS 'Aufteil. Ganzzaehliger Anteil',
WA0136 IS 'Kennzeichen Fraktionsbestand',
WA0134 IS 'Valor Bestand andere N/Stk',
WA0132 IS 'Valor Prov. disponiert N/Stk',
WA0130 IS 'Valor Bestand abgerechnetN/Stk',
WA0128 IS 'Valor Bestand zugeteilt N/Stk',
WA0126 IS 'Valor Bestand disponiert N/Stk',
WA0124 IS 'Valor Bestand berechtigt N/Stk',
WA0122 IS 'Valor Bestand per EX N/Stk',
WA0120 IS 'BestandesTyp',
WA0112R IS 'Rubrik',
WA01123 IS '3rd DepotStellen',
WA0112E IS 'Effective DepotStellen',
WA0112D IS 'DepotStellen',
WA0110 IS 'SequenzNR',
WA0104B IS 'PKey Datum+LfNR',
WA0104A IS 'PKey Term_id',
WA0104L IS 'PKey VV_Seg_LfNR',
WA0104V IS 'Pkey ValorenNR',
WA0104K IS 'PKey Valoren-KnZ',
WA0104I IS 'PKey AktionsNR-ID',
WA0102 IS 'Valor TimeStamp');
--
GRANT SELECT ON TABLE $creator.VWA008A1V TO $creator;
--
GRANT SELECT ON TABLE $creator.VWA008A1V TO $creator;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA009A1V
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","GDB0183" ;
--
CREATE VIEW $creator.VWA009A1V(WA0102, WA0104I, WA0104K, WA0104V,
WA0104L, WA0104A, WA0104B, WA0110, WA0112D, WA0112E, WA01123,
WA0112R, WA0120, WA0122, WA0124, WA0126, WA0128, WA0130, WA0132,
WA0134, WA0136, WA0138, WA0140, WA0142, WA0144, WA0146, WA0148,
WA0202, WA0208, WA0210, WA0212, WA0214, WA0216, WA0220, WA0221,
WA0222, WA0224, WA0226, WA0228, WA0230, WA0232, WA0234, WA0236,
WA0238, WA0240, WA0242, WA0244, WA0246, WA0248, WA0250, WA0252,
WA0253A, WA0253B, WA0254A, WA0254B, WA0256, WA0258, WA0260V,
WA0260C, WA0260B, WA0262, WA0264) AS
SELECT DISTINCT $creator.TWK962A1.WA0102, $creator.TWK962A1.WA0104I,
$creator.TWK962A1.WA0104K, $creator.TWK962A1.WA0104V,
$creator.TWK962A1.WA0104L, $creator.TWK962A1.WA0104A,
$creator.TWK962A1.WA0104B, $creator.TWK962A1.WA0110,
$creator.TWK962A1.WA0112D, $creator.TWK962A1.WA0112E,
$creator.TWK962A1.WA01123, $creator.TWK962A1.WA0112R,
$creator.TWK962A1.WA0120, $creator.TWK962A1.WA0122,
$creator.TWK962A1.WA0124, $creator.TWK962A1.WA0126,
$creator.TWK962A1.WA0128, $creator.TWK962A1.WA0130,
$creator.TWK962A1.WA0132, $creator.TWK962A1.WA0134,
$creator.TWK962A1.WA0136, $creator.TWK962A1.WA0138,
$creator.TWK962A1.WA0140, $creator.TWK962A1.WA0142,
$creator.TWK962A1.WA0144, $creator.TWK962A1.WA0146,
$creator.TWK962A1.WA0148, oa1a.TWA002A1.WA0202,
oa1a.TWA002A1.WA0208, oa1a.TWA002A1.WA0210,
oa1a.TWA002A1.WA0212, oa1a.TWA002A1.WA0214,
oa1a.TWA002A1.WA0216, oa1a.TWA002A1.WA0220,
oa1a.TWA002A1.WA0221, oa1a.TWA002A1.WA0222,
oa1a.TWA002A1.WA0224, oa1a.TWA002A1.WA0226,
oa1a.TWA002A1.WA0228, oa1a.TWA002A1.WA0230,
oa1a.TWA002A1.WA0232, oa1a.TWA002A1.WA0234,
oa1a.TWA002A1.WA0236, oa1a.TWA002A1.WA0238,
oa1a.TWA002A1.WA0240, oa1a.TWA002A1.WA0242,
oa1a.TWA002A1.WA0244, oa1a.TWA002A1.WA0246,
oa1a.TWA002A1.WA0248, oa1a.TWA002A1.WA0250,
oa1a.TWA002A1.WA0252, oa1a.TWA002A1.WA0253A,
oa1a.TWA002A1.WA0253B, oa1a.TWA002A1.WA0254A,
oa1a.TWA002A1.WA0254B, oa1a.TWA002A1.WA0256,
oa1a.TWA002A1.WA0258, oa1a.TWA002A1.WA0260V,
oa1a.TWA002A1.WA0260C, oa1a.TWA002A1.WA0260B,
oa1a.TWA002A1.WA0262, oa1a.TWA002A1.WA0264
FROM $creator.TWK962A1,
oa1a.TWA002A1
WHERE $creator.TWK962A1.WA0104I = oa1a.TWA002A1.WA0204I
AND $creator.TWK962A1.WA0104K = 'M'
AND $creator.TWK962A1.WA0104A = oa1a.TWA002A1.WA0204A
AND $creator.TWK962A1.WA0104B = oa1a.TWA002A1.WA0204B ;
--
LABEL ON TABLE $creator.VWA009A1V IS 'Join VSD Nur MutterValoren';
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA015A1V
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWA015A1V(WA0102, WA0104I, WA0104K, WA0104V,
WA0104L, WA0104A, WA0104B, WA0110, WA0112D, WA0112E, WA01123,
WA0112R, WA0120, WA0122, WA0124, WA0126, WA0128, WA0130, WA0132,
WA0134, WA0136, WA0138, WA0140, WA0142, WA0144, WA0232, WA0234,
WA0252) AS
SELECT DISTINCT $creator.TWK962A1.WA0102, $creator.TWK962A1.WA0104I,
$creator.TWK962A1.WA0104K, $creator.TWK962A1.WA0104V,
$creator.TWK962A1.WA0104L, $creator.TWK962A1.WA0104A,
$creator.TWK962A1.WA0104B, $creator.TWK962A1.WA0110,
$creator.TWK962A1.WA0112D, $creator.TWK962A1.WA0112E,
$creator.TWK962A1.WA01123, $creator.TWK962A1.WA0112R,
$creator.TWK962A1.WA0120, $creator.TWK962A1.WA0122,
$creator.TWK962A1.WA0124, $creator.TWK962A1.WA0126,
$creator.TWK962A1.WA0128, $creator.TWK962A1.WA0130,
$creator.TWK962A1.WA0132, $creator.TWK962A1.WA0134,
$creator.TWK962A1.WA0136, $creator.TWK962A1.WA0138,
$creator.TWK962A1.WA0140, $creator.TWK962A1.WA0142,
$creator.TWK962A1.WA0144, oa1a.TWA002A1.WA0232,
oa1a.TWA002A1.WA0234, oa1a.TWA002A1.WA0252
FROM $creator.TWK962A1,
oa1a.TWA002A1
WHERE $creator.TWK962A1.WA0104K = 'M'
AND $creator.TWK962A1.WA0104I = oa1a.TWA002A1.WA0204I
AND $creator.TWK962A1.WA0104A = oa1a.TWA002A1.WA0204A
AND $creator.TWK962A1.WA0104B = oa1a.TWA002A1.WA0204B ;
--
LABEL ON TABLE $creator.VWA015A1V IS 'Join VD Muttervaloren';
--
LABEL ON $creator.VWA015A1V
(WA0252 IS 'Wahlmöglichkeit ',
WA0234 IS 'Visum ',
WA0232 IS 'gewaehlte Variante ',
WA0144 IS 'Restbestand N/Stk',
WA0142 IS 'Reserviert fuer Boerse ',
WA0140 IS 'Aufteil. Fraktions Anteil ',
WA0138 IS 'Aufteil. Ganzzaehliger Anteil ',
WA0136 IS 'Kennzeichen Fraktionsbestand',
WA0134 IS 'Valor Bestand andere N/Stk',
WA0132 IS 'Valor Prov. disponiert N/Stk',
WA0130 IS 'Valor Bestand abgerechnetN/Stk',
WA0128 IS 'Valor Bestand zugeteilt N/Stk',
WA0126 IS 'Valor Bestand disponiert N/Stk',
WA0124 IS 'Valor Bestand berechtigt N/Stk',
WA0122 IS 'Valor Bestand per EX N/Stk',
WA0120 IS 'BestandesTyp',
WA0112R IS 'Rubrik',
WA01123 IS '3rd DepotStellen',
WA0112E IS 'Effective DepotStellen',
WA0112D IS 'DepotStellen',
WA0110 IS 'SequenzNR',
WA0104B IS 'PKey Datum+LfNR',
WA0104A IS 'PKey Term_id',
WA0104L IS 'PKey VV_Seg_LfNR',
WA0104V IS 'Pkey ValorenNR',
WA0104K IS 'PKey Valoren-KnZ',
WA0104I IS 'PKey AktionsNR-ID',
WA0102 IS 'Valor TimeStamp');
--
GRANT SELECT ON TABLE $creator.VWA015A1V TO $creator;
--
GRANT SELECT ON TABLE $creator.VWA015A1V TO $creator;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWK962H1A
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","$creator" ;
--
CREATE VIEW $creator.VWK962H1A(WA0104I, WA0104K, WA0104V, WA0104L,
WA0104A, WA0104B, WA0110, WA0112D, WA0112E, WA0112R, WA0120,
WA0122, WA0124, WA0126, WA0128, WA0130, WA0134, WA0136, WA0142,
WA0144, WA0208, WA0210, WA0212, WA0216, WA0220, WA0221, WA0222,
WA0224, WA0226, WA0228, WA0230, WA0232, WA0234, WA0236, WA0240,
WA0244, WA0252, WA0253A, WA0253B, WA0254A, WA0254B, WA0256,
WA0258) AS
SELECT DISTINCT $creator.TWK962H1.WA0104I, $creator.TWK962H1.WA0104K,
$creator.TWK962H1.WA0104V, $creator.TWK962H1.WA0104L,
$creator.TWK962H1.WA0104A, $creator.TWK962H1.WA0104B,
$creator.TWK962H1.WA0110, $creator.TWK962H1.WA0112D,
$creator.TWK962H1.WA0112E, $creator.TWK962H1.WA0112R,
$creator.TWK962H1.WA0120, $creator.TWK962H1.WA0122,
$creator.TWK962H1.WA0124, $creator.TWK962H1.WA0126,
$creator.TWK962H1.WA0128, $creator.TWK962H1.WA0130,
$creator.TWK962H1.WA0134, $creator.TWK962H1.WA0136,
$creator.TWK962H1.WA0142, $creator.TWK962H1.WA0144,
oa1a.TWA002A1.WA0208, oa1a.TWA002A1.WA0210,
oa1a.TWA002A1.WA0212, oa1a.TWA002A1.WA0216,
oa1a.TWA002A1.WA0220, oa1a.TWA002A1.WA0221,
oa1a.TWA002A1.WA0222, oa1a.TWA002A1.WA0224,
oa1a.TWA002A1.WA0226, oa1a.TWA002A1.WA0228,
oa1a.TWA002A1.WA0230, oa1a.TWA002A1.WA0232,
oa1a.TWA002A1.WA0234, oa1a.TWA002A1.WA0236,
oa1a.TWA002A1.WA0240, oa1a.TWA002A1.WA0244,
oa1a.TWA002A1.WA0252, oa1a.TWA002A1.WA0253A,
oa1a.TWA002A1.WA0253B, oa1a.TWA002A1.WA0254A,
oa1a.TWA002A1.WA0254B, oa1a.TWA002A1.WA0256,
oa1a.TWA002A1.WA0258
FROM $creator.TWK962H1,
oa1a.TWA002A1
WHERE $creator.TWK962H1.WA0104I = oa1a.TWA002A1.WA0204I
AND $creator.TWK962H1.WA0104A = oa1a.TWA002A1.WA0204A
AND $creator.TWK962H1.WA0104B = oa1a.TWA002A1.WA0204B ;
--
LABEL ON TABLE $creator.VWK962H1A IS 'Join VSD alle MutterValoren';
--
LABEL ON $creator.VWK962H1A
(WA0258 IS 'Auftrag Source',
WA0256 IS 'Auftrag Status',
WA0254B IS 'AUFTR-NR FGA2 DATUM+LFNR',
WA0254A IS 'AUFTR-NR FGA2 TERM-ID',
WA0253B IS 'AUFTR-NR FGA1 DATUM+LFNR',
WA0253A IS 'AUFTR-NR FGA1 TERM-ID',
WA0252 IS 'Wahlmoeglichkeit',
WA0244 IS 'mehrere Aftraege zu Bestand',
WA0240 IS 'RundungsArt: `+` / `-`',
WA0236 IS 'Interessewahrung: N=nein/J=ja',
WA0234 IS 'Visum: `V` / `D` / blank=fehlt',
WA0232 IS 'gewaehlte Variante',
WA0230 IS 'Kundensegment',
WA0228 IS 'Nationalität',
WA0226 IS 'Domizil',
WA0224 IS 'AbrechnungsArt',
WA0222 IS 'KundenArt Kunden=2,Konform=4',
WA0221 IS 'DepotArt',
WA0220 IS 'Bereichsauswahl Identifikator',
WA0216 IS 'DepotStammNR',
WA0212 IS 'IBBB',
WA0208 IS 'BU-ID',
WA0144 IS 'Restbestand N/Stk',
WA0142 IS 'Reserviert fuer Boerse',
WA0136 IS 'Kennzeichen Fraktionsbestand',
WA0134 IS 'Valor Bestand andere N/Stk',
WA0130 IS 'Valor Bestand abgerechnetN/Stk',
WA0128 IS 'Valor Bestand zugeteilt N/Stk',
WA0126 IS 'Valor Bestand disponiert N/Stk',
WA0124 IS 'Valor Bestand berechtigt N/Stk',
WA0122 IS 'Valor Bestand per EX N/Stk',
WA0120 IS 'BestandesTyp',
WA0112R IS 'Rubrik',
WA0112E IS 'Effective DepotStellen',
WA0112D IS 'DepotStellen',
WA0110 IS 'SequenzNR',
WA0104B IS 'PKey Datum+LfNR',
WA0104A IS 'PKey Term_id',
WA0104L IS 'PKey Val.-Lf-Nr',
WA0104V IS 'PKey Val.-Nr',
WA0104K IS 'PKey Mutter/Ziel',
WA0104I IS 'PKey Akt.-Id');
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA120A1V
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWA120A1V(WA0104I, WA0104K, WA0104V, WA0104A,
WA0104B, WA0110, WA0112D, WA0112E, WA0112R, WA0120, WA0122,
WA0124, WA0126, WA0128, WA0130, WA0134, WA0136, WA0142, WA0144,
WA0148, WA0208, WA0210, WA0212, WA0216, WA0220, WA0221, WA0222,
WA0224, WA0226, WA0228, WA0230, WA0232, WA0234, WA0236, WA0240,
WA0244, WA0246, WA0250, WA0252, WA0253A, WA0253B, WA0254A,
WA0254B, WA0256, WA0258, WA0260V, WA0260C, WA0260B, WA0242) AS
SELECT DISTINCT $creator.TWK962A1.WA0104I, $creator.TWK962A1.WA0104K,
$creator.TWK962A1.WA0104V, $creator.TWK962A1.WA0104A,
$creator.TWK962A1.WA0104B, $creator.TWK962A1.WA0110,
$creator.TWK962A1.WA0112D, $creator.TWK962A1.WA0112E,
$creator.TWK962A1.WA0112R, $creator.TWK962A1.WA0120,
$creator.TWK962A1.WA0122, $creator.TWK962A1.WA0124,
$creator.TWK962A1.WA0126, $creator.TWK962A1.WA0128,
$creator.TWK962A1.WA0130, $creator.TWK962A1.WA0134,
$creator.TWK962A1.WA0136, $creator.TWK962A1.WA0142,
$creator.TWK962A1.WA0144, $creator.TWK962A1.WA0148,
oa1a.TWA002A1.WA0208, oa1a.TWA002A1.WA0210,
oa1a.TWA002A1.WA0212, oa1a.TWA002A1.WA0216,
oa1a.TWA002A1.WA0220, oa1a.TWA002A1.WA0221,
oa1a.TWA002A1.WA0222, oa1a.TWA002A1.WA0224,
oa1a.TWA002A1.WA0226, oa1a.TWA002A1.WA0228,
oa1a.TWA002A1.WA0230, oa1a.TWA002A1.WA0232,
oa1a.TWA002A1.WA0234, oa1a.TWA002A1.WA0236,
oa1a.TWA002A1.WA0240, oa1a.TWA002A1.WA0244,
oa1a.TWA002A1.WA0246, oa1a.TWA002A1.WA0250,
oa1a.TWA002A1.WA0252, oa1a.TWA002A1.WA0253A,
oa1a.TWA002A1.WA0253B, oa1a.TWA002A1.WA0254A,
oa1a.TWA002A1.WA0254B, oa1a.TWA002A1.WA0256,
oa1a.TWA002A1.WA0258, oa1a.TWA002A1.WA0260V,
oa1a.TWA002A1.WA0260C, oa1a.TWA002A1.WA0260B,
oa1a.TWA002A1.WA0242
FROM $creator.TWK962A1,
oa1a.TWA002A1
WHERE $creator.TWK962A1.WA0104I = oa1a.TWA002A1.WA0204I
AND $creator.TWK962A1.WA0104A = oa1a.TWA002A1.WA0204A
AND $creator.TWK962A1.WA0104B = oa1a.TWA002A1.WA0204B
AND oa1a.TWA002A1.WA0256 ^= '300'
AND oa1a.TWA002A1.WA0256 ^= '303'
AND oa1a.TWA002A1.WA0256 ^= '304'
AND oa1a.TWA002A1.WA0256 ^= '310' ;
--
GRANT SELECT ON TABLE $creator.VWA120A1V TO $creator;
--
GRANT SELECT ON TABLE $creator.VWA120A1V TO $creator;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA500A1V
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC" ;
--
CREATE VIEW $creator.VWA500A1V(WA0102, WA0104I, WA0104K, WA0104V,
WA0104L, WA0104A, WA0104B, WA0110, WA0112, WA0120, WA0122,
WA0124, WA0126, WA0128, WA0130, WA0132, WA0134, WA0136, WA0138,
WA0140, WA0142, WA0212, WA0216) AS
SELECT $creator.TWK962A1.WA0102, $creator.TWK962A1.WA0104I,
$creator.TWK962A1.WA0104K, $creator.TWK962A1.WA0104V,
$creator.TWK962A1.WA0104L, $creator.TWK962A1.WA0104A,
$creator.TWK962A1.WA0104B, $creator.TWK962A1.WA0110,
$creator.TWK962A1.WA0112, $creator.TWK962A1.WA0120,
$creator.TWK962A1.WA0122, $creator.TWK962A1.WA0124,
$creator.TWK962A1.WA0126, $creator.TWK962A1.WA0128,
$creator.TWK962A1.WA0130, $creator.TWK962A1.WA0132,
$creator.TWK962A1.WA0134, $creator.TWK962A1.WA0136,
$creator.TWK962A1.WA0138, $creator.TWK962A1.WA0140,
$creator.TWK962A1.WA0142, oa1a.TWA002A1.WA0212,
oa1a.TWA002A1.WA0216
FROM $creator.TWK962A1,
oa1a.TWA002A1
WHERE $creator.TWK962A1.WA0104I = oa1a.TWA002A1.WA0204I
AND $creator.TWK962A1.WA0104K = 'M'
AND $creator.TWK962A1.WA0104A = oa1a.TWA002A1.WA0204A
AND $creator.TWK962A1.WA0104B = oa1a.TWA002A1.WA0204B ;
--
LABEL ON TABLE $creator.VWA500A1V IS 'MutterVal. via Depot';
--
LABEL ON $creator.VWA500A1V
(WA0216 IS 'DepotStammNR',
WA0212 IS 'IBBB',
WA0142 IS 'Reserviert fuer Boerse ',
WA0140 IS 'Aufteil. Fraktions Anteil ',
WA0138 IS 'Aufteil. Ganzzaehliger Anteil ',
WA0136 IS 'Kennzeichen Fraktionsbestand',
WA0134 IS 'Valor Bestand andere N/Stk',
WA0132 IS 'Valor Prov. disponiert N/Stk',
WA0130 IS 'Valor Bestand abgerechnetN/Stk',
WA0128 IS 'Valor Bestand zugeteilt N/Stk',
WA0126 IS 'Valor Bestand disponiert N/Stk',
WA0124 IS 'Valor Bestand berechtigt N/Stk',
WA0122 IS 'Valor Bestand per EX N/Stk',
WA0120 IS 'BestandesTyp',
WA0112 IS 'ID_Lfnr der DepotStellen',
WA0110 IS 'SequenzNR',
WA0104B IS 'PKey Datum+LfNR',
WA0104A IS 'PKey Term_id',
WA0104L IS 'PKey VV_Seg_LfNR',
WA0104V IS 'Pkey ValorenNR',
WA0104K IS 'PKey Valoren-KnZ',
WA0104I IS 'PKey AktionsNR-ID',
WA0102 IS 'Valor TimeStamp');
--
GRANT SELECT ON TABLE $creator.VWA500A1V TO $creator;
--
GRANT SELECT ON TABLE $creator.VWA500A1V TO $creator;
--
COMMIT;
--
$*)
ALTER TABLE $creator.TWK962A1 FOREIGN KEY CWA002A
(WA0104I,
WA0104A,
WA0104B)
REFERENCES oa1a.TWA002A1
(WA0204I,
WA0204A,
WA0204B)
ON DELETE RESTRICT ENFORCED ;
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
$] else if $phase = 2 then $@=[
CREATE TABLESPACE a962a
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
NUMPARTS 2
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=$creator.TWK962a1 In $db.a962a
------------------------------------------------------------------------
--
CREATE TABLE $creator.TWK962a1
(WA0102 TIMESTAMP NOT NULL,
WA0104I INTEGER NOT NULL,
WA0104K CHAR(1) FOR SBCS DATA NOT NULL,
WA0104V DECIMAL(15, 0) NOT NULL,
WA0104L SMALLINT NOT NULL,
WA0104A CHAR(4) FOR SBCS DATA NOT NULL,
WA0104B DECIMAL(15, 0) NOT NULL,
WA0110 CHAR(5) FOR SBCS DATA NOT NULL,
WA0112 INTEGER NOT NULL,
WA0112D CHAR(4) FOR SBCS DATA NOT NULL,
WA0112E CHAR(4) FOR SBCS DATA NOT NULL,
WA01123 CHAR(4) FOR SBCS DATA NOT NULL,
WA0112R CHAR(4) FOR SBCS DATA NOT NULL,
WA0120 CHAR(1) FOR SBCS DATA NOT NULL,
WA0122 DECIMAL(15, 3) NOT NULL,
WA0124 DECIMAL(15, 3) NOT NULL,
WA0126 DECIMAL(15, 3) NOT NULL,
WA0128 DECIMAL(15, 3) NOT NULL,
WA0130 DECIMAL(15, 3) NOT NULL,
WA0132 DECIMAL(15, 3) NOT NULL,
WA0134 DECIMAL(15, 3) NOT NULL,
WA0136 CHAR(1) FOR SBCS DATA NOT NULL,
WA0138 DECIMAL(15, 3) NOT NULL,
WA0140 DECIMAL(15, 3) NOT NULL,
WA0142 DECIMAL(15, 3) NOT NULL,
WA0144 DECIMAL(15, 3) NOT NULL,
WA0146 FLOAT NOT NULL,
WA0148 DECIMAL(15, 3) NOT NULL,
WA0170Q CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA0170B DECIMAL(15, 3) NOT NULL WITH DEFAULT,
WA0180S CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA0182T CHAR(1) FOR SBCS DATA NOT NULL,
WA0184S DECIMAL(15, 3) NOT NULL WITH DEFAULT,
WA0186L CHAR(25) FOR SBCS DATA NOT NULL,
CONSTRAINT WA0104I
PRIMARY KEY (WA0104I,
WA0104K,
WA0104V,
WA0104L,
WA0104A,
WA0104B))
IN $db.a962a
PARTITION BY (WA0104I ASC,
WA0104K ASC)
(PART 1 VALUES(2147483647, 'M'),
PART 2 VALUES(2147483647, 'Z'))
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
VOLATILE;
--
COMMENT ON TABLE $creator.TWK962a1 IS 'Valoren-Positionen zu Depot';
--
COMMENT ON $creator.TWK962a1
(WA0186L IS 'Link to Pending order number',
WA0184S IS 'Pending Receipt of titles N/Stk',
WA0182T IS 'Pending Receipt',
WA0180S IS 'Muttervalor SequenzNr.',
WA0170B IS 'Berechnungsbasis-Umsatzabgabe',
WA0170Q IS 'P-Prozent, M-Maximal',
WA0148 IS 'Bestand Verfallen lassen',
WA0146 IS 'Saldo bevor Wahlmöglichkeitsgerecht aufgeteilt wurde',
WA0144 IS 'Bestand Nichts Unternehmen',
WA0142 IS 'Reserviert Börse',
WA0140 IS 'Aufteilung Fraktionsanteil',
WA0138 IS 'Aufteilung ganzzahliger Anteil',
WA0136 IS 'Kennzeichen Fraktionsbestand//blank Fraktionsbestand',
WA0134 IS 'Bestand andere in N/Stk',
WA0132 IS 'Prov. disponiert in N/Stk',
WA0130 IS 'Bestand abgerechnet in N/Stk',
WA0128 IS 'Bestand zugeteilt in N/Stk',
WA0126 IS 'Bestand disponiert in N/Stk',
WA0124 IS 'Bestand berechtigt in N/Stk',
WA0122 IS 'Bestand per Ex in N/Stk',
WA0120 IS 'Bestandestyp',
WA0112R IS 'rubrik',
WA01123 IS '3.Depotstelle.',
WA0112E IS 'Effektive Depotstelle',
WA0112D IS 'Depotstelle',
WA0112 IS 'Depotstelle-Laufnummer-Id',
WA0110 IS 'Sequenznummer',
WA0104B IS 'PKEY: Datum+Laufnummer',
WA0104A IS 'PKEY: Terminal-Id',
WA0104L IS 'PKEY: Valorenlaufnummer',
WA0104V IS 'PKEY: Valorennummer',
WA0104K IS 'PKEY: Valorenkennzeichen //"M":Muttervalor"//"Zielvalor'
,
WA0104I IS 'PKEY: Aktionsnummer-ID',
WA0102 IS 'Mutationsdatum DB2-Timestamp');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962a0 On $creator.TWK962a1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.IWK962a0
ON $creator.TWK962a1
(WA0104I ASC,
WA0104K ASC,
WA0104V ASC,
WA0104L ASC,
WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962a1 On $creator.TWK962a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962a1
ON $creator.TWK962a1
(WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962a2 On $creator.TWK962a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962a2
ON $creator.TWK962a1
(WA0104I ASC,
WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A962H In Database $db --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=$db Stogroup=GSMS (for partition 1)
-- Table space=$db.A962H
------------------------------------------------------------------------
$*(
CREATE TABLESPACE A962H
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
NUMPARTS 2
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=$creator.TWK962H1 In $db.A962H
------------------------------------------------------------------------
--
CREATE TABLE $creator.TWK962H1
(WA0101 DATE NOT NULL,
WA0102 TIMESTAMP NOT NULL,
WA0104I INTEGER NOT NULL,
WA0104K CHAR(1) FOR SBCS DATA NOT NULL,
WA0104V DECIMAL(15, 0) NOT NULL,
WA0104L SMALLINT NOT NULL,
WA0104A CHAR(4) FOR SBCS DATA NOT NULL,
WA0104B DECIMAL(15, 0) NOT NULL,
WA0110 CHAR(5) FOR SBCS DATA NOT NULL,
WA0112 INTEGER NOT NULL,
WA0112D CHAR(4) FOR SBCS DATA NOT NULL,
WA0112E CHAR(4) FOR SBCS DATA NOT NULL,
WA01123 CHAR(4) FOR SBCS DATA NOT NULL,
WA0112R CHAR(4) FOR SBCS DATA NOT NULL,
WA0120 CHAR(1) FOR SBCS DATA NOT NULL,
WA0122 DECIMAL(15, 3) NOT NULL,
WA0124 DECIMAL(15, 3) NOT NULL,
WA0126 DECIMAL(15, 3) NOT NULL,
WA0128 DECIMAL(15, 3) NOT NULL,
WA0130 DECIMAL(15, 3) NOT NULL,
WA0132 DECIMAL(15, 3) NOT NULL,
WA0134 DECIMAL(15, 3) NOT NULL,
WA0136 CHAR(1) FOR SBCS DATA NOT NULL,
WA0138 DECIMAL(15, 3) NOT NULL,
WA0140 DECIMAL(15, 3) NOT NULL,
WA0142 DECIMAL(15, 3) NOT NULL,
WA0144 DECIMAL(15, 3) NOT NULL,
WA0146 FLOAT NOT NULL,
WA0148 DECIMAL(15, 3) NOT NULL,
WA0170Q CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA0170B DECIMAL(15, 3) NOT NULL WITH DEFAULT,
WA0180S CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA0182T CHAR(1) FOR SBCS DATA NOT NULL,
WA0184S DECIMAL(15, 3) NOT NULL WITH DEFAULT,
WA0186L CHAR(25) FOR SBCS DATA NOT NULL,
CONSTRAINT WA0104I
PRIMARY KEY (WA0104I,
WA0104K,
WA0104V,
WA0104L,
WA0104A,
WA0104B))
IN $db.A962H
PARTITION BY (WA0104I ASC,
WA0104K ASC)
(PART 1 VALUES(2147483647, 'M'),
PART 2 VALUES(2147483647, 'Z'))
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
VOLATILE;
--
COMMENT ON TABLE $creator.TWK962H1 IS 'Valoren-Positionen zu Depot';
--
COMMENT ON $creator.TWK962H1
(WA0186L IS 'Link to Pending order number',
WA0184S IS 'Pending Receipt of titles N/Stk',
WA0182T IS 'Pending Receipt',
WA0180S IS 'Muttervalor SequenzNr.',
WA0170B IS 'Berechnungsbasis-Umsatzabgabe',
WA0170Q IS 'P-Prozent, M-Maximal',
WA0148 IS 'Bestand Verfallen lassen',
WA0146 IS 'Saldo bevor Wahlmöglichkeitsgerecht aufgeteilt wurde',
WA0144 IS 'Bestand Nichts Unternehmen',
WA0142 IS 'Reserviert Börse',
WA0140 IS 'Aufteilung Fraktionsanteil',
WA0138 IS 'Aufteilung ganzzahliger Anteil',
WA0136 IS 'Kennzeichen Fraktionsbestand//blank Fraktionsbestand',
WA0134 IS 'Bestand andere in N/Stk',
WA0132 IS 'Prov. disponiert in N/Stk',
WA0130 IS 'Bestand abgerechnet in N/Stk',
WA0128 IS 'Bestand zugeteilt in N/Stk',
WA0126 IS 'Bestand disponiert in N/Stk',
WA0124 IS 'Bestand berechtigt in N/Stk',
WA0122 IS 'Bestand per Ex in N/Stk',
WA0120 IS 'Bestandestyp',
WA0112R IS 'rubrik',
WA01123 IS '3.Depotstelle.',
WA0112E IS 'Effektive Depotstelle',
WA0112D IS 'Depotstelle',
WA0112 IS 'Depotstelle-Laufnummer-Id',
WA0110 IS 'Sequenznummer',
WA0104B IS 'PKEY: Datum+Laufnummer',
WA0104A IS 'PKEY: Terminal-Id',
WA0104L IS 'PKEY: Valorenlaufnummer',
WA0104V IS 'PKEY: Valorennummer',
WA0104K IS 'PKEY: Valorenkennzeichen //"M":Muttervalor"//"Zielvalor'
,
WA0104I IS 'PKEY: Aktionsnummer-ID',
WA0102 IS 'Mutationsdatum DB2-Timestamp',
WA0101 IS 'Archivierungsdatum');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962H0 On $creator.TWK962H1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.IWK962H0
ON $creator.TWK962H1
(WA0104I ASC,
WA0104K ASC,
WA0104V ASC,
WA0104L ASC,
WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962H1 On $creator.TWK962H1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962H1
ON $creator.TWK962H1
(WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962H2 On $creator.TWK962H1
------------------------------------------------------------------------
--
CREATE INDEX $creator.IWK962H2
ON $creator.TWK962H1
(WA0104I ASC,
WA0104A ASC,
WA0104B ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A962K In Database $db --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=$db Stogroup=GSMS
-- Table space=$db.A962K
------------------------------------------------------------------------
--
CREATE TABLESPACE A962K
IN $db
USING STOGROUP GSMS
PRIQTY 40 SECQTY 40
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 8
BUFFERPOOL BP0
LOCKSIZE ROW
LOCKMAX 0
CLOSE YES
COMPRESS NO
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=$creator.TWK962K1 In $db.A962K
------------------------------------------------------------------------
--
CREATE TABLE $creator.TWK962K1
(WA1604 CHAR(20) FOR SBCS DATA NOT NULL,
WA1606 CHAR(16) FOR SBCS DATA NOT NULL,
WA1608 CHAR(12) FOR SBCS DATA NOT NULL,
WA1610 CHAR(5) FOR SBCS DATA NOT NULL,
WA1612 DECIMAL(7, 0) NOT NULL,
WA1620 DECIMAL(15, 0) NOT NULL,
WA1621 SMALLINT NOT NULL,
WA1622 CHAR(4) FOR SBCS DATA NOT NULL,
WA1623 DECIMAL(15, 0) NOT NULL,
WA1624 DECIMAL(15, 3) NOT NULL,
WA1625 DECIMAL(15, 3) NOT NULL,
WA1626 CHAR(1) FOR SBCS DATA NOT NULL,
WA1627 CHAR(1) FOR SBCS DATA NOT NULL,
WA1628 CHAR(3) FOR SBCS DATA NOT NULL,
WA1629 CHAR(3) FOR SBCS DATA NOT NULL,
WA1630 CHAR(3) FOR SBCS DATA NOT NULL,
WA1631 CHAR(3) FOR SBCS DATA NOT NULL,
WA1632 CHAR(2) FOR SBCS DATA NOT NULL,
WA1633 CHAR(4) FOR SBCS DATA NOT NULL,
WA1634 CHAR(4) FOR SBCS DATA NOT NULL,
WA1635 CHAR(4) FOR SBCS DATA NOT NULL,
WA1636 CHAR(4) FOR SBCS DATA NOT NULL,
WA1637 CHAR(4) FOR SBCS DATA NOT NULL,
WA1638 CHAR(4) FOR SBCS DATA NOT NULL,
WA1639 CHAR(4) FOR SBCS DATA NOT NULL,
WA1640 CHAR(3) FOR SBCS DATA NOT NULL,
WA1641 CHAR(8) FOR SBCS DATA NOT NULL,
WA1642 CHAR(4) FOR SBCS DATA NOT NULL,
WA1643 CHAR(16) FOR SBCS DATA NOT NULL,
WA1644 CHAR(16) FOR SBCS DATA NOT NULL,
WA1645 CHAR(3) FOR SBCS DATA NOT NULL,
WA1646 CHAR(4) FOR SBCS DATA NOT NULL,
WA1647 CHAR(4) FOR SBCS DATA NOT NULL,
WA1648 CHAR(4) FOR SBCS DATA NOT NULL,
WA1649 CHAR(1) FOR SBCS DATA NOT NULL,
WA1650 CHAR(25) FOR SBCS DATA NOT NULL,
WA1651 CHAR(1) FOR SBCS DATA NOT NULL,
WA1652 CHAR(3) FOR SBCS DATA NOT NULL,
WA1653 CHAR(2) FOR SBCS DATA NOT NULL,
WA1654 CHAR(1) FOR SBCS DATA NOT NULL,
WA1655 CHAR(2) FOR SBCS DATA NOT NULL,
WA1656 CHAR(1) FOR SBCS DATA NOT NULL,
WA1657 CHAR(2) FOR SBCS DATA NOT NULL,
WA1658 TIMESTAMP NOT NULL,
WA1659 TIMESTAMP NOT NULL,
WA1660 TIMESTAMP NOT NULL,
WA1661 DECIMAL(15, 3) NOT NULL,
WA1662 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1663 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1664 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1665 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1666 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1667 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1668 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1670 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1671 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1674 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT WA1604
PRIMARY KEY (WA1604,
WA1606,
WA1608,
WA1610,
WA1612))
IN $db.A962K
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
COMMENT ON TABLE $creator.TWK962K1 IS 'Daten Grundbestand VEGA AM';
--
COMMENT ON $creator.TWK962K1
(WA1674 IS 'CIF-Nummer',
WA1671 IS 'Ist dies ein PENR-Fall',
WA1670 IS 'Status des PENRs',
WA1668 IS 'Custody-Account',
WA1667 IS 'US-Person',
WA1666 IS 'Relationship Manager',
WA1665 IS 'Betr-.Stelle alt',
WA1664 IS 'Sprachcode',
WA1663 IS 'FC',
WA1662 IS 'Auftrags-Nr. GUI',
WA1661 IS 'Nom/Stk der Bewegung',
WA1660 IS 'Timestamp POS',
WA1659 IS 'Timestamp MOD',
WA1658 IS 'Timestamp INS',
WA1657 IS 'Verfügbarkeitsgrund',
WA1656 IS 'Verfügbarkeitsstatus',
WA1655 IS 'Selektionsgrund',
WA1654 IS 'Selektionsstatus',
WA1653 IS 'Bew. Abrechnungs-Phase',
WA1652 IS 'Bew. Abrechnungs-GA',
WA1651 IS 'Bew. Abrechnungsart',
WA1650 IS 'Bew. Auftragsnummer',
WA1649 IS 'Depotflag 4',
WA1648 IS 'Depotflag 3',
WA1647 IS 'Depotflag 2',
WA1646 IS 'Depotflag 1',
WA1645 IS 'Titelart',
WA1644 IS 'PM-Betreuungsstelle',
WA1643 IS 'Kundenbüro',
WA1642 IS 'Depotstellenrubrik',
WA1641 IS 'Verfall',
WA1640 IS 'Depotstellenland',
WA1639 IS 'Eff. Depotstelle',
WA1638 IS 'Depotstelle',
WA1637 IS 'BUID',
WA1636 IS 'Vollmacht 5',
WA1635 IS 'Vollmacht 4',
WA1634 IS 'Vollmacht 3',
WA1633 IS 'Vollmacht 2',
WA1632 IS 'Vollmacht 1',
WA1631 IS 'Kundenart',
WA1630 IS 'Depotart',
WA1629 IS 'Nationalität',
WA1628 IS 'Domizil',
WA1627 IS 'Herkunft',
WA1626 IS 'Global Custodian',
WA1625 IS 'Nom/Stk verfügbar',
WA1624 IS 'Nom/Stk',
WA1623 IS 'AuftrNr VEGA-Auftrag',
WA1622 IS 'Term-Id VEGA-Auftrag',
WA1621 IS 'Priorität',
WA1620 IS 'Packet-Id',
WA1612 IS 'Laufnummer',
WA1610 IS 'Sequenznummer',
WA1608 IS 'Valorennummer',
WA1606 IS 'Depotnummer',
WA1604 IS 'Aktionsnummer');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.IWK962K01 On $creator.TWK962K1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.IWK962K01
ON $creator.TWK962K1
(WA1604 ASC,
WA1606 ASC,
WA1608 ASC,
WA1610 ASC,
WA1612 ASC)
USING STOGROUP GSMS
PRIQTY 40 SECQTY 40
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP0
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A962L In Database $db --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=$db Stogroup=GSMS
-- Table space=$db.A962L
------------------------------------------------------------------------
--
CREATE TABLESPACE A962L
IN $db
USING STOGROUP GSMS
PRIQTY 40 SECQTY 40
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 8
BUFFERPOOL BP0
LOCKSIZE ROW
LOCKMAX 0
CLOSE YES
COMPRESS NO
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=$creator.Twk962L1 In $db.A962L
------------------------------------------------------------------------
--
CREATE TABLE $creator.Twk962L1
(WA1601 DATE NOT NULL,
WA1604 CHAR(20) FOR SBCS DATA NOT NULL,
WA1606 CHAR(16) FOR SBCS DATA NOT NULL,
WA1608 CHAR(12) FOR SBCS DATA NOT NULL,
WA1610 CHAR(5) FOR SBCS DATA NOT NULL,
WA1612 DECIMAL(7, 0) NOT NULL,
WA1620 DECIMAL(15, 0) NOT NULL,
WA1621 SMALLINT NOT NULL,
WA1622 CHAR(4) FOR SBCS DATA NOT NULL,
WA1623 DECIMAL(15, 0) NOT NULL,
WA1624 DECIMAL(15, 3) NOT NULL,
WA1625 DECIMAL(15, 3) NOT NULL,
WA1626 CHAR(1) FOR SBCS DATA NOT NULL,
WA1627 CHAR(1) FOR SBCS DATA NOT NULL,
WA1628 CHAR(3) FOR SBCS DATA NOT NULL,
WA1629 CHAR(3) FOR SBCS DATA NOT NULL,
WA1630 CHAR(3) FOR SBCS DATA NOT NULL,
WA1631 CHAR(3) FOR SBCS DATA NOT NULL,
WA1632 CHAR(2) FOR SBCS DATA NOT NULL,
WA1633 CHAR(4) FOR SBCS DATA NOT NULL,
WA1634 CHAR(4) FOR SBCS DATA NOT NULL,
WA1635 CHAR(4) FOR SBCS DATA NOT NULL,
WA1636 CHAR(4) FOR SBCS DATA NOT NULL,
WA1637 CHAR(4) FOR SBCS DATA NOT NULL,
WA1638 CHAR(4) FOR SBCS DATA NOT NULL,
WA1639 CHAR(4) FOR SBCS DATA NOT NULL,
WA1640 CHAR(3) FOR SBCS DATA NOT NULL,
WA1641 CHAR(8) FOR SBCS DATA NOT NULL,
WA1642 CHAR(4) FOR SBCS DATA NOT NULL,
WA1643 CHAR(16) FOR SBCS DATA NOT NULL,
WA1644 CHAR(16) FOR SBCS DATA NOT NULL,
WA1645 CHAR(3) FOR SBCS DATA NOT NULL,
WA1646 CHAR(4) FOR SBCS DATA NOT NULL,
WA1647 CHAR(4) FOR SBCS DATA NOT NULL,
WA1648 CHAR(4) FOR SBCS DATA NOT NULL,
WA1649 CHAR(1) FOR SBCS DATA NOT NULL,
WA1650 CHAR(25) FOR SBCS DATA NOT NULL,
WA1651 CHAR(1) FOR SBCS DATA NOT NULL,
WA1652 CHAR(3) FOR SBCS DATA NOT NULL,
WA1653 CHAR(2) FOR SBCS DATA NOT NULL,
WA1654 CHAR(1) FOR SBCS DATA NOT NULL,
WA1655 CHAR(2) FOR SBCS DATA NOT NULL,
WA1656 CHAR(1) FOR SBCS DATA NOT NULL,
WA1657 CHAR(2) FOR SBCS DATA NOT NULL,
WA1658 TIMESTAMP NOT NULL,
WA1659 TIMESTAMP NOT NULL,
WA1660 TIMESTAMP NOT NULL,
WA1661 DECIMAL(15, 3) NOT NULL,
WA1662 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1663 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1664 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1665 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1666 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1667 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1668 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1670 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1671 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WA1674 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT WA1604
PRIMARY KEY (WA1604,
WA1606,
WA1608,
WA1610,
WA1612))
IN $db.A962L
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
COMMENT ON TABLE $creator.Twk962L1 IS 'Daten Grundbestand VEGA AM';
--
COMMENT ON $creator.Twk962L1
(WA1674 IS 'CIF-Nummer',
WA1671 IS 'Ist dies ein PENR-Fall',
WA1670 IS 'Status des PENRs',
WA1668 IS 'Custody-Account',
WA1667 IS 'US-Person',
WA1666 IS 'Relationship Manager',
WA1665 IS 'Betr-.Stelle alt',
WA1664 IS 'Sprachcode',
WA1663 IS 'FC',
WA1662 IS 'Auftrags-Nr. GUI',
WA1661 IS 'Nom/Stk der Bewegung',
WA1660 IS 'Timestamp POS',
WA1659 IS 'Timestamp MOD',
WA1658 IS 'Timestamp INS',
WA1657 IS 'Verfügbarkeitsgrund',
WA1656 IS 'Verfügbarkeitsstatus',
WA1655 IS 'Selektionsgrund',
WA1654 IS 'Selektionsstatus',
WA1653 IS 'Bew. Abrechnungs-Phase',
WA1652 IS 'Bew. Abrechnungs-GA',
WA1651 IS 'Bew. Abrechnungsart',
WA1650 IS 'Bew. Auftragsnummer',
WA1649 IS 'Depotflag 4',
WA1648 IS 'Depotflag 3',
WA1647 IS 'Depotflag 2',
WA1646 IS 'Depotflag 1',
WA1645 IS 'Titelart',
WA1644 IS 'PM-Betreuungsstelle',
WA1643 IS 'Kundenbüro',
WA1642 IS 'Depotstellenrubrik',
WA1641 IS 'Verfall',
WA1640 IS 'Depotstellenland',
WA1639 IS 'Eff. Depotstelle',
WA1638 IS 'Depotstelle',
WA1637 IS 'BUID',
WA1636 IS 'Vollmacht 5',
WA1635 IS 'Vollmacht 4',
WA1634 IS 'Vollmacht 3',
WA1633 IS 'Vollmacht 2',
WA1632 IS 'Vollmacht 1',
WA1631 IS 'Kundenart',
WA1630 IS 'Depotart',
WA1629 IS 'Nationalität',
WA1628 IS 'Domizil',
WA1627 IS 'Herkunft',
WA1626 IS 'Global Custodian',
WA1625 IS 'Nom/Stk verfügbar',
WA1624 IS 'Nom/Stk',
WA1623 IS 'AuftrNr VEGA-Auftrag',
WA1622 IS 'Term-Id VEGA-Auftrag',
WA1621 IS 'Priorität',
WA1620 IS 'Packet-Id',
WA1612 IS 'Laufnummer',
WA1610 IS 'Sequenznummer',
WA1608 IS 'Valorennummer',
WA1606 IS 'Depotnummer',
WA1604 IS 'Aktionsnummer',
WA1601 IS 'archivierungsdatum');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk962L01 On $creator.Twk962L1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.Iwk962L01
ON $creator.Twk962L1
(WA1604 ASC,
WA1606 ASC,
WA1608 ASC,
WA1610 ASC,
WA1612 ASC)
USING STOGROUP GSMS
PRIQTY 40 SECQTY 40
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP0
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- View=$creator.VWK962A1
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","$creator" ;
--
CREATE VIEW $creator.VWK962A1(CHANGE_TS, ACTION_HEAD_ID,
MOTHER_SEC_FLG, SECNR, SECSEQ, TERMINAL_ID, ORDER_ID,
SEQUENC_NR, DEPOSITORY_SEQ, DEPOSITORY, EFF_DEPOSITORY,
THIRD_DEPOSITORY, RUBRIC, HOLDNG_TYPE, HOLDNG_PEREX,
HOLDNG_ENTITLED, HOLDNG_DISPOSED, HOLDNG_ASSIGNED,
HOLDNG_SETTLED, PROVISORY_DOSPOSED, HOLDNG_OTHER,
HOLDNG_FRACFLG, WHOLE_NUMBER_PART, FRACTION_PART,
RESERVED_EXCHANGE, HOLDNG_NO_ACTION, HOLDNG_ANTE_CHOICE,
HOLDNG_DECAY, RENUMPART_FLG, RENUMBASIS, MOTHERSEQ, PENDING_FLG,
PENDING_RECEIPT, PENDING_ORDER_NR) AS
SELECT $creator.TWK962a1.WA0102, $creator.TWK962a1.WA0104I,
$creator.TWK962a1.WA0104K, $creator.TWK962a1.WA0104V,
$creator.TWK962a1.WA0104L, $creator.TWK962a1.WA0104A,
$creator.TWK962a1.WA0104B, $creator.TWK962a1.WA0110,
$creator.TWK962a1.WA0112, $creator.TWK962a1.WA0112D,
$creator.TWK962a1.WA0112E, $creator.TWK962a1.WA01123,
$creator.TWK962a1.WA0112R, $creator.TWK962a1.WA0120,
$creator.TWK962a1.WA0122, $creator.TWK962a1.WA0124,
$creator.TWK962a1.WA0126, $creator.TWK962a1.WA0128,
$creator.TWK962a1.WA0130, $creator.TWK962a1.WA0132,
$creator.TWK962a1.WA0134, $creator.TWK962a1.WA0136,
$creator.TWK962a1.WA0138, $creator.TWK962a1.WA0140,
$creator.TWK962a1.WA0142, $creator.TWK962a1.WA0144,
$creator.TWK962a1.WA0146, $creator.TWK962a1.WA0148,
$creator.TWK962a1.WA0170Q, $creator.TWK962a1.WA0170B,
$creator.TWK962a1.WA0180S, $creator.TWK962a1.WA0182T,
$creator.TWK962a1.WA0184S, $creator.TWK962a1.WA0186L
FROM $creator.TWK962a1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWK962H1
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWK962H1(ARCHIVING_DATE, CHANGE_TS,
ACTION_HEAD_ID, MOTHER_SEC_FLG, SECNR, SECSEQ, TERMINAL_ID,
ORDER_ID, SEQUENC_NR, DEPOSITORY_SEQ, DEPOSITORY,
EFF_DEPOSITORY, THIRD_DEPOSITORY, RUBRIC, HOLDNG_TYPE,
HOLDNG_PEREX, HOLDNG_ENTITLED, HOLDNG_DISPOSED, HOLDNG_ASSIGNED,
HOLDNG_SETTLED, PROVISORY_DOSPOSED, HOLDNG_OTHER,
HOLDNG_FRACFLG, WHOLE_NUMBER_PART, FRACTION_PART,
RESERVED_EXCHANGE, HOLDNG_NO_ACTION, HOLDNG_ANTE_CHOICE,
HOLDNG_DECAY, RENUMPART_FLG, RENUMBASIS, MOTHERSEQ, PENDING_FLG,
PENDING_RECEIPT, PENDING_ORDER_NR) AS
SELECT $creator.TWK962H1.WA0101, $creator.TWK962H1.WA0102,
$creator.TWK962H1.WA0104I, $creator.TWK962H1.WA0104K,
$creator.TWK962H1.WA0104V, $creator.TWK962H1.WA0104L,
$creator.TWK962H1.WA0104A, $creator.TWK962H1.WA0104B,
$creator.TWK962H1.WA0110, $creator.TWK962H1.WA0112,
$creator.TWK962H1.WA0112D, $creator.TWK962H1.WA0112E,
$creator.TWK962H1.WA01123, $creator.TWK962H1.WA0112R,
$creator.TWK962H1.WA0120, $creator.TWK962H1.WA0122,
$creator.TWK962H1.WA0124, $creator.TWK962H1.WA0126,
$creator.TWK962H1.WA0128, $creator.TWK962H1.WA0130,
$creator.TWK962H1.WA0132, $creator.TWK962H1.WA0134,
$creator.TWK962H1.WA0136, $creator.TWK962H1.WA0138,
$creator.TWK962H1.WA0140, $creator.TWK962H1.WA0142,
$creator.TWK962H1.WA0144, $creator.TWK962H1.WA0146,
$creator.TWK962H1.WA0148, $creator.TWK962H1.WA0170Q,
$creator.TWK962H1.WA0170B, $creator.TWK962H1.WA0180S,
$creator.TWK962H1.WA0182T, $creator.TWK962H1.WA0184S,
$creator.TWK962H1.WA0186L
FROM $creator.TWK962H1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA009A1V
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWA009A1V(WA0102, WA0104I, WA0104K, WA0104V,
WA0104L, WA0104A, WA0104B, WA0110, WA0112D, WA0112E, WA01123,
WA0112R, WA0120, WA0122, WA0124, WA0126, WA0128, WA0130, WA0132,
WA0134, WA0136, WA0138, WA0140, WA0142, WA0144, WA0146, WA0148,
WA0170Q, WA0170B, WA0180S, WA0182T, WA0184S, WA0186L, WA0202,
WA0208, WA0210, WA0212, WA0214, WA0216, WA0220, WA0221, WA0222,
WA0224, WA0226, WA0228, WA0230, WA0232, WA0234, WA0236, WA0238,
WA0240, WA0242, WA0244, WA0246, WA0248, WA0250, WA0252, WA0253A,
WA0253B, WA0254A, WA0254B, WA0256, WA0258, WA0260V, WA0260C,
WA0260B, WA0262, WA0264) AS
SELECT DISTINCT $creator.TWK962a1.WA0102, $creator.TWK962a1.WA0104I,
$creator.TWK962a1.WA0104K, $creator.TWK962a1.WA0104V,
$creator.TWK962a1.WA0104L, $creator.TWK962a1.WA0104A,
$creator.TWK962a1.WA0104B, $creator.TWK962a1.WA0110,
$creator.TWK962a1.WA0112D, $creator.TWK962a1.WA0112E,
$creator.TWK962a1.WA01123, $creator.TWK962a1.WA0112R,
$creator.TWK962a1.WA0120, $creator.TWK962a1.WA0122,
$creator.TWK962a1.WA0124, $creator.TWK962a1.WA0126,
$creator.TWK962a1.WA0128, $creator.TWK962a1.WA0130,
$creator.TWK962a1.WA0132, $creator.TWK962a1.WA0134,
$creator.TWK962a1.WA0136, $creator.TWK962a1.WA0138,
$creator.TWK962a1.WA0140, $creator.TWK962a1.WA0142,
$creator.TWK962a1.WA0144, $creator.TWK962a1.WA0146,
$creator.TWK962a1.WA0148, $creator.TWK962a1.WA0170Q,
$creator.TWK962a1.WA0170B, $creator.TWK962a1.WA0180S,
$creator.TWK962a1.WA0182T, $creator.TWK962a1.WA0184S,
$creator.TWK962a1.WA0186L, oa1a.TWA002A1.WA0202,
oa1a.TWA002A1.WA0208, oa1a.TWA002A1.WA0210,
oa1a.TWA002A1.WA0212, oa1a.TWA002A1.WA0214,
oa1a.TWA002A1.WA0216, oa1a.TWA002A1.WA0220,
oa1a.TWA002A1.WA0221, oa1a.TWA002A1.WA0222,
oa1a.TWA002A1.WA0224, oa1a.TWA002A1.WA0226,
oa1a.TWA002A1.WA0228, oa1a.TWA002A1.WA0230,
oa1a.TWA002A1.WA0232, oa1a.TWA002A1.WA0234,
oa1a.TWA002A1.WA0236, oa1a.TWA002A1.WA0238,
oa1a.TWA002A1.WA0240, oa1a.TWA002A1.WA0242,
oa1a.TWA002A1.WA0244, oa1a.TWA002A1.WA0246,
oa1a.TWA002A1.WA0248, oa1a.TWA002A1.WA0250,
oa1a.TWA002A1.WA0252, oa1a.TWA002A1.WA0253A,
oa1a.TWA002A1.WA0253B, oa1a.TWA002A1.WA0254A,
oa1a.TWA002A1.WA0254B, oa1a.TWA002A1.WA0256,
oa1a.TWA002A1.WA0258, oa1a.TWA002A1.WA0260V,
oa1a.TWA002A1.WA0260C, oa1a.TWA002A1.WA0260B,
oa1a.TWA002A1.WA0262, oa1a.TWA002A1.WA0264
FROM $creator.TWK962a1
INNER JOIN
oa1a.TWA002A1
ON $creator.TWK962a1.WA0104I = oa1a.TWA002A1.WA0204I AND
$creator.TWK962a1.WA0104A = oa1a.TWA002A1.WA0204A AND
$creator.TWK962a1.WA0104B = oa1a.TWA002A1.WA0204B
WHERE $creator.TWK962a1.WA0104K = 'M'
AND $creator.TWK962a1.WA0182T <> 'P' ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA009H1V
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWA009H1V(WA0101, WA0102, WA0104I, WA0104K,
WA0104V, WA0104L, WA0104A, WA0104B, WA0110, WA0112D, WA0112E,
WA01123, WA0112R, WA0120, WA0122, WA0124, WA0126, WA0128,
WA0130, WA0132, WA0134, WA0136, WA0138, WA0140, WA0142, WA0144,
WA0146, WA0148, WA0170Q, WA0170B, WA0180S, WA0182T, WA0184S,
WA0186L, WA0202, WA0208, WA0210, WA0212, WA0214, WA0216, WA0220,
WA0221, WA0222, WA0224, WA0226, WA0228, WA0230, WA0232, WA0234,
WA0236, WA0238, WA0240, WA0242, WA0244, WA0246, WA0248, WA0250,
WA0252, WA0253A, WA0253B, WA0254A, WA0254B, WA0256, WA0258,
WA0260V, WA0260C, WA0260B, WA0262, WA0264) AS
SELECT DISTINCT $creator.TWK962H1.WA0101, $creator.TWK962H1.WA0102,
$creator.TWK962H1.WA0104I, $creator.TWK962H1.WA0104K,
$creator.TWK962H1.WA0104V, $creator.TWK962H1.WA0104L,
$creator.TWK962H1.WA0104A, $creator.TWK962H1.WA0104B,
$creator.TWK962H1.WA0110, $creator.TWK962H1.WA0112D,
$creator.TWK962H1.WA0112E, $creator.TWK962H1.WA01123,
$creator.TWK962H1.WA0112R, $creator.TWK962H1.WA0120,
$creator.TWK962H1.WA0122, $creator.TWK962H1.WA0124,
$creator.TWK962H1.WA0126, $creator.TWK962H1.WA0128,
$creator.TWK962H1.WA0130, $creator.TWK962H1.WA0132,
$creator.TWK962H1.WA0134, $creator.TWK962H1.WA0136,
$creator.TWK962H1.WA0138, $creator.TWK962H1.WA0140,
$creator.TWK962H1.WA0142, $creator.TWK962H1.WA0144,
$creator.TWK962H1.WA0146, $creator.TWK962H1.WA0148,
$creator.TWK962H1.WA0170Q, $creator.TWK962H1.WA0170B,
$creator.TWK962H1.WA0180S, $creator.TWK962H1.WA0182T,
$creator.TWK962H1.WA0184S, $creator.TWK962H1.WA0186L,
oa1a.TWA002H1.WA0202, oa1a.TWA002H1.WA0208,
oa1a.TWA002H1.WA0210, oa1a.TWA002H1.WA0212,
oa1a.TWA002H1.WA0214, oa1a.TWA002H1.WA0216,
oa1a.TWA002H1.WA0220, oa1a.TWA002H1.WA0221,
oa1a.TWA002H1.WA0222, oa1a.TWA002H1.WA0224,
oa1a.TWA002H1.WA0226, oa1a.TWA002H1.WA0228,
oa1a.TWA002H1.WA0230, oa1a.TWA002H1.WA0232,
oa1a.TWA002H1.WA0234, oa1a.TWA002H1.WA0236,
oa1a.TWA002H1.WA0238, oa1a.TWA002H1.WA0240,
oa1a.TWA002H1.WA0242, oa1a.TWA002H1.WA0244,
oa1a.TWA002H1.WA0246, oa1a.TWA002H1.WA0248,
oa1a.TWA002H1.WA0250, oa1a.TWA002H1.WA0252,
oa1a.TWA002H1.WA0253A, oa1a.TWA002H1.WA0253B,
oa1a.TWA002H1.WA0254A, oa1a.TWA002H1.WA0254B,
oa1a.TWA002H1.WA0256, oa1a.TWA002H1.WA0258,
oa1a.TWA002H1.WA0260V, oa1a.TWA002H1.WA0260C,
oa1a.TWA002H1.WA0260B, oa1a.TWA002H1.WA0262,
oa1a.TWA002H1.WA0264
FROM $creator.TWK962H1
INNER JOIN
oa1a.TWA002H1
ON $creator.TWK962H1.WA0104I = oa1a.TWA002H1.WA0204I AND
$creator.TWK962H1.WA0104A = oa1a.TWA002H1.WA0204A AND
$creator.TWK962H1.WA0104B = oa1a.TWA002H1.WA0204B
WHERE $creator.TWK962H1.WA0104K = 'M' ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWK962K1
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWK962K1(ACTIONHEADNR, SAVEKEEPACCT, SECNR,
SECSEQ, SEQ, PACKAGEID, PRIO, TERMID_VEGA, ORDERID_VEGA,
RELHOLDNGTEM, DISPHOLDNG, GLOBALCUSTFLG, SOURCEFLG, DOMICILE,
CITIZEN, DEPOSITORYTYPE, CUSTOMERTYPE, PROXY1, PROXY2, PROXY3,
PROXY4, PROXY5, BUID, DST, EFFDST, DSTCOUNTRY, EXPIRATION,
RUBRIC, CLIENTOFFICE, ASSISTPM, TITLETYPE, DEPOSITORYFLG1,
DEPOSITORYFLG2, DEPOSITORYFLG3, DEPOSITORYFLG4, MOVEORDER,
MOVETYPE, MOVEBT, MOVEPHASE, SELSTATE, SELREASON, AVAILSTATE,
AVAILREASON, INSERTTS, MODIFIEDTS, POSDELIVERYTS, MOVEHOLDNG,
ORDERNRGUI, ERRORCD, LANGCD, ASSISTANCEOLD, ASSISTANCEPMOLD,
USPERSONFLG, CUSTODYACCOUNT, PENDSTATE, PENDFLG, CIF) AS
SELECT $creator.TWK962K1.WA1604, $creator.TWK962K1.WA1606,
$creator.TWK962K1.WA1608, $creator.TWK962K1.WA1610,
$creator.TWK962K1.WA1612, $creator.TWK962K1.WA1620,
$creator.TWK962K1.WA1621, $creator.TWK962K1.WA1622,
$creator.TWK962K1.WA1623, $creator.TWK962K1.WA1624,
$creator.TWK962K1.WA1625, $creator.TWK962K1.WA1626,
$creator.TWK962K1.WA1627, $creator.TWK962K1.WA1628,
$creator.TWK962K1.WA1629, $creator.TWK962K1.WA1630,
$creator.TWK962K1.WA1631, $creator.TWK962K1.WA1632,
$creator.TWK962K1.WA1633, $creator.TWK962K1.WA1634,
$creator.TWK962K1.WA1635, $creator.TWK962K1.WA1636,
$creator.TWK962K1.WA1637, $creator.TWK962K1.WA1638,
$creator.TWK962K1.WA1639, $creator.TWK962K1.WA1640,
$creator.TWK962K1.WA1641, $creator.TWK962K1.WA1642,
$creator.TWK962K1.WA1643, $creator.TWK962K1.WA1644,
$creator.TWK962K1.WA1645, $creator.TWK962K1.WA1646,
$creator.TWK962K1.WA1647, $creator.TWK962K1.WA1648,
$creator.TWK962K1.WA1649, $creator.TWK962K1.WA1650,
$creator.TWK962K1.WA1651, $creator.TWK962K1.WA1652,
$creator.TWK962K1.WA1653, $creator.TWK962K1.WA1654,
$creator.TWK962K1.WA1655, $creator.TWK962K1.WA1656,
$creator.TWK962K1.WA1657, $creator.TWK962K1.WA1658,
$creator.TWK962K1.WA1659, $creator.TWK962K1.WA1660,
$creator.TWK962K1.WA1661, $creator.TWK962K1.WA1662,
$creator.TWK962K1.WA1663, $creator.TWK962K1.WA1664,
$creator.TWK962K1.WA1665, $creator.TWK962K1.WA1666,
$creator.TWK962K1.WA1667, $creator.TWK962K1.WA1668,
$creator.TWK962K1.WA1670, $creator.TWK962K1.WA1671,
$creator.TWK962K1.WA1674
FROM $creator.TWK962K1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWK962L1
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWK962L1(ACTIONHEADNR, SAVEKEEPACCT, SECNR,
SECSEQ, SEQ, PACKAGEID, PRIO, TERMID_VEGA, ORDERID_VEGA,
RELHOLDNGTEM, DISPHOLDNG, GLOBALCUSTFLG, SOURCEFLG, DOMICILE,
CITIZEN, DEPOSITORYTYPE, CUSTOMERTYPE, PROXY1, PROXY2, PROXY3,
PROXY4, PROXY5, BUID, DST, EFFDST, DSTCOUNTRY, EXPIRATION,
RUBRIC, CLIENTOFFICE, ASSISTPM, TITLETYPE, DEPOSITORYFLG1,
DEPOSITORYFLG2, DEPOSITORYFLG3, DEPOSITORYFLG4, MOVEORDER,
MOVETYPE, MOVEBT, MOVEPHASE, SELSTATE, SELREASON, AVAILSTATE,
AVAILREASON, INSERTTS, MODIFIEDTS, POSDELIVERYTS, MOVEHOLDNG,
ORDERNRGUI, ERRORCD, LANGCD, ASSISTANCEOLD, ASSISTANCEPMOLD,
USPERSONFLG, CUSTODYACCOUNT, PENDSTATE, PENDFLG, CIF) AS
SELECT $creator.Twk962L1.WA1604, $creator.Twk962L1.WA1606,
$creator.Twk962L1.WA1608, $creator.Twk962L1.WA1610,
$creator.Twk962L1.WA1612, $creator.Twk962L1.WA1620,
$creator.Twk962L1.WA1621, $creator.Twk962L1.WA1622,
$creator.Twk962L1.WA1623, $creator.Twk962L1.WA1624,
$creator.Twk962L1.WA1625, $creator.Twk962L1.WA1626,
$creator.Twk962L1.WA1627, $creator.Twk962L1.WA1628,
$creator.Twk962L1.WA1629, $creator.Twk962L1.WA1630,
$creator.Twk962L1.WA1631, $creator.Twk962L1.WA1632,
$creator.Twk962L1.WA1633, $creator.Twk962L1.WA1634,
$creator.Twk962L1.WA1635, $creator.Twk962L1.WA1636,
$creator.Twk962L1.WA1637, $creator.Twk962L1.WA1638,
$creator.Twk962L1.WA1639, $creator.Twk962L1.WA1640,
$creator.Twk962L1.WA1641, $creator.Twk962L1.WA1642,
$creator.Twk962L1.WA1643, $creator.Twk962L1.WA1644,
$creator.Twk962L1.WA1645, $creator.Twk962L1.WA1646,
$creator.Twk962L1.WA1647, $creator.Twk962L1.WA1648,
$creator.Twk962L1.WA1649, $creator.Twk962L1.WA1650,
$creator.Twk962L1.WA1651, $creator.Twk962L1.WA1652,
$creator.Twk962L1.WA1653, $creator.Twk962L1.WA1654,
$creator.Twk962L1.WA1655, $creator.Twk962L1.WA1656,
$creator.Twk962L1.WA1657, $creator.Twk962L1.WA1658,
$creator.Twk962L1.WA1659, $creator.Twk962L1.WA1660,
$creator.Twk962L1.WA1661, $creator.Twk962L1.WA1662,
$creator.Twk962L1.WA1663, $creator.Twk962L1.WA1664,
$creator.Twk962L1.WA1665, $creator.Twk962L1.WA1666,
$creator.Twk962L1.WA1667, $creator.Twk962L1.WA1668,
$creator.Twk962L1.WA1670, $creator.Twk962L1.WA1671,
$creator.Twk962L1.WA1674
FROM $creator.Twk962L1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA120A1V
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWA120A1V(WA0104I, WA0104K, WA0104V, WA0104A,
WA0104B, WA0110, WA0112D, WA0112E, WA0112R, WA0120, WA0122,
WA0124, WA0126, WA0128, WA0130, WA0134, WA0136, WA0142, WA0144,
WA0148, WA0182T, WA0184S, WA0186L, WA0208, WA0210, WA0212,
WA0216, WA0220, WA0221, WA0222, WA0224, WA0226, WA0228, WA0230,
WA0232, WA0234, WA0236, WA0240, WA0242, WA0244, WA0246, WA0250,
WA0252, WA0253A, WA0253B, WA0254A, WA0254B, WA0256, WA0258,
WA0260V, WA0260C, WA0260B) AS
SELECT DISTINCT $creator.TWK962a1.WA0104I,
$creator.TWK962a1.WA0104K, $creator.TWK962a1.WA0104V,
$creator.TWK962a1.WA0104A, $creator.TWK962a1.WA0104B,
$creator.TWK962a1.WA0110, $creator.TWK962a1.WA0112D,
$creator.TWK962a1.WA0112E, $creator.TWK962a1.WA0112R,
$creator.TWK962a1.WA0120, $creator.TWK962a1.WA0122,
$creator.TWK962a1.WA0124, $creator.TWK962a1.WA0126,
$creator.TWK962a1.WA0128, $creator.TWK962a1.WA0130,
$creator.TWK962a1.WA0134, $creator.TWK962a1.WA0136,
$creator.TWK962a1.WA0142, $creator.TWK962a1.WA0144,
$creator.TWK962a1.WA0148, $creator.TWK962a1.WA0182T,
$creator.TWK962a1.WA0184S, $creator.TWK962a1.WA0186L,
oa1a.TWA002A1.WA0208, oa1a.TWA002A1.WA0210,
oa1a.TWA002A1.WA0212, oa1a.TWA002A1.WA0216,
oa1a.TWA002A1.WA0220, oa1a.TWA002A1.WA0221,
oa1a.TWA002A1.WA0222, oa1a.TWA002A1.WA0224,
oa1a.TWA002A1.WA0226, oa1a.TWA002A1.WA0228,
oa1a.TWA002A1.WA0230, oa1a.TWA002A1.WA0232,
oa1a.TWA002A1.WA0234, oa1a.TWA002A1.WA0236,
oa1a.TWA002A1.WA0240, oa1a.TWA002A1.WA0242,
oa1a.TWA002A1.WA0244, oa1a.TWA002A1.WA0246,
oa1a.TWA002A1.WA0250, oa1a.TWA002A1.WA0252,
oa1a.TWA002A1.WA0253A, oa1a.TWA002A1.WA0253B,
oa1a.TWA002A1.WA0254A, oa1a.TWA002A1.WA0254B,
oa1a.TWA002A1.WA0256, oa1a.TWA002A1.WA0258,
oa1a.TWA002A1.WA0260V, oa1a.TWA002A1.WA0260C,
oa1a.TWA002A1.WA0260B
FROM $creator.TWK962a1
INNER JOIN
oa1a.TWA002A1
ON $creator.TWK962a1.WA0104I = oa1a.TWA002A1.WA0204I AND
$creator.TWK962a1.WA0104A = oa1a.TWA002A1.WA0204A AND
$creator.TWK962a1.WA0104B = oa1a.TWA002A1.WA0204B
WHERE oa1a.TWA002A1.WA0256 ^= '300'
AND oa1a.TWA002A1.WA0256 ^= '303'
AND oa1a.TWA002A1.WA0256 ^= '304'
AND oa1a.TWA002A1.WA0256 ^= '310' ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.VWA120H1V
------------------------------------------------------------------------
--
--
CREATE VIEW $creator.VWA120H1V(WA0101, WA0104I, WA0104K, WA0104V,
WA0104A, WA0104B, WA0110, WA0112D, WA0112E, WA0112R, WA0120,
WA0122, WA0124, WA0126, WA0128, WA0130, WA0134, WA0136, WA0142,
WA0144, WA0148, WA0182T, WA0184S, WA0186L, WA0208, WA0210,
WA0212, WA0216, WA0220, WA0221, WA0222, WA0224, WA0226, WA0228,
WA0230, WA0232, WA0234, WA0236, WA0240, WA0242, WA0244, WA0246,
WA0250, WA0252, WA0253A, WA0253B, WA0254A, WA0254B, WA0256,
WA0258, WA0260V, WA0260C, WA0260B) AS
SELECT DISTINCT $creator.TWK962H1.WA0101, $creator.TWK962H1.WA0104I,
$creator.TWK962H1.WA0104K, $creator.TWK962H1.WA0104V,
$creator.TWK962H1.WA0104A, $creator.TWK962H1.WA0104B,
$creator.TWK962H1.WA0110, $creator.TWK962H1.WA0112D,
$creator.TWK962H1.WA0112E, $creator.TWK962H1.WA0112R,
$creator.TWK962H1.WA0120, $creator.TWK962H1.WA0122,
$creator.TWK962H1.WA0124, $creator.TWK962H1.WA0126,
$creator.TWK962H1.WA0128, $creator.TWK962H1.WA0130,
$creator.TWK962H1.WA0134, $creator.TWK962H1.WA0136,
$creator.TWK962H1.WA0142, $creator.TWK962H1.WA0144,
$creator.TWK962H1.WA0148, $creator.TWK962H1.WA0182T,
$creator.TWK962H1.WA0184S, $creator.TWK962H1.WA0186L,
oa1a.TWA002H1.WA0208, oa1a.TWA002H1.WA0210,
oa1a.TWA002H1.WA0212, oa1a.TWA002H1.WA0216,
oa1a.TWA002H1.WA0220, oa1a.TWA002H1.WA0221,
oa1a.TWA002H1.WA0222, oa1a.TWA002H1.WA0224,
oa1a.TWA002H1.WA0226, oa1a.TWA002H1.WA0228,
oa1a.TWA002H1.WA0230, oa1a.TWA002H1.WA0232,
oa1a.TWA002H1.WA0234, oa1a.TWA002H1.WA0236,
oa1a.TWA002H1.WA0240, oa1a.TWA002H1.WA0242,
oa1a.TWA002H1.WA0244, oa1a.TWA002H1.WA0246,
oa1a.TWA002H1.WA0250, oa1a.TWA002H1.WA0252,
oa1a.TWA002H1.WA0253A, oa1a.TWA002H1.WA0253B,
oa1a.TWA002H1.WA0254A, oa1a.TWA002H1.WA0254B,
oa1a.TWA002H1.WA0256, oa1a.TWA002H1.WA0258,
oa1a.TWA002H1.WA0260V, oa1a.TWA002H1.WA0260C,
oa1a.TWA002H1.WA0260B
FROM $creator.TWK962H1
INNER JOIN
oa1a.TWA002H1
ON $creator.TWK962H1.WA0104I = oa1a.TWA002H1.WA0204I AND
$creator.TWK962H1.WA0104A = oa1a.TWA002H1.WA0204A AND
$creator.TWK962H1.WA0104B = oa1a.TWA002H1.WA0204B
WHERE oa1a.TWA002H1.WA0256 ^= '300'
AND oa1a.TWA002H1.WA0256 ^= '303'
AND oa1a.TWA002H1.WA0256 ^= '304'
AND oa1a.TWA002H1.WA0256 ^= '310' ;
--
COMMIT;
$*)
ALTER TABLE $creator.TWK962a1 FOREIGN KEY CWA002A
(WA0104I,
WA0104A,
WA0104B)
REFERENCES oa1a.TWA002A1
(WA0204I,
WA0204A,
WA0204B)
ON DELETE RESTRICT ENFORCED ;
COMMIT;
--
$*(
ALTER TABLE $creator.TWK962H1 FOREIGN KEY CWA002H
(WA0104I,
WA0104A,
WA0104B)
REFERENCES OA1A.TWA002H1
(WA0204I,
WA0204A,
WA0204B)
ON DELETE RESTRICT ENFORCED ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
$*)
$]
$]