Select only floating rate deposits in a prefilter (processingscript)
Hi all,
Version Murex : 2.11.35c4 (on a Solaris 10, Sybase 12.5.4)
I’m having a proc script which just runs fine, it runs a P&L report on Loan/Deposits and other products.
However I’m not interested in all Loan/Deposits but only the floating rate loan/deposits (in TRN_HDR : M_BRW_FV1 = ‘V’).
For the moment I’m using a postfilter to get rid of the fixed loan/deposits and only keep the floating ones.
However the ratio between floating/fixed is about 1/100, so I want to use a prefilter to speed up the performance and not do
any calculations on fixed rate deposits.
However if I define a prefilter I either loose the P&L adjustements or the proc script craches if I use the RQWHERE statement RQWHERE(“TRN_HDR_DBF.M_BRW_FV1 = ‘V’”,”") in the prefilter.
Any idea how I can only select the floating rate deposits in a prefilter without loosing the P&L adjustments ?
All help is more then welcome
The best place to ask is our mailing list at murex-l@listserv.linke.de
The best place to ask is our mailing list at murex-l@listserv.linke.de