zOs/TX/WK921DDL
SET CURRENT SQLID='S100447';
SET CURRENT SCHEMA='$creator';
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","$creator" ;
drop VIEW $creator.VWK9210;
drop VIEW $creator.VWK921A;
drop VIEW $creator.VWK921B;
CREATE VIEW $creator.VWK9210 (ABC) as
select * from sysibm.sysdummy1;
CREATE VIEW $creator.VWK921A (ABC) as
select * from $creator.VWK9210
union all select * from $creator.VWK9210;
CREATE VIEW $creator.VWK921B
(PARTITIONID, OBJUUID, MKTVALINREPRTCCY, MKTVALINCOMPCCY,
MKTVALINPOSCCY, ACCRINTINREPRTCCY, ACCRINTINCOMPCCY, NBR, V
ALTYPECD, SECPRICETYPECD, SECPRICE, SECPRICEDT, SECPOSCCYCD, AVGPURCHPR
ICECCYCD, AVGPURCHPRICE, AVGPURCHEXCHGRATE, AVGPURCHPRICETYPECD, STOCKX
CHGCD, DURATION, NEXTINTRSTDT, NONREALPLPERCFX, NONREALPLPERCPRICE, NON
REALPLVALFXINVALCCY, NONREALPLVALPRICE, NONREALPLPERCTOT, NONREALPLVALT
OT, CONTRSIZE, CONTREXPIRYDT, CONTRSTRIKEPRICE, CNVRSNPERIODFROM, CNVRS
NPERIODTO, CNVRSNPREMIUM, EXCHGRATEREPRTCCY, EXCHGRATECOMPCCY, EXCHGRAT
EDT, YIELDPERCPRICE, YIELDPERCAVGPURCHPRICE, PRICEYRHIGH, PRICEYRHIGHDT
, PRICEYRLOW, PRICEYRLOWDT, EXPEARNINREPRTCCY, COLLATRATIOEFF, COLLATV
ALEFFINREPRTCCY, COLLATVALEFFINCOMPCCY, COLLATRATIOTYPECD, COLLATRATIOS
TNDRD, ISINDIVIDCOLLATRATIO, COLLATVALSTNDRDINREPRTCCY, COLLATVALSTNDRD
INCOMPCCY, MTYDT, ANALYSISCCYCD, ANALYSISCNTRYCD, PREMATUREREDEMPTDT, A
GIOREDEMPT, INTRSTRATE, CIFNO, LASTMOVEMENTDT, EXPGROSSREVENUE, GROSSRE
VENUE, WHTAXVAL, PRICEEARNINGRATIO, OBJECTTYPECD, REPRTUUID, SAFEKACCNO
, POLICENO, CIFNOCUSTOMERPILLAR, ASSETMAINCLASS, ASSETSUBCLASS, SECNO,
SECPOSSEQNO, NBROFPENDINGORDERS, NBROFBLOCKEDPOSITIONS, NBROFINDIVIDUAL
TEXT, SECTYPECD, SECCCYCD, ISINNO , ANALYSISSECTCD, ANALYSISDEBTORCD, BV
GCATCD, RATINGAGENCYCD, RATINGCD , FUNDTYPECD, FUNDBREAKDOWNFLAG, TICKER
CD, MINFRAGMENTATION, EUTAXCD, USTAXCD, INTRSTFREQUENCYCD, BETAFACTOR,
MSCISECTCD, MSCIGROUPCD, MSCIINDSTRYCD, MSCISUBINDSTRYCD, NOMVALUE, RED
EMPTCCYCD, REDEMPTVALINREDEMPTCCY, REDEMPTVALINREPRTCCY, REDEMPTVALINCO
MPCCY, ACCCCYCD, LASTINTRSTDT, ACCDESCR, ACCNO, CLSTRID, ACCTYPECD, IS
CREDITUSEACC, IBANNO, DEALDT, TRDCCYCD, TRDPRINCIPALVAL, COUNTERCCYCD ,
PRINCIPALAMOUNTINCOUNTERCCY, STRIKEPRICE, ISPARTIALTRX, PRICE, TREASURY
TYPECD, TRDEUID, INPUTDT, REVLTNDT, TRXTYPECD, EXPIRYDT, OPICSDEALNO, P
REMIUMCCYCD, PREMIUMVALINPREMIUMCCY, PREMIUMVALINCOMPCCY , MKTPREMIUMBAS
E, STRATEGY, EXOTIC, PREMIUMVALINTRDCCY, PREMIUMVALINCOUNTERCCY, PREMIU
MVALINREPRTCCY, PREMIUMVALINVALCCY, SECNOWITHINFUND, SECPOSSEQNOFUND, I
SINCLFUNDUNBUNDLING, POSITIONTYPECD , SORTCRITERIA0, SORTCRITERIA1, SORT
CRITERIA2, SORTCRITERIA3, SORTCRITERIA4, SORTCRITERIA5, YIELDPERCPRICE2
, YIELDPERCAVGPURCHPRICE2 , YIELDPERCPRICE3, YIELDPERCAVGPURCHPRICE3, YI
ELDPERCPRICE4, YIELDPERCAVGPURCHPRICE4, YIELDPERCPRICE5, YIELDPERCAVGPU
RCHPRICE5, BALANCEOFTRDPARTINTRDCCY, BALANCEOFTRDPARTINREPRTCCY, BALAN
CEOFTRDPARTINCOMPCCY, BALANCEOFCTRPARTINCTRCCY, BALANCEOFCTRPARTINREPRT
CCY, BALANCEOFCTRPARTINCOMPCCY, SECDESCR, RELUUID, MKTVALINACCCCY, VALC
CYCD, MKTVALINVALCCY, FOREIGNPOLICYNO, DEPOSITRUBRICCD, DEPOSITEFFCD, D
EPOSITAWDCD, PREMATUREREDEMPTDTCREDIT, CNTRYCD, BASECCYCD, PILLARTYPECD
, AVGPURCHEXCHGRATECTRCCYCD, ISMANDATECUSTOMER, MANDATEDESCR, COLLATVAL
EFFINACCCCY, SECPRICETIMESTMP , SECPRICEACTTYPECD, CSFIID, NBROFCONTRACT
S, VALIDTODT) AS SELECT PARTITIONID, OBJUUID, MKTVALINREPRTCCY, MKTVAL
INCOMPCCY, MKTVALINPOSCCY, ACCRINTINREPRTCCY, ACCRINTINCOMPCCY, 0, VALT
YPECD, SECPRICETYPECD, SECPRICE, SECPRICEDT, SECPOSCCYCD, AVGPURCHPRICE
CCYCD, AVGPURCHPRICE, AVGPURCHEXCHGRATE, AVGPURCHPRICETYPECD, STOCKXCHG
CD, DURATION, NEXTINTRSTDT, NONREALPLPERCFX, NONREALPLPERCPRICE, NONRE
ALPLVALFXINVALCCY, NONREALPLVALPRICE, NONREALPLPERCTOT, NONREALPLVALTOT
, 0, '01.01.0001', 0, CNVRSNPERIODFROM, CNVRSNPERIODTO, CNVRSNPREMIUM,
EXCHGRATEREPRTCCY, EXCHGRATECOMPCCY, EXCHGRATEDT, YIELDPERCPRICE, YIELD
PERCAVGPURCHPRICE, PRICEYRHIGH, PRICEYRHIGHDT, PRICEYRLOW, PRICEYRLOWDT
, EXPEARNINREPRTCCY, COLLATRATIOEFF, COLLATVALEFFINREPRTCCY, COLLATVALE
FFINCOMPCCY, COLLATRATIOTYPECD, COLLATRATIOSTNDRD, ISINDIVIDCOLLATRATIO
, COLLATVALSTNDRDINREPRTCCY, COLLATVALSTNDRDINCOMPCCY, MTYDT, ANALYSISC
CYCD, ANALYSISCNTRYCD, PREMATUREREDEMPTDT, AGIOREDEMPT, INTRSTRATE, CIF
NO, LASTMOVEMENTDT, EXPGROSSREVENUE, GROSSREVENUE, WHTAXVAL, 0, OBJECTT
YPECD, REPRTUUID, SAFEKACCNO, POLICENO, CIFNOCUSTOMERPILLAR, ASSETMAINC
LASS, ASSETSUBCLASS, SECNO, SECPOSSEQNO, NBROFPENDINGORDERS, NBROFBLOC
KEDPOSITIONS, NBROFINDIVIDUALTEXT, SECTYPECD, SECCCYCD, ISINNO , ANALYSI
SSECTCD, ANALYSISDEBTORCD, BVGCATCD, RATINGAGENCYCD, RATINGCD , FUNDTYPE
CD, FUNDBREAKDOWNFLAG, TICKERCD, MINFRAGMENTATION, EUTAXCD, USTAXCD, IN
TRSTFREQUENCYCD, 0, MSCISECTCD, MSCIGROUPCD, MSCIINDSTRYCD, MSCISUBINDS
TRYCD, NOMVALUE, REDEMPTCCYCD, REDEMPTVALINREDEMPTCCY, REDEMPTVALINREPR
TCCY, REDEMPTVALINCOMPCCY, '', LASTINTRSTDT, '', '', '' , '', '', '', '0
1.01.0001', '', 0, '', 0, 0, '', 0, 0, '', '01.01.0001' , '01.01.0001',
'', '01.01.0001', '', '', 0, 0, 0, '', '', 0, 0, 0, 0, SECNO, SECPOSSEQ
NO, ISINCLFUNDUNBUNDLING, POSITIONTYPECD, CASE WHEN(NOMVALUE < 0) THEN
'L ' ELSE 'A ' END, ASSETMAINCLASS, CASE WHEN(ASSETMAINCLASS = '05' AND
ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS
= '05' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(AS
SETMAINCLASS = '10' AND ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCY
CD WHEN(ASSETMAINCLASS = '10' AND ANALYSISCCYCD <> '0010') THEN '1' ||
ANALYSISCCYCD WHEN(ASSETMAINCLASS = '15' AND ANALYSISCCYCD = '0010') T
HEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '15' AND ANALYSISCCYCD
<> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '17') THEN
ASSETSUBCLASS WHEN(ASSETMAINCLASS = '20' AND ANALYSISCCYCD = '0010') TH
EN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '20' AND ANALYSISCCYCD <
> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '21') THEN A
NALYSISCCYCD WHEN(ASSETMAINCLASS = '23') THEN ASSETSUBCLASS WHEN(ASSET
MAINCLASS = '24' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4)
|| SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAIN
CLASS = '24' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '
25' AND ANALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSE
TMAINCLASS = '25' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNT
RYCD WHEN(ASSETMAINCLASS = '26') THEN ASSETSUBCLASS WHEN(ASSETMAINCLAS
S = '30') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '32' AND ANALYSISCNT
RYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '32' A
ND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAI
NCLASS = '35') THEN '1' WHEN(ASSETMAINCLASS = '37') THEN ASSETSUBCLASS
WHEN(ASSETMAINCLASS = '40' AND ANALYSISCCYCD = '0010') THEN '0' || ANA
LYSISCCYCD WHEN(ASSETMAINCLASS = '40' AND ANALYSISCCYCD <> '0010') THEN
'1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '45') THEN ASSETSUBCLASS E
LSE '' END, CASE WHEN(ASSETMAINCLASS = '05') THEN '1' WHEN(ASSETMAINCL
ASS = '10' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUB
STR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS
= '10' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '15' AN
D MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYD
T), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '15' AND MT
YDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '17' AND ANALYSISCCY
CD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '17' AND
ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS
= '20') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '21' AND MTYDT IS NOT
NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || S
UBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '21' AND MTYDT IS NULL) T
HEN '99991231' WHEN(ASSETMAINCLASS = '23' AND MTYDT IS NOT NULL) THEN S
UBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MT
YDT), 1, 2) WHEN(ASSETMAINCLASS = '23' AND MTYDT IS NULL) THEN '99991231
' WHEN(ASSETMAINCLASS = '24' AND ANALYSISCNTRYCD = '210') THEN '0' ||
ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '24' AND ANALYSISCNTRYCD <> '210'
) THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '25') THEN SECNO
WHEN(ASSETMAINCLASS = '26' AND ANALYSISCNTRYCD = '210') THEN '0' || ANA
LYSISCNTRYCD WHEN(ASSETMAINCLASS = '26' AND ANALYSISCNTRYCD <> '210') T
HEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '30' AND ANALYSISCNTR
YCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '30' AN
D ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAIN
CLASS = '37' AND POLICENO IS NOT NULL) THEN POLICENO || '1' WHEN(ASSET
MAINCLASS = '37' AND POLICENO IS NULL) THEN ' ' || '1' WHEN(ASSET
MAINCLASS = '40') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '45') THEN '
1' ELSE '' END, CASE WHEN(ASSETMAINCLASS = '05') THEN ASSETSUBCLASS WH
EN(ASSETMAINCLASS = '10') THEN '1' WHEN(ASSETMAINCLASS = '15') THEN '1'
WHEN(ASSETMAINCLASS = '20' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MT
YDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WH
EN(ASSETMAINCLASS = '20' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETM
AINCLASS = '21') THEN SECNO WHEN(ASSETMAINCLASS = '23' AND ANALYSISCNTR
YCD = '210') THEN '0' WHEN(ASSETMAINCLASS = '23' AND ANALYSISCNTRYCD <>
'210') THEN '1' WHEN(ASSETMAINCLASS = '24') THEN SECNO WHEN(ASSETMAIN
CLASS = '26') THEN SECNO WHEN(ASSETMAINCLASS = '30') THEN SECNO WHEN(A
SSETMAINCLASS = '37') THEN SECNO WHEN(ASSETMAINCLASS = '45') THEN SECNO
ELSE '' END, CASE WHEN(ASSETMAINCLASS = '10') THEN SECNO WHEN(ASSETMA
INCLASS = '15') THEN SECNO WHEN(ASSETMAINCLASS = '20') THEN SECNO WHEN
(ASSETMAINCLASS = '23') THEN SECNO ELSE '' END, YIELDPERCPRICE2, YIELDP
ERCAVGPURCHPRICE2, YIELDPERCPRICE3, YIELDPERCAVGPURCHPRICE3, YIELDPERCP
RICE4, YIELDPERCAVGPURCHPRICE4, YIELDPERCPRICE5, YIELDPERCAVGPURCHPRICE
5, 0, 0, 0, 0, 0, 0, SECDESCR, RELUUID, 0, VALCCYCD, 0, FOREIGNPOLICYNO
, DEPOSITRUBRICCD, DEPOSITEFFCD, DEPOSITAWDCD, PREMATUREREDEMPTDTCREDIT
, CNTRYCD, '', PILLARTYPECD, '', ISMANDATECUSTOMER, MANDATEDESCR, 0, SE
CPRICETIMESTMP, SECPRICEACTTYPECD , CSFIID, 0, VALIDTODT FROM OA1X.VAV11
1J4 UNION ALL SELECT PARTITIONID, OBJUUID, MKTVALINREPRTCCY, MKTVALIN
COMPCCY, MKTVALINPOSCCY, ACCRINTINREPRTCCY, ACCRINTINCOMPCCY, NBR, VALT
YPECD, SECPRICETYPECD, SECPRICE, SECPRICEDT, SECPOSCCYCD, AVGPURCHPRICE
CCYCD, AVGPURCHPRICE, AVGPURCHEXCHGRATE, AVGPURCHPRICETYPECD, STOCKXCHG
CD, DURATION, NEXTINTRSTDT, NONREALPLPERCFX, NONREALPLPERCPRICE, NONRE
ALPLVALFXINVALCCY, NONREALPLVALPRICE, NONREALPLPERCTOT, NONREALPLVALTOT
, CONTRSIZE, CONTREXPIRYDT, CONTRSTRIKEPRICE, CNVRSNPERIODFROM, CNVRSNP
ERIODTO, CNVRSNPREMIUM, EXCHGRATEREPRTCCY, EXCHGRATECOMPCCY, EXCHGRATED
T, YIELDPERCPRICE, YIELDPERCAVGPURCHPRICE, PRICEYRHIGH, PRICEYRHIGHDT,
PRICEYRLOW, PRICEYRLOWDT, EXPEARNINREPRTCCY , COLLATRATIOEFF, COLLATVALE
FFINREPRTCCY, COLLATVALEFFINCOMPCCY, COLLATRATIOTYPECD, COLLATRATIOSTND
RD, ISINDIVIDCOLLATRATIO, COLLATVALSTNDRDINREPRTCCY, COLLATVALSTNDRDINC
OMPCCY, MTYDT, ANALYSISCCYCD, ANALYSISCNTRYCD, PREMATUREREDEMPTDT, AGIO
REDEMPT, INTRSTRATE, CIFNO, LASTMOVEMENTDT, EXPGROSSREVENUE, GROSSREVEN
UE, WHTAXVAL, PRICEEARNINGRATIO, OBJECTTYPECD, REPRTUUID, SAFEKACCNO,
POLICENO, CIFNOCUSTOMERPILLAR, ASSETMAINCLASS, ASSETSUBCLASS, SECNO, SE
CPOSSEQNO, NBROFPENDINGORDERS, NBROFBLOCKEDPOSITIONS, NBROFINDIVIDUALTE
XT, SECTYPECD, SECCCYCD, ISINNO, ANALYSISSECTCD, ANALYSISDEBTORCD, BVGC
ATCD, RATINGAGENCYCD, RATINGCD, FUNDTYPECD, FUNDBREAKDOWNFLAG, TICKERCD
, MINFRAGMENTATION, EUTAXCD, USTAXCD, INTRSTFREQUENCYCD, BETAFACTOR, MS
CISECTCD, MSCIGROUPCD, MSCIINDSTRYCD, MSCISUBINDSTRYCD, 0, '', 0, 0, 0,
'', LASTINTRSTDT, '', '', '', '', '' , '', '01.01.0001', '', 0, '', 0,
0, '', 0, 0, '', '01.01.0001', '01.01.0001', '', '01.01.0001', '', '',
0, 0, 0, '', '', 0, 0, 0, 0, SECNO, SECPOSSEQNO, ISINCLFUNDUNBUNDLING,
POSITIONTYPECD, CASE WHEN(NBR < 0) THEN 'L ' ELSE 'A ' END, ASSETMAINCL
ASS, CASE WHEN(ASSETMAINCLASS = '05' AND ANALYSISCCYCD = '0010') THEN '
0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '05' AND ANALYSISCCYCD <> '0
010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '10' AND ANALYSI
SCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '10'
AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINC
LASS = '15' AND ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN
(ASSETMAINCLASS = '15' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSI
SCCYCD WHEN(ASSETMAINCLASS = '17') THEN ASSETSUBCLASS WHEN(ASSETMAINCL
ASS = '20' AND ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(
ASSETMAINCLASS = '20' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSIS
CCYCD WHEN(ASSETMAINCLASS = '21') THEN ANALYSISCCYCD WHEN(ASSETMAINCLA
SS = '23') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '24' AND MTYDT IS N
OT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) ||
SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '24' AND MTYDT IS NULL)
THEN '99991231' WHEN(ASSETMAINCLASS = '25' AND ANALYSISCNTRYCD = '210'
) THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '25' AND ANALYSISC
NTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '26
') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '30') THEN ASSETSUBCLASS W
HEN(ASSETMAINCLASS = '32' AND ANALYSISCNTRYCD = '210') THEN '0' || ANAL
YSISCNTRYCD WHEN(ASSETMAINCLASS = '32' AND ANALYSISCNTRYCD <> '210') TH
EN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '35') THEN '1' WHEN(A
SSETMAINCLASS = '37') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '40' AND
ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS
= '40' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(AS
SETMAINCLASS = '45') THEN ASSETSUBCLASS ELSE '' END, CASE WHEN(ASSETMAI
NCLASS = '05') THEN '1' WHEN(ASSETMAINCLASS = '10' AND MTYDT IS NOT NUL
L) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBST
R(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '10' AND MTYDT IS NULL) THEN
'99991231' WHEN(ASSETMAINCLASS = '15' AND MTYDT IS NOT NULL) THEN SUBST
R(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT)
, 1, 2) WHEN(ASSETMAINCLASS = '15' AND MTYDT IS NULL) THEN '99991231' W
HEN(ASSETMAINCLASS = '17' AND ANALYSISCCYCD = '0010') THEN '0' || ANALY
SISCCYCD WHEN(ASSETMAINCLASS = '17' AND ANALYSISCCYCD <> '0010') THEN '
1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '20') THEN ASSETSUBCLASS WH
EN(ASSETMAINCLASS = '21' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT)
, 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(A
SSETMAINCLASS = '21' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINC
LASS = '23' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SU
BSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS
= '23' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '24' A
ND ANALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAIN
CLASS = '24' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD
WHEN(ASSETMAINCLASS = '25') THEN SECNO WHEN(ASSETMAINCLASS = '26' AND
ANALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLA
SS = '26' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WH
EN(ASSETMAINCLASS = '30' AND ANALYSISCNTRYCD = '210') THEN '0' || ANALY
SISCNTRYCD WHEN(ASSETMAINCLASS = '30' AND ANALYSISCNTRYCD <> '210') THE
N '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '37' AND POLICENO IS NO
T NULL) THEN POLICENO || '1' WHEN(ASSETMAINCLASS = '37' AND POLICENO I
S NULL) THEN ' ' || '1' WHEN(ASSETMAINCLASS = '40') THEN ASSETSUB
CLASS WHEN(ASSETMAINCLASS = '45') THEN '1' ELSE '' END, CASE WHEN(ASSE
TMAINCLASS = '05') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '10') THEN
'1' WHEN(ASSETMAINCLASS = '15') THEN '1' WHEN(ASSETMAINCLASS = '20' AN
D MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYD
T), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '20' AND MT
YDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '21') THEN SECNO WH
EN(ASSETMAINCLASS = '23' AND ANALYSISCNTRYCD = '210') THEN '0' WHEN(ASS
ETMAINCLASS = '23' AND ANALYSISCNTRYCD <> '210') THEN '1' WHEN(ASSETMAI
NCLASS = '24') THEN SECNO WHEN(ASSETMAINCLASS = '26') THEN SECNO WHEN(
ASSETMAINCLASS = '30') THEN SECNO WHEN(ASSETMAINCLASS = '37') THEN SECN
O WHEN(ASSETMAINCLASS = '45') THEN SECNO ELSE '' END, CASE WHEN(ASSETM
AINCLASS = '10') THEN SECNO WHEN(ASSETMAINCLASS = '15') THEN SECNO WHE
N(ASSETMAINCLASS = '20') THEN SECNO WHEN(ASSETMAINCLASS = '23') THEN SE
CNO ELSE '' END, YIELDPERCPRICE2, YIELDPERCAVGPURCHPRICE2, YIELDPERCPRI
CE3, YIELDPERCAVGPURCHPRICE3, YIELDPERCPRICE4, YIELDPERCAVGPURCHPRICE4,
YIELDPERCPRICE5, YIELDPERCAVGPURCHPRICE5, 0, 0, 0, 0, 0, 0, SECDESCR,
RELUUID, 0, VALCCYCD, 0, FOREIGNPOLICYNO, DEPOSITRUBRICCD, DEPOSITEFFCD
, DEPOSITAWDCD, PREMATUREREDEMPTDTCREDIT, CNTRYCD, '', PILLARTYPECD, ''
, ISMANDATECUSTOMER, MANDATEDESCR, 0, SECPRICETIMESTMP, SECPRICEACTTYPE
CD , CSFIID, 0, VALIDTODT FROM OA1X.VAV112J4 UNION ALL SELECT PARTITI
ONID, OBJUUID, 0, 0, 0, 0, 0, NBR, '', '', 0, '01.01.0001', '', '', 0,
0, '', '', 0, '01.01.0001', 0, 0, 0, 0, 0, 0, 0, '01.01.0001', 0, '01.0
1.0001', '01.01.0001', 0, 0, 0, '01.01.0001', 0, 0, 0, '01.01.0001', 0,
'01.01.0001', 0, 0, 0, 0, '', 0, '', 0, 0, MTYDT, '', '', '01.01.0001'
, 0, 0, '', '01.01.0001', 0, 0, 0, 0, OBJECTTYPECD, REPRTUUID, SAFEKACC
NO, POLICENO, '', ASSETMAINCLASS, ASSETSUBCLASS, SECNO, SECPOSSEQNO, 0,
0, 0, '', SECCCYCD, '', '', '', '', 0, '', '', '', '', 0, '', '', '',
0, '', '', '', '', NOMVALUE, '', 0, 0, 0, '', '01.01.0001', '', '', '',
'', '', '', '01.01.0001', '', 0 , '', 0, 0, '', 0, 0, '', '01.01.0001',
'01.01.0001', '', '01.01.0001' , '', '', 0, 0, 0, '', '', 0, 0, 0, 0, '
', '', '', 0, CASE WHEN(NBR > 0) THEN 'A ' WHEN(NOMVALUE > 0) THEN 'A
' ELSE 'L ' END, ASSETMAINCLASS, ASSETSUBCLASS, POLICENO || '0', SECNO,
'', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 , 0, 0, 0, 0, SECDESCR, '', 0, VALCCYC
D, 0, '', '', '', '', '01.01.0001', '', '', 0, '', '', '', 0, '', 0, ''
, 0, '01.01.0001' FROM OA1X.VAV141A1 UNION ALL SELECT PARTITIONID, O
BJUUID, MKTVALINREPRTCCY, MKTVALINCOMPCCY, 0, ACCRINTINREPRTCCY, ACCRIN
TINCOMPCCY, 0, VALTYPECD, '', 0, '01.01.0001' , '', '', 0, 0, '', '', 0,
NEXTINTRSTDT, NONREALPLPERCFX, NONREALPLPERCPRICE, NONREALPLVALFXINVAL
CCY, NONREALPLVALPRICE, NONREALPLPERCTOT, NONREALPLVALTOT, 0, '01.01.00
01', 0, '01.01.0001', '01.01.0001', 0, EXCHGRATEREPRTCCY, EXCHGRATECOMP
CCY, EXCHGRATEDT, 0, 0 , 0, '01.01.0001', 0, '01.01.0001', 0, COLLATRATI
OEFF, COLLATVALEFFINREPRTCCY, COLLATVALEFFINCOMPCCY, '', 0, '', 0, 0,
'01.01.0001', ANALYSISCCYCD, ANALYSISCNTRYCD, '01.01.0001', 0, 0, CIFNO
, LASTMOVEMENTDT, EXPGROSSREVENUE, GROSSREVENUE, WHTAXVAL, 0, OBJECTTYP
ECD, REPRTUUID, '', '', CIFNOCUSTOMERPILLAR, ASSETMAINCLASS, ASSETSUBCL
ASS, '', '', 0, 0, 0, '', '', '', ANALYSISSECTCD, ANALYSISDEBTORCD, BVG
CATCD, 0, '', '', '', '', 0, '', '', '', 0, '', '' , '', '', 0, '', 0, 0
, 0, ACCCCYCD, LASTINTRSTDT, ACCDESCR, ACCNO, CLSTRID, ACCTYPECD, ISCRE
DITUSEACC, IBANNO, '01.01.0001', '', 0, '', 0 , 0, '', 0, 0, '', '01.01.
0001', '01.01.0001', '', '01.01.0001', '', '' , 0, 0, 0, '', '', 0, 0, 0
, 0, '', '', '', POSITIONTYPECD, CASE WHEN(MKTVALINREPRTCCY < 0) THEN '
L ' ELSE 'A ' END, ASSETMAINCLASS, CASE WHEN(ASSETMAINCLASS = '05' AND
ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS
= '05' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(AS
SETMAINCLASS = '10' AND ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCY
CD WHEN(ASSETMAINCLASS = '10' AND ANALYSISCCYCD <> '0010') THEN '1' ||
ANALYSISCCYCD WHEN(ASSETMAINCLASS = '15' AND ANALYSISCCYCD = '0010') T
HEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '15' AND ANALYSISCCYCD
<> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '17') THEN
ASSETSUBCLASS WHEN(ASSETMAINCLASS = '20' AND ANALYSISCCYCD = '0010') TH
EN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '20' AND ANALYSISCCYCD <
> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '21') THEN A
NALYSISCCYCD WHEN(ASSETMAINCLASS = '23') THEN ASSETSUBCLASS WHEN(ASSET
MAINCLASS = '24') THEN '99991231' WHEN(ASSETMAINCLASS = '25' AND ANALYS
ISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '
25' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASS
ETMAINCLASS = '26') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '30') THEN
ASSETSUBCLASS WHEN(ASSETMAINCLASS = '32' AND ANALYSISCNTRYCD = '210')
THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '32' AND ANALYSISCNT
RYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '35')
THEN '2' WHEN(ASSETMAINCLASS = '37') THEN ASSETSUBCLASS WHEN(ASSETMAI
NCLASS = '40' AND ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WH
EN(ASSETMAINCLASS = '40' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALY
SISCCYCD WHEN(ASSETMAINCLASS = '45') THEN ASSETSUBCLASS ELSE '' END, CA
SE WHEN(ASSETMAINCLASS = '05') THEN '2' WHEN(ASSETMAINCLASS = '10') TH
EN '99991231' WHEN(ASSETMAINCLASS = '15') THEN '99991231' WHEN(ASSETMA
INCLASS = '17' AND ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD W
HEN(ASSETMAINCLASS = '17' AND ANALYSISCCYCD <> '0010') THEN '1' || ANAL
YSISCCYCD WHEN(ASSETMAINCLASS = '20') THEN ASSETSUBCLASS WHEN(ASSETMAI
NCLASS = '21') THEN '99991231' WHEN(ASSETMAINCLASS = '23') THEN '999912
31' WHEN(ASSETMAINCLASS = '24' AND ANALYSISCNTRYCD = '210') THEN '0' ||
ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '24' AND ANALYSISCNTRYCD <> '21
0') THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '26' AND ANALYSI
SCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '2
6' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASSE
TMAINCLASS = '30' AND ANALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTR
YCD WHEN(ASSETMAINCLASS = '30' AND ANALYSISCNTRYCD <> '210') THEN '1' |
| ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '40') THEN ASSETSUBCLASS WHEN
(ASSETMAINCLASS = '45') THEN '2' ELSE '' END, CASE WHEN(ASSETMAINCLASS
= '05') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '10') THEN '2' WHEN(A
SSETMAINCLASS = '15') THEN '2' WHEN(ASSETMAINCLASS = '20') THEN '999912
31' WHEN(ASSETMAINCLASS = '23' AND ANALYSISCNTRYCD = '210') THEN '0' W
HEN(ASSETMAINCLASS = '23' AND ANALYSISCNTRYCD <> '210') THEN '1' WHEN(A
SSETMAINCLASS = '45') THEN ACCNO ELSE '' END, CASE WHEN(ASSETMAINCLASS
= '10') THEN ACCNO WHEN(ASSETMAINCLASS = '15') THEN SUBSTR(ACCDESCR, 1,
20) ELSE '' END, 0 , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', RELUUID
, MKTVALINACCCCY, VALCCYCD, 0, '', '', '', '', '01.01.0001', '', '', PI
LLARTYPECD, '', '' , '', 0, '', 0, '', 0, VALIDTODT FROM OA1X.VAV121J3
UNION ALL SELECT PARTITIONID, OBJUUID, MKTVALINREPRTCCY, MKTVALINCOMPC
CY, 0, ACCRINTINREPRTCCY, ACCRINTINCOMPCCY, 0, VALTYPECD, '', 0, '01.01
.0001' , '', AVGPURCHPRICECCYCD, AVGPURCHPRICE, AVGPURCHEXCHGRATE, AVGP
URCHPRICETYPECD, '', 0, NEXTINTRSTDT, NONREALPLPERCFX, NONREALPLPERCPRI
CE, NONREALPLVALFXINVALCCY, NONREALPLVALPRICE, NONREALPLPERCTOT, NONREA
LPLVALTOT, 0, '01.01.0001', 0, '01.01.0001', '01.01.0001', 0, EXCHGRATE
REPRTCCY, EXCHGRATECOMPCCY, EXCHGRATEDT, 0, 0 , 0, '01.01.0001', 0, '01.
01.0001', 0, COLLATRATIOEFF, COLLATVALEFFINREPRTCCY, COLLATVALEFFINCOMP
CCY, '', 0, '', 0, 0, '01.01.0001', ANALYSISCCYCD, ANALYSISCNTRYCD, '01
.01.0001', 0, 0, CIFNO , LASTMOVEMENTDT, EXPGROSSREVENUE, GROSSREVENUE,
WHTAXVAL, 0, OBJECTTYPECD, REPRTUUID, '', '', CIFNOCUSTOMERPILLAR, ASSE
TMAINCLASS, ASSETSUBCLASS, '', '', 0, 0, 0, '', '', '', ANALYSISSECTCD,
ANALYSISDEBTORCD, BVGCATCD, 0, '', '', '', '', 0, '', '', '', 0, '', '
' , '', '', 0, '', 0, 0, 0, ACCCCYCD, LASTINTRSTDT, ACCDESCR, ACCNO, CL
STRID, ACCTYPECD, ISCREDITUSEACC, IBANNO, '01.01.0001', '', 0, '', 0 , 0
, '', 0, 0, '', '01.01.0001', '01.01.0001', '', '01.01.0001', '', '' , 0
, 0, 0, '', '', 0, 0, 0, 0, '', '', '', POSITIONTYPECD, CASE WHEN(MKTVA
LINREPRTCCY < 0) THEN 'L ' ELSE 'A ' END, ASSETMAINCLASS, CASE WHEN(AS
SETMAINCLASS = '05' AND ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCY
CD WHEN(ASSETMAINCLASS = '05' AND ANALYSISCCYCD <> '0010') THEN '1' ||
ANALYSISCCYCD WHEN(ASSETMAINCLASS = '10' AND ANALYSISCCYCD = '0010') T
HEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '10' AND ANALYSISCCYCD
<> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '15' AND AN
ALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS =
'15' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSET
MAINCLASS = '17') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '20' AND ANA
LYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '
20' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETM
AINCLASS = '21') THEN ANALYSISCCYCD WHEN(ASSETMAINCLASS = '23') THEN AS
SETSUBCLASS WHEN(ASSETMAINCLASS = '24') THEN '99991231' WHEN(ASSETMAIN
CLASS = '25' AND ANALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD
WHEN(ASSETMAINCLASS = '25' AND ANALYSISCNTRYCD <> '210') THEN '1' || AN
ALYSISCNTRYCD WHEN(ASSETMAINCLASS = '26') THEN ASSETSUBCLASS WHEN(ASSE
TMAINCLASS = '30') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '32' AND AN
ALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS
= '32' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN
(ASSETMAINCLASS = '35') THEN '2' WHEN(ASSETMAINCLASS = '37') THEN ASSET
SUBCLASS WHEN(ASSETMAINCLASS = '40' AND ANALYSISCCYCD = '0010') THEN '0
' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '40' AND ANALYSISCCYCD <> '00
10') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '45') THEN ASSETS
UBCLASS ELSE '' END, CASE WHEN(ASSETMAINCLASS = '05') THEN '2' WHEN(AS
SETMAINCLASS = '10') THEN '99991231' WHEN(ASSETMAINCLASS = '15') THEN '
99991231' WHEN(ASSETMAINCLASS = '17' AND ANALYSISCCYCD = '0010') THEN '
0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '17' AND ANALYSISCCYCD <> '0
010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '20') THEN ASSET
SUBCLASS WHEN(ASSETMAINCLASS = '21') THEN '99991231' WHEN(ASSETMAINCLA
SS = '23') THEN '99991231' WHEN(ASSETMAINCLASS = '24' AND ANALYSISCNTRY
CD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '24' AND
ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINC
LASS = '26' AND ANALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD W
HEN(ASSETMAINCLASS = '26' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANA
LYSISCNTRYCD WHEN(ASSETMAINCLASS = '30' AND ANALYSISCNTRYCD = '210') TH
EN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '30' AND ANALYSISCNTRY
CD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '40') T
HEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '45') THEN '2' ELSE '' END, CAS
E WHEN(ASSETMAINCLASS = '05') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS =
'10') THEN '2' WHEN(ASSETMAINCLASS = '15') THEN '2' WHEN(ASSETMAINCLA
SS = '20') THEN '99991231' WHEN(ASSETMAINCLASS = '23' AND ANALYSISCNTRY
CD = '210') THEN '0' WHEN(ASSETMAINCLASS = '23' AND ANALYSISCNTRYCD <>
'210') THEN '1' WHEN(ASSETMAINCLASS = '45') THEN ACCNO ELSE '' END, CAS
E WHEN(ASSETMAINCLASS = '10') THEN ACCNO WHEN(ASSETMAINCLASS = '15') T
HEN SUBSTR(ACCDESCR, 1, 20) ELSE '' END, 0 , 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, '', RELUUID, MKTVALINACCCCY, VALCCYCD, 0, '', '', '', '', '
01.01.0001', '', '', 0, AVGPURCHEXCHGRATECTRCCYCD, '', '', 0, '', 0, ''
, 0, VALIDTODT FROM OA1X.VAV122J3 UNION ALL SELECT PARTITIONID, OBJU
UID, MKTVALINREPRTCCY, MKTVALINCOMPCCY, 0, ACCRINTINREPRTCCY, ACCRINTIN
COMPCCY, 0, VALTYPECD, '', 0, '01.01.0001' , '', '', 0, 0, '', '', 0, NE
XTINTRSTDT, NONREALPLPERCFX, NONREALPLPERCPRICE, NONREALPLVALFXINVALCCY
, NONREALPLVALPRICE, NONREALPLPERCTOT, NONREALPLVALTOT, 0, '01.01.0001'
, 0, '01.01.0001', '01.01.0001', 0, EXCHGRATEREPRTCCY, EXCHGRATECOMPCCY
, EXCHGRATEDT, 0, 0 , 0, '01.01.0001', 0, '01.01.0001', EXPEARNINREPRTCC
Y, 0, 0, 0, '', 0, '', 0, 0, MTYDT, ANALYSISCCYCD, ANALYSISCNTRYCD, '01
.01.0001', 0, 0, CIFNO, LASTMOVEMENTDT, EXPGROSSREVENUE, GROSSREVENUE,
WHTAXVAL, 0, OBJECTTYPECD, REPRTUUID, '', '', CIFNOCUSTOMERPILLAR, ASSE
TMAINCLASS, ASSETSUBCLASS, '', '', 0, 0, 0, '', '', '', ANALYSISSECTCD,
ANALYSISDEBTORCD, BVGCATCD, 0, '', '', '', '', 0, '', '', '', 0, '', '
' , '', '', 0, '', 0, 0, 0, ACCCCYCD, LASTINTRSTDT, ACCDESCR, ACCNO, CL
STRID, ACCTYPECD, '', '', '01.01.0001', '', 0, '', 0, 0, '', 0, 0, '' ,
'01.01.0001', '01.01.0001', '', '01.01.0001', '', '', 0, 0, 0, '', '' ,
0, 0, 0, 0, '', '', '', POSITIONTYPECD, CASE WHEN(MKTVALINREPRTCCY < 0)
THEN 'L ' ELSE 'A ' END, ASSETMAINCLASS, CASE WHEN(ASSETMAINCLASS = '
05' AND ANALYSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMA
INCLASS = '05' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD
WHEN(ASSETMAINCLASS = '10' AND ANALYSISCCYCD = '0010') THEN '0' || ANAL
YSISCCYCD WHEN(ASSETMAINCLASS = '10' AND ANALYSISCCYCD <> '0010') THEN
'1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '15' AND ANALYSISCCYCD = '0
010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '15' AND ANALYSI
SCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '17'
) THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '20' AND ANALYSISCCYCD = '00
10') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '20' AND ANALYSIS
CCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '21')
THEN ANALYSISCCYCD WHEN(ASSETMAINCLASS = '23') THEN ASSETSUBCLASS WHE
N(ASSETMAINCLASS = '24' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT),
7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(AS
SETMAINCLASS = '24' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCL
ASS = '25' AND ANALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WH
EN(ASSETMAINCLASS = '25' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANAL
YSISCNTRYCD WHEN(ASSETMAINCLASS = '26') THEN ASSETSUBCLASS WHEN(ASSETM
AINCLASS = '30') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '32' AND ANAL
YSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS =
'32' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN(A
SSETMAINCLASS = '35') THEN '2' WHEN(ASSETMAINCLASS = '37') THEN ASSETSU
BCLASS WHEN(ASSETMAINCLASS = '40' AND ANALYSISCCYCD = '0010') THEN '0'
|| ANALYSISCCYCD WHEN(ASSETMAINCLASS = '40' AND ANALYSISCCYCD <> '0010
') THEN '1' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '45') THEN ASSETSUB
CLASS ELSE '' END, CASE WHEN(ASSETMAINCLASS = '05') THEN '2' WHEN(ASSE
TMAINCLASS = '10' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4)
|| SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAI
NCLASS = '10' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS =
'15' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CH
AR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '15'
AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '17' AND ANAL
YSISCCYCD = '0010') THEN '0' || ANALYSISCCYCD WHEN(ASSETMAINCLASS = '1
7' AND ANALYSISCCYCD <> '0010') THEN '1' || ANALYSISCCYCD WHEN(ASSETMA
INCLASS = '20') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '21' AND MTYDT
IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4,
2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '21' AND MTYDT IS
NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '23' AND MTYDT IS NOT NULL)
THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(
CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '23' AND MTYDT IS NULL) THEN '9
9991231' WHEN(ASSETMAINCLASS = '24' AND ANALYSISCNTRYCD = '210') THEN '
0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '24' AND ANALYSISCNTRYCD <
> '210') THEN '1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '26' AND AN
ALYSISCNTRYCD = '210') THEN '0' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS
= '26' AND ANALYSISCNTRYCD <> '210') THEN '1' || ANALYSISCNTRYCD WHEN
(ASSETMAINCLASS = '30' AND ANALYSISCNTRYCD = '210') THEN '0' || ANALYSI
SCNTRYCD WHEN(ASSETMAINCLASS = '30' AND ANALYSISCNTRYCD <> '210') THEN
'1' || ANALYSISCNTRYCD WHEN(ASSETMAINCLASS = '40') THEN ASSETSUBCLASS
WHEN(ASSETMAINCLASS = '45') THEN '2' ELSE '' END, CASE WHEN(ASSETMAINC
LASS = '05') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '10') THEN '2' W
HEN(ASSETMAINCLASS = '15') THEN '2' WHEN(ASSETMAINCLASS = '20' AND MTYD
T IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4,
2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '20' AND MTYDT IS
NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '23' AND ANALYSISCNTRYCD =
'210') THEN '0' WHEN(ASSETMAINCLASS = '23' AND ANALYSISCNTRYCD <> '210
') THEN '1' WHEN(ASSETMAINCLASS = '45') THEN ACCNO ELSE '' END, CASE W
HEN(ASSETMAINCLASS = '10') THEN ACCNO WHEN(ASSETMAINCLASS = '15') THEN
SUBSTR(ACCDESCR, 1, 20) ELSE '' END, 0 , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
, 0, 0, '', RELUUID, MKTVALINACCCCY, VALCCYCD, 0, '', '', '', '', '01.0
1.0001', '', '', 0, '', '', '', COLLATVALEFFINACCCCY, '', 0, '', 0, VAL
IDTODT FROM OA1X.VAV123J3 UNION ALL SELECT PARTITIONID, OBJUUID, MKTV
ALINREPRTCCY, MKTVALINCOMPCCY, 0, 0, 0, 0, '', '', 0, '01.01.0001', '',
'', 0, 0, '', '', 0, '01.01.0001', NONREALPLPERCFX, 0, 0, 0, 0, 0, 0,
'01.01.0001', 0, '01.01.0001', '01.01.0001', 0, 0, 0, '01.01.0001', 0,
0, 0, '01.01.0001', 0, '01.01.0001', 0, 0, 0, 0, '', 0, '', 0, 0, MTYDT
, COUNTERCCYCD, '210', '01.01.0001', 0, 0, CIFNO, '01.01.0001', 0, 0, 0
, 0, OBJECTTYPECD, REPRTUUID, '', '', '', ASSETMAINCLASS, ASSETSUBCLASS
, '', '', 0, 0, 0, '', '', '', '000', '05', BVGCATCD, 0, '', '', '', ''
, 0, '', '', '', 0 , '', '', '', '', 0, '', 0, 0, 0, '', '01.01.0001', '
', '', CLSTRID, '' , '', '', DEALDT, TRDCCYCD, TRDPRINCIPALVAL, COUNTERC
CYCD, PRINCIPALAMOUNTINCOUNTERCCY, STRIKEPRICE, ISPARTIALTRX, PRICE, T
REASURYTYPECD, TRDEUID, INPUTDT, REVLTNDT, TRXTYPECD, EXPIRYDT, OPICSDE
ALNO, PREMIUMCCYCD, PREMIUMVALINPREMIUMCCY, PREMIUMVALINCOMPCCY , MKTPRE
MIUMBASE, STRATEGY, EXOTIC, PREMIUMVALINTRDCCY, PREMIUMVALINCOUNTERCCY,
PREMIUMVALINREPRTCCY, PREMIUMVALINVALCCY, '', '', '', POSITIONTYPECD,
CASE WHEN(MKTVALINREPRTCCY < 0) THEN 'L ' ELSE 'A ' END, ASSETMAINCLASS
, CASE WHEN(ASSETMAINCLASS = '17') THEN ASSETSUBCLASS WHEN(ASSETMAINC
LASS = '23') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '24' AND MTYDT IS
NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2)
|| SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '24' AND MTYDT IS NUL
L) THEN '99991231' WHEN(ASSETMAINCLASS = '26') THEN ASSETSUBCLASS WHEN
(ASSETMAINCLASS = '30') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '35')
THEN '3' WHEN(ASSETMAINCLASS = '37') THEN ASSETSUBCLASS WHEN(ASSETMAIN
CLASS = '45') THEN ASSETSUBCLASS ELSE '' END, CASE WHEN(ASSETMAINCLASS
= '05') THEN '3' WHEN(ASSETMAINCLASS = '10' AND MTYDT IS NOT NULL) THEN
SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(
MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '10' AND MTYDT IS NULL) THEN '999912
31' WHEN(ASSETMAINCLASS = '15' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR(
MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2)
WHEN(ASSETMAINCLASS = '15' AND MTYDT IS NULL) THEN '99991231' WHEN(ASS
ETMAINCLASS = '17' AND COUNTERCCYCD = '0010') THEN '0' || COUNTERCCYCD
WHEN(ASSETMAINCLASS = '17' AND COUNTERCCYCD <> '0010') THEN '1' || COU
NTERCCYCD WHEN(ASSETMAINCLASS = '20') THEN ASSETSUBCLASS WHEN(ASSETMAI
NCLASS = '21' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) ||
SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLA
SS = '21' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '23'
AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(M
TYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '23' AND
MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '40') THEN ASSETS
UBCLASS WHEN(ASSETMAINCLASS = '45') THEN '3' ELSE '' END, CASE WHEN(AS
SETMAINCLASS = '05') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '10') THE
N '3' WHEN(ASSETMAINCLASS = '15') THEN '3' WHEN(ASSETMAINCLASS = '20'
AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MT
YDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '20' AND
MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '23') THEN '0' ELS
E '' END, '', 0, 0, 0, 0, 0, 0 , 0, 0, BALANCEOFTRDPARTINTRDCCY, BALANCE
OFTRDPARTINREPRTCCY, BALANCEOFTRDPARTINCOMPCCY, BALANCEOFCTRPARTINCTRCC
Y, BALANCEOFCTRPARTINREPRTCCY, BALANCEOFCTRPARTINCOMPCCY, '', RELUUID,
0, VALCCYCD, MKTVALINVALCCY, '', '', '', '', '01.01.0001', '', BASECCYC
D, 0, '', '', '', 0, '', 0, '', 0, VALIDTODT FROM OA1X.VAV132A3 UNION
ALL SELECT PARTITIONID, OBJUUID, MKTVALINREPRTCCY, MKTVALINCOMPCCY, 0,
0, 0, 0, '', '', 0, '01.01.0001', '', '', AVGPURCHPRICE, 0, '', '', 0,
'01.01.0001', NONREALPLPERCFX, 0, 0, 0, 0, 0, 0, '01.01.0001', 0, '01
.01.0001', '01.01.0001', 0, 0, 0, '01.01.0001', 0, 0, 0, '01.01.0001',
0, '01.01.0001', 0, 0, 0, 0, '', 0, '', 0, 0, MTYDT, COUNTERCCYCD, '210
', '01.01.0001', 0, 0, CIFNO, '01.01.0001', 0, 0, 0, 0, OBJECTTYPECD, R
EPRTUUID, '', '', '', ASSETMAINCLASS, ASSETSUBCLASS, '', '', 0, 0, 0, '
', '', '', '000', '05', BVGCATCD, 0, '', '', '', '', 0, '', '', '', 0,
'', '', '', '', 0, '', 0, 0, 0, '', '01.01.0001', '' , '', CLSTRID, '',
'', '', '01.01.0001', TRDCCYCD, TRDPRINCIPALVAL, COUNTERCCYCD, PRINCIPA
LAMOUNTINCOUNTERCCY, STRIKEPRICE, ISPARTIALTRX, PRICE, TREASURYTYPECD,
'', '01.01.0001', '01.01.0001', TRXTYPECD, '01.01.0001', '', '', 0, 0,
0, '', '', 0, 0, 0, 0, '', '', '', POSITIONTYPECD, CASE WHEN(MKTVALINR
EPRTCCY < 0) THEN 'L ' ELSE 'A ' END, ASSETMAINCLASS, CASE WHEN(ASSETM
AINCLASS = '17') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '23') THEN AS
SETSUBCLASS WHEN(ASSETMAINCLASS = '24' AND MTYDT IS NOT NULL) THEN SUBS
TR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT
), 1, 2) WHEN(ASSETMAINCLASS = '24' AND MTYDT IS NULL) THEN '99991231'
WHEN(ASSETMAINCLASS = '26') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '3
0') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '35') THEN '3' WHEN(ASSET
MAINCLASS = '37') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '45') THEN A
SSETSUBCLASS ELSE '' END, CASE WHEN(ASSETMAINCLASS = '05') THEN '3' WH
EN(ASSETMAINCLASS = '10' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT)
, 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(A
SSETMAINCLASS = '10' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINC
LASS = '15' AND MTYDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SU
BSTR(CHAR(MTYDT), 4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS
= '15' AND MTYDT IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '17' A
ND COUNTERCCYCD = '0010') THEN '0' || COUNTERCCYCD WHEN(ASSETMAINCLASS
= '17' AND COUNTERCCYCD <> '0010') THEN '1' || COUNTERCCYCD WHEN(ASSE
TMAINCLASS = '20') THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '21' AND MT
YDT IS NOT NULL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT),
4, 2) || SUBSTR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '21' AND MTYDT
IS NULL) THEN '99991231' WHEN(ASSETMAINCLASS = '23' AND MTYDT IS NOT NU
LL) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBS
TR(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '23' AND MTYDT IS NULL) THEN
'99991231' WHEN(ASSETMAINCLASS = '40') THEN ASSETSUBCLASS WHEN(ASSETM
AINCLASS = '45') THEN '3' ELSE '' END, CASE WHEN(ASSETMAINCLASS = '05')
THEN ASSETSUBCLASS WHEN(ASSETMAINCLASS = '10') THEN '3' WHEN(ASSETMAI
NCLASS = '15') THEN '3' WHEN(ASSETMAINCLASS = '20' AND MTYDT IS NOT NUL
L) THEN SUBSTR(CHAR( MTYDT), 7, 4) || SUBSTR(CHAR(MTYDT), 4, 2) || SUBST
R(CHAR(MTYDT), 1, 2) WHEN(ASSETMAINCLASS = '20' AND MTYDT IS NULL) THEN
'99991231' WHEN(ASSETMAINCLASS = '23') THEN '0' ELSE '' END, '', 0, 0,
0, 0, 0, 0 , 0, 0, BALANCEOFTRDPARTINTRDCCY, BALANCEOFTRDPARTINREPRTCCY,
BALANCEOFTRDPARTINCOMPCCY, BALANCEOFCTRPARTINCTRCCY, BALANCEOFCTRPART
INREPRTCCY, BALANCEOFCTRPARTINCOMPCCY, '', RELUUID, 0, VALCCYCD, MKTVAL
INVALCCY, '', '', '', '', '01.01.0001', '', '', 0, '', '', '', 0, '', 0
, '', NBROFCONTRACTS, VALIDTODT FROM OA1X.VAV135A3 ;
COMMIT;