zOs/TX/WK920DDL
------------$-{right(userid() sysvar(sysnode) date(s) time(), 60, '-')}
-- testCase $dsn
-- env $env phase $phase
-- subsys $subsys db $db creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
$=tb=TWK920A1
SET CURRENT SQLID='S100447';
drop tablespace $db.a920a;
drop tablespace $db.a920B;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE A920A
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP32K
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255
;
CREATE TABLESPACE A920B
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP32K
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255
;
commit;
------------------------------------------------------------------------
CREATE TABLE $creator.VTLISTING
(INSTRUMENTID INTEGER NOT NULL,
LISTINGNO INTEGER NOT NULL,
PROVIDER1ID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER2ID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER3ID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CREATETIMESTAMP VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
UPDATETIMESTAMP VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
ISMAINTRADINGPLACE SMALLINT WITH DEFAULT NULL,
ISHOMETRADINGPLACE SMALLINT WITH DEFAULT NULL,
ISONLIMITEDHALT SMALLINT WITH DEFAULT NULL,
HASNOMCURRSETTLE SMALLINT WITH DEFAULT NULL,
TRADINGPLACE INTEGER WITH DEFAULT NULL,
CURRENCY INTEGER WITH DEFAULT NULL,
MARKTPRACTIDSYMBOL CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
FIRSTTRADINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
LASTTRADINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
HALTFROMDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
HALTUNTILDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
FIRSTTRDDTAFHALT VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGSTATUSTYPE SMALLINT WITH DEFAULT NULL,
LISTINGSTATUSTYPE SMALLINT WITH DEFAULT NULL,
EXCHANGERATETYPE SMALLINT WITH DEFAULT NULL,
LISTPURPOSETYPE SMALLINT WITH DEFAULT NULL,
TRADINGSTATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
LISTINGSTATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
EXCHANGERATETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
LISTPURPOSETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_G VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_E VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_F VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_I VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_N VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_G VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_E VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_F VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_I VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_N VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
CSLISTINGCODETYPE SMALLINT WITH DEFAULT NULL,
CSLISTINGCODETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
HASINDMARPRACTICE SMALLINT WITH DEFAULT NULL,
PRICINGUNITNO FLOAT WITH DEFAULT NULL,
PRICINGCORRFACTOR FLOAT WITH DEFAULT NULL,
NONVERSEAMOUNT FLOAT WITH DEFAULT NULL,
VOLUMEAMOUNT FLOAT WITH DEFAULT NULL,
TRADINGUNITNO FLOAT WITH DEFAULT NULL,
PRICINGUNITTYPE SMALLINT WITH DEFAULT NULL,
QUOTATIONTYPE SMALLINT WITH DEFAULT NULL,
VOLUMEUNITTYPE SMALLINT WITH DEFAULT NULL,
ACCRUEDINTCALCTP SMALLINT WITH DEFAULT NULL,
FLATREASONTYPE SMALLINT WITH DEFAULT NULL,
TRADINGUNITTYPE SMALLINT WITH DEFAULT NULL,
TRADINGRULETYPE SMALLINT WITH DEFAULT NULL,
PRICINGUNITTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
QUOTATIONTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
VOLUMEUNITTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
ACCRUEDINTCALCTPV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
FLATREASONTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGUNITTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGRULETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
VALUEPRICETYPE SMALLINT WITH DEFAULT NULL,
VALUEPRICETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
HASLISTINGDETAIL SMALLINT WITH DEFAULT NULL,
EXCHANGETYPE SMALLINT WITH DEFAULT NULL,
EXCHANGETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
LISTINGCLASSTYPE SMALLINT WITH DEFAULT NULL,
HASREDUNDANTINFO SMALLINT WITH DEFAULT NULL,
HASBESTTRADINGVENUE SMALLINT WITH DEFAULT NULL,
ISBESTVOLUMEBESTSPREAD SMALLINT WITH DEFAULT NULL,
ISBESTVOLUME SMALLINT WITH DEFAULT NULL,
ISBESTSPREAD SMALLINT WITH DEFAULT NULL,
ISHIGHESTTICKS SMALLINT WITH DEFAULT NULL,
ISBESTVOLUMEPERCURR SMALLINT WITH DEFAULT NULL,
ISBESTSPREADPERCURR SMALLINT WITH DEFAULT NULL,
ISPRIMARYMARKETUSA SMALLINT WITH DEFAULT NULL,
ISSINGLETRADINGPLACE SMALLINT WITH DEFAULT NULL,
ISISSUERPRICEPROVIDER SMALLINT WITH DEFAULT NULL,
ISNAVINDEPENDENTSOURCE SMALLINT WITH DEFAULT NULL,
ISFUNDASSESSMENTSOURCE SMALLINT WITH DEFAULT NULL,
ISCSBESTVENUEOVERALL SMALLINT WITH DEFAULT NULL,
ISCSBESTVENUEPERCURR SMALLINT WITH DEFAULT NULL,
CSBVOVERALLUPDATEUSER CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
CSBVPERCURRUPDATEUSER CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
CSBVOVERALLUPDATETS VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
CSBVPERCURRUPDATETS VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
ISPLACEOFQUOTE SMALLINT WITH DEFAULT NULL,
ISPLACEOFLISTING SMALLINT WITH DEFAULT NULL,
ISPLACEOFTRADING SMALLINT WITH DEFAULT NULL,
TRADINGGROUPSYMBOL1 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGGROUPSYMBOL2 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGGROUPSYMBOL3 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGGROUPSYMBOL4 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGGROUPSYMBOL5 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
LISTINGSYMBOLTK CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
LISTINGSYMBOLRT CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
LISTINGSYMBOLBB CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_BCN CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_RTX CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_MIC CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_BBX CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CURRENCY_I1 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CURRENCY_I2 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CURRENCY_WS80 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_WS80 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PARENTTRADINGPLACE INTEGER WITH DEFAULT NULL,
PARENTTRADINGPLACE_BCN CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PARENTTRADINGPLACE_RTX CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PARENTTRADINGPLACE_MIC CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PARENTTRADINGPLACE_BBX CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PARENTTRADINGPLACE_WS80 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGPLACESYMBOLRIC CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGPLACESYMBOLBBI CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
MINTRADINGUNITNO FLOAT WITH DEFAULT NULL,
REGULARTRADINGUNITNO FLOAT WITH DEFAULT NULL,
NOMINALTRADINGUNITNO FLOAT WITH DEFAULT NULL,
NMSTRADINGUNITNO FLOAT WITH DEFAULT NULL,
EMSTRADINGUNITNO FLOAT WITH DEFAULT NULL,
SMSTRADINGUNITNO FLOAT WITH DEFAULT NULL,
PTSTRADINGUNITNO FLOAT WITH DEFAULT NULL,
BBMARKETSECTORTYPE SMALLINT WITH DEFAULT NULL,
CONSTRAINT INSTRUMENTID
PRIMARY KEY (INSTRUMENTID,
LISTINGNO))
IN $db.A920A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
COMMIT;
------------------------------------------------------------------------
CREATE UNIQUE INDEX $creator.VTXLISTING1
ON $creator.VTLISTING
(INSTRUMENTID ASC,
LISTINGNO ASC)
USING STOGROUP GSMS
PRIQTY 428400 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;
------------------------------------------------------------------------
CREATE INDEX $creator.VTXLISTING5
ON $creator.VTLISTING
(EXCHANGETYPE ASC)
USING STOGROUP GSMS
PRIQTY 151200 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;
------------------------------------------------------------------------
CREATE TABLE $creator.VTINSTITUTION
(INSTITUTIONID INTEGER NOT NULL,
HISTORYID INTEGER WITH DEFAULT NULL,
INSTITUTIONTYPE SMALLINT WITH DEFAULT NULL,
ROWSTATUS SMALLINT WITH DEFAULT NULL,
VSTQUALITY SMALLINT WITH DEFAULT NULL,
REVISIONNO SMALLINT WITH DEFAULT NULL,
VSTREQUIREDQUALITY SMALLINT WITH DEFAULT NULL,
VSTMAXIMUMQUALITY SMALLINT WITH DEFAULT NULL,
ISGLOBALREGACC SMALLINT WITH DEFAULT NULL,
HASPENDINGACTVTY SMALLINT WITH DEFAULT NULL,
ISRELEVANT SMALLINT WITH DEFAULT NULL,
HASFUTUREMESSAGES SMALLINT WITH DEFAULT NULL,
FOTWIZISDISABLED SMALLINT WITH DEFAULT NULL,
ISONDB SMALLINT WITH DEFAULT NULL,
LOCATION INTEGER WITH DEFAULT NULL,
VSTNAME CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
VSTVERSION CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CREATEUSERID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
UPDATEUSERID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER1SYMBOL CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER2SYMBOL CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER3SYMBOL CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
DELETIONDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
CREATETIMESTAMP VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
UPDATETIMESTAMP VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
STATUSTYPE SMALLINT WITH DEFAULT NULL,
DELETEREASONTYPE SMALLINT WITH DEFAULT NULL,
MAINLANGUAGETYPE SMALLINT WITH DEFAULT NULL,
FOTYPE SMALLINT WITH DEFAULT NULL,
DATASTATUSTYPE SMALLINT WITH DEFAULT NULL,
BLOCKINGCODETYPE SMALLINT WITH DEFAULT NULL,
LOGICDELETIONTYPE SMALLINT WITH DEFAULT NULL,
STATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
DELETEREASONTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
MAINLANGUAGETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
FOTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
DATASTATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
BLOCKINGCODETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
LOGICDELETIONTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_G VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_E VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_F VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_I VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_N VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_G VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_E VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_F VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_I VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_N VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
MODIFICATIONREASON VARCHAR(2000) FOR SBCS DATA
WITH DEFAULT NULL,
REMARKS VARCHAR(2000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_G VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_E VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_F VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_I VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_N VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
KANTONSCODETYPE SMALLINT WITH DEFAULT NULL,
KANTONSCODETYPEV VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
PORTFOLIONO INTEGER WITH DEFAULT NULL,
HASADDRESS SMALLINT WITH DEFAULT NULL,
DOMICILE INTEGER WITH DEFAULT NULL,
TAXDOMICILE INTEGER WITH DEFAULT NULL,
ADDRESSLOCATION INTEGER WITH DEFAULT NULL,
ACCOUNTINGCURR INTEGER WITH DEFAULT NULL,
INITIALMARGINRATE FLOAT WITH DEFAULT NULL,
DOMICILE_A2 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
DOMICILE_WS80 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TAXDOMICILE_A2 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TAXDOMICILE_WS80 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYCS CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYTKBN CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYMSCI CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYDJ CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYFTSE CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYMFIB CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYMFIS CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYICB CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYBDF CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TAXNUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
NONTAXABLENUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
HOUSENUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
ZIP CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TELEFAXNUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
BANKACCOUNTNUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
NATIONALBANKCODE CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
FOUNDATIONDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PREVFINYEARENDDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
ACTFINYEARENDDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
REGISTERENTRYDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
REGENTRYDELETIONDT VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
YEARENDDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
NEXTSEMESTERREPORT VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
NONTAXABLEDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PREVIOUSYEARENDDT VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
LEGALFORMTYPE SMALLINT WITH DEFAULT NULL,
TRUSTLEGALGUIDETP SMALLINT WITH DEFAULT NULL,
TRUSTSTATUSTYPE SMALLINT WITH DEFAULT NULL,
LEGALFORMTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
TRUSTLEGALGUIDETPV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
TRUSTSTATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
CITY VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
INTERNETDOMAIN VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
STREET VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
EMAILNAME VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
PHONENUMBER VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
IBAN VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
ADDRESS VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
ADDRESSDESCR VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
HEADOFFICEDESCR VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
ADDRESSLOCATION_A2 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
ADDRESSLOCATION_WS80 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
HASREDUNDANTINFO SMALLINT WITH DEFAULT NULL,
MDYISSUERRATING CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
MDYISSUERRATINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
MDYISSUERWATCHLISTSTATUSTYPE SMALLINT WITH DEFAULT NULL,
SPISSUERRATING CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
SPISSUERRATINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
SPISSUERWATCHLISTSTATUSTYPE SMALLINT WITH DEFAULT NULL,
FITCHISSUERRATING CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
FITCHISSUERRATINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
FITCHISSUERWATCHLISTSTATUSTYPE SMALLINT WITH DEFAULT NULL,
DOMICILE_A3 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TAXDOMICILE_A3 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
ADDRESSLOCATION_A3 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
DOWRITETOSHADOWTABLES SMALLINT WITH DEFAULT NULL,
CSASSEMBLYNOTIFICATIONTYPE SMALLINT WITH DEFAULT NULL,
INDUSTRYSIC CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CONSTRAINT INSTITUTIONID
PRIMARY KEY (INSTITUTIONID))
IN $db.A920B
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
COMMIT;
------------------------------------------------------------------------
CREATE UNIQUE INDEX $creator.VTXINSTITUTION1
ON $creator.VTINSTITUTION
(INSTITUTIONID ASC)
USING STOGROUP GSMS
PRIQTY 10800 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;
------------------------------------------------------------------------
CREATE INDEX $creator.VTXINSTITUTION20
ON $creator.VTINSTITUTION
(INSTITUTIONTYPE ASC)
USING STOGROUP GSMS
PRIQTY 4320 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;
------------------------------------------------------------------------
CREATE INDEX $creator.VTXINSTITUTION5
ON $creator.VTINSTITUTION
(CREATETIMESTAMP ASC)
PADDED
USING STOGROUP GSMS
PRIQTY 15120 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;
------------------------------------------------------------------------
CREATE INDEX $creator.VTXINSTITUTION50
ON $creator.VTINSTITUTION
(STATUSTYPE ASC)
USING STOGROUP GSMS
PRIQTY 4320 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;
------------------------------------------------------------------------
CREATE INDEX $creator.VTXINSTITUTION6
ON $creator.VTINSTITUTION
(UPDATETIMESTAMP ASC)
PADDED
USING STOGROUP GSMS
PRIQTY 7200 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;
------------------------------------------------------------------------
CREATE INDEX $creator.VTXINSTITUTION7
ON $creator.VTINSTITUTION
(FOTYPE ASC)
USING STOGROUP GSMS
PRIQTY 4320 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;
---||| end ddl testcase $mbr env $env phase $phase