zOs/SQL/GUBLERAL

SET CURRENT SQLID = 'S100447';                                          00001001
CREATE ALIAS VDPS.XPS_VLIID002_V04 FOR VDPS2.XPS_VLIID002_V04;          00001208
COMMIT;                                                                 00001309
CREATE ALIAS VDPS.XPS_VLIID002_V02 FOR VDPS2.XPS_VLIID002_V02;          00001408
COMMIT;                                                                 00001608
X                                                                       00001708
CREATE ALIAS S107189.VTCAFLCOMPENSATION FOR VDPS2.VTCAFLCOMPENSATION;   00001808
CREATE ALIAS S107189.VTCASHFLOWCURROPT FOR VDPS2.VTCASHFLOWCURROPT ;    00001908
CREATE ALIAS S107189.VTCFDETAIL      FOR VDPS2.VTCFDETAIL        ;      00002008
CREATE ALIAS S107189.VTCFEXPRICEPART FOR VDPS2.VTCFEXPRICEPART   ;      00002108
CREATE ALIAS S107189.VTCFFIXEDEXCHRATE FOR VDPS2.VTCFFIXEDEXCHRATE ;    00002208
CREATE ALIAS S107189.VTCFNUMBERFINAL FOR VDPS2.VTCFNUMBERFINAL   ;      00002308
CREATE ALIAS S107189.VTCFNUMBERRANGE FOR VDPS2.VTCFNUMBERRANGE   ;      00002408
CREATE ALIAS S107189.VTCASHFLOWREINLIST FOR VDPS2.VTCASHFLOWREINLIST;   00002508
CREATE ALIAS S107189.VTCASHFLOWREINVEST FOR VDPS2.VTCASHFLOWREINVEST;   00002608
CREATE ALIAS S107189.VTCFREPAYMENT   FOR VDPS2.VTCFREPAYMENT     ;      00002708
CREATE ALIAS S107189.VTCFCOMPONENTPROP FOR VDPS2.VTCFCOMPONENTPROP ;    00002808
CREATE ALIAS S107189.VTCASHFLOWTAXAMT FOR VDPS2.VTCASHFLOWTAXAMT ;      00002908
CREATE ALIAS S107189.VTCASHFLSUBPERIOD FOR VDPS2.VTCASHFLSUBPERIOD ;    00003008
CREATE ALIAS S107189.VTCFEVENTEXDATE FOR VDPS2.VTCFEVENTEXDATE   ;      00003108
CREATE ALIAS S107189.VTCFEVNTEXDTLIQAMT FOR VDPS2.VTCFEVNTEXDTLIQAMT;   00003208
CREATE ALIAS S107189.VTCSEVENTDETAIL FOR VDPS2.VTCSEVENTDETAIL   ;      00003308
CREATE ALIAS S107189.VTELIGIBLINSTRPROP FOR VDPS2.VTELIGIBLINSTRPROP;   00003408
CREATE ALIAS S107189.VTEVENTRESTRICTION FOR VDPS2.VTEVENTRESTRICTION;   00003508
CREATE ALIAS S107189.VTINSTRUMENTEVENT FOR VDPS2.VTINSTRUMENTEVENT ;    00003608
CREATE ALIAS S107189.VTTAXRATETAXAMOUNT FOR VDPS2.VTTAXRATETAXAMOUNT;   00003708
CREATE ALIAS S107189.VTTOFF          FOR VDPS2.VTTOFF            ;      00003808
CREATE ALIAS S107189.VTUNDERFIXING   FOR VDPS2.VTUNDERFIXING     ;      00003908
CREATE ALIAS S107189.VTUNDERFXCOMPONENT FOR VDPS2.VTUNDERFXCOMPONENT;   00004008
CREATE ALIAS S107189.VTCFVARINTRTFIXING FOR VDPS2.VTCFVARINTRTFIXING;   00004108
CREATE ALIAS S107189.VTHYBRIINSTRDETAIL FOR VDPS2.VTHYBRIINSTRDETAIL;   00004208
CREATE ALIAS S107189.VTPAIRINSTRUMENT FOR VDPS2.VTPAIRINSTRUMENT ;      00004308
CREATE ALIAS S107189.VTUNDERFIXINGREF FOR VDPS2.VTUNDERFIXINGREF ;      00004408
CREATE ALIAS S107189.VTUNDERFIXREFCOMP FOR VDPS2.VTUNDERFIXREFCOMP ;    00004508
CREATE ALIAS S107189.VTCFEXERCISE    FOR VDPS2.VTCFEXERCISE      ;      00004608
CREATE ALIAS S107189.VTCFEVENT       FOR VDPS2.VTCFEVENT         ;      00004708
CREATE ALIAS S107189.VTCASHFLOWAMOUNT FOR VDPS2.VTCASHFLOWAMOUNT ;      00004808
COMMIT;                                                                 00005007
CREATE ALIAS VDPS.VTCAFLCOMPENSATION FOR VDPS2.VTCAFLCOMPENSATION;      00010003
CREATE ALIAS VDPS.VTCASHFLOWCURROPT  FOR VDPS2.VTCASHFLOWCURROPT ;      00020003
CREATE ALIAS VDPS.VTCFDETAIL         FOR VDPS2.VTCFDETAIL        ;      00030003
CREATE ALIAS VDPS.VTCFEXPRICEPART    FOR VDPS2.VTCFEXPRICEPART   ;      00040003
CREATE ALIAS VDPS.VTCFFIXEDEXCHRATE  FOR VDPS2.VTCFFIXEDEXCHRATE ;      00050003
CREATE ALIAS VDPS.VTCFNUMBERFINAL    FOR VDPS2.VTCFNUMBERFINAL   ;      00060003
CREATE ALIAS VDPS.VTCFNUMBERRANGE    FOR VDPS2.VTCFNUMBERRANGE   ;      00070003
CREATE ALIAS VDPS.VTCASHFLOWREINLIST FOR VDPS2.VTCASHFLOWREINLIST;      00080003
CREATE ALIAS VDPS.VTCASHFLOWREINVEST FOR VDPS2.VTCASHFLOWREINVEST;      00090003
CREATE ALIAS VDPS.VTCFREPAYMENT      FOR VDPS2.VTCFREPAYMENT     ;      00100003
CREATE ALIAS VDPS.VTCFCOMPONENTPROP  FOR VDPS2.VTCFCOMPONENTPROP ;      00110003
CREATE ALIAS VDPS.VTCASHFLOWTAXAMT   FOR VDPS2.VTCASHFLOWTAXAMT  ;      00120003
CREATE ALIAS VDPS.VTCASHFLSUBPERIOD  FOR VDPS2.VTCASHFLSUBPERIOD ;      00130003
CREATE ALIAS VDPS.VTCFEVENTEXDATE    FOR VDPS2.VTCFEVENTEXDATE   ;      00140003
CREATE ALIAS VDPS.VTCFEVNTEXDTLIQAMT FOR VDPS2.VTCFEVNTEXDTLIQAMT;      00150003
CREATE ALIAS VDPS.VTCSEVENTDETAIL    FOR VDPS2.VTCSEVENTDETAIL   ;      00160003
CREATE ALIAS VDPS.VTELIGIBLINSTRPROP FOR VDPS2.VTELIGIBLINSTRPROP;      00170003
CREATE ALIAS VDPS.VTEVENTRESTRICTION FOR VDPS2.VTEVENTRESTRICTION;      00180003
CREATE ALIAS VDPS.VTINSTRUMENTEVENT  FOR VDPS2.VTINSTRUMENTEVENT ;      00190003
CREATE ALIAS VDPS.VTTAXRATETAXAMOUNT FOR VDPS2.VTTAXRATETAXAMOUNT;      00200003
CREATE ALIAS VDPS.VTTOFF             FOR VDPS2.VTTOFF            ;      00210003
CREATE ALIAS VDPS.VTUNDERFIXING      FOR VDPS2.VTUNDERFIXING     ;      00220003
CREATE ALIAS VDPS.VTUNDERFXCOMPONENT FOR VDPS2.VTUNDERFXCOMPONENT;      00230003
CREATE ALIAS VDPS.VTCFVARINTRTFIXING FOR VDPS2.VTCFVARINTRTFIXING;      00240003
CREATE ALIAS VDPS.VTHYBRIINSTRDETAIL FOR VDPS2.VTHYBRIINSTRDETAIL;      00250003
CREATE ALIAS VDPS.VTPAIRINSTRUMENT   FOR VDPS2.VTPAIRINSTRUMENT  ;      00260003
CREATE ALIAS VDPS.VTUNDERFIXINGREF   FOR VDPS2.VTUNDERFIXINGREF  ;      00270003
CREATE ALIAS VDPS.VTUNDERFIXREFCOMP  FOR VDPS2.VTUNDERFIXREFCOMP ;      00280003
CREATE ALIAS VDPS.VTCFEXERCISE       FOR VDPS2.VTCFEXERCISE      ;      00290003
CREATE ALIAS VDPS.VTCFEVENT          FOR VDPS2.VTCFEVENT         ;      00300003
CREATE ALIAS VDPS.VTCASHFLOWAMOUNT   FOR VDPS2.VTCASHFLOWAMOUNT  ;      00310003
-- ATE ALIAS VDPS.VTDENOMPROPERTIES  FOR VDPS2.VTDENOMPROPERTIES ;      00320003
-- ATE ALIAS VDPS.VTINSTRADMINCFDATE FOR VDPS2.VTINSTRADMINCFDATE;      00330003
-- ATE ALIAS VDPS.VTINSTRADMINCFFEE  FOR VDPS2.VTINSTRADMINCFFEE ;      00340004
-- ATE ALIAS VDPS.VTINSTRADMINCFPUBL FOR VDPS2.VTINSTRADMINCFPUBL;      00350005
-- ATE ALIAS VDPS.VTINSTRADMINICF    FOR VDPS2.VTINSTRADMINICF   ;      00360006