Error reading XML files

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
durgaps
Participant
Posts: 74
Joined: Sat Jul 08, 2006 4:09 am
Location: Melbourne, Australia
Contact:
Contact durgaps

Error reading XML files

Post by durgaps »

Hi,

I am reading an XML file of 32KB thru a SEQUENTIAL FILE stage into a single column of length 500000. The TAGs are proper.
But I am encountering the following Import error. Can anybody please help me out in this. Thanks in advance.


WebSphere_MQ_8,0: Warning: WebSphere_MQ_8: Could not retrieve valid value for long property type 'CCSIDSET'. Using default of 0.
Settlement_File_XML,0: Consumed more than 100000 bytes looking for record delimiter; aborting
Settlement_File_XML,0: Import error at record 0.
Durga Prasad
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Read the messages carefully. There is a limit of 100000 bytes currently in force. To read more than that you will need to change something. Can you post the record schema associated with the Sequential File stage's output link?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
durgaps
Participant
Posts: 74
Joined: Sat Jul 08, 2006 4:09 am
Location: Melbourne, Australia
Contact:
Contact durgaps

Post by durgaps »

ray.wurlod wrote:Read the messages carefully. There is a limit of 100000 bytes currently in force. To read more than that you will need to change something. Can you post the record schema associated with the Sequen ...
I am using SQLType:LongVarChar & Length:500000 to read the XML file in the input column. I checked the byte size for this file. Its around 30000 bytes. I have copied the XML msg below. Does it require any manual re-formatting or is it possible to have a work-around solution in the FORMAT Tab of the SequentialFile Stage.

Input XML Message:
<?xml version="1.0"?>
<Msg>
<ApplHeader>
<ApplRef>4605779667529356871</ApplRef>
<ApplParentRef/>
<ApplOriginalRef>4605779667529356871</ApplOriginalRef>
<ApplMsgType>HPSettUld</ApplMsgType>
<ApplTimestamp>20060728103020</ApplTimestamp>
<ApplOrgId>NAG-GSS</ApplOrgId>
<ApplBranchId>AUMEL</ApplBranchId>
<ApplId>EQUFEX</ApplId>
<Channel>XML</Channel>
</ApplHeader>
<MsgText>
<HPSettUld>
<JobMetaData>
<METLJobId>HPTXNULDXML</METLJobId>
<InitiatingSystem>EQUFEX</InitiatingSystem>
<UserId/>
<InitiationDateTime>2006-07-28T00:30:20.927Z</InitiationDateTime>
<TargetSystem>UPDATE</TargetSystem>
</JobMetaData>
<RunTimeParameters>
<HPInputFileName>00010126</HPInputFileName>
<HPInputFileExt>EQX</HPInputFileExt>
<HPOutputPath/>
<HPUserName><loginId></HPUserName>
<HPCCUserNumber><userNum></HPCCUserNumber>
<HPCCJobName>00010126</HPCCJobName>
<HPCCSlave/>
</RunTimeParameters>
<TransactionData>
<PortfolioInformation>
<Fund>AA</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0542934</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>37537.60</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>26834.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>37537.60</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>AT</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">BARE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0141053</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>8278.45</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>1195.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>8278.45</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>AT</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0141058</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>5988.77</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>4281.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>5988.77</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>AT</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">MRKN/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0141059</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>5232.97</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>920.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>5232.97</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>CB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0297681</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>32203.52</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>23021.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>32203.52</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>CQ</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0038213</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>12494.15</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>8932.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>12494.15</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>ES</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0145845</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>16336.98</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>11679.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>16336.98</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>ES</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0145850</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>40132.59</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>28689.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>40132.59</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>GB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">BAER/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">MRGUSA</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0219847</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>73135.81</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>17080.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>73135.81</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>GB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0219851</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>113654.20</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>81245.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>113654.20</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>IG</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0081342</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>9346.18</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>6681.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>9346.18</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>IG</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0081347</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>4808.08</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>3437.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>4808.08</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>IG</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0081352</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>11693.97</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>8360.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>11693.97</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>LF</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0077878</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>13327.91</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>9528.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>13327.91</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>Q4</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">VCT/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0405283</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>13442.16</TradeSettleAmt>
<SettContract>FE1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>1900.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>13442.16</ActSettleAmt>
<ActSettleAcct>QGBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>TA</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0346532</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>31529.24</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>22539.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>31529.24</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>TS</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">MABA/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">MERRIM</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0579350</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>7861.01</TradeSettleAmt>
<SettContract>FB1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>1600.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>7861.01</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>UB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">BARE/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0051067</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>125058.28</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>17992.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>125058.28</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>UB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">BPA/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0051069</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>279177.95</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>40368.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>279177.95</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>UB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">DIA/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0051070</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>50274.94</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>5571.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>50274.94</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>UB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">GLH/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0051074</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>99602.74</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>12135.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>99602.74</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>UB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">GUP/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0051075</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>30292.52</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>2865.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>30292.52</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>UB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">PRI/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0051078</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>64045.06</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>9606.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>64045.06</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>UB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">ROY/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0051080</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>119130.41</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>6489.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>119130.41</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
<TransactionData>
<PortfolioInformation>
<Fund>UB</Fund>
<PfolioCode FormatPfolioCode="M2K"></PfolioCode>
</PortfolioInformation>
<SecurityInformation>
<SecurityCode FormatSecurityCode="M2K">VOD/GBP</SecurityCode>
</SecurityInformation>
<BrokerInformation>
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode>
</BrokerInformation>
<TransactionDetails>
<TradeDate>20060410000000</TradeDate>
<TradeType>04</TradeType>
<HPTradeId>0051088</HPTradeId>
<TradeSettleDate>20060413000000</TradeSettleDate>
<TradeSettleAmt>209740.14</TradeSettleAmt>
<SettContract>FA1APR11</SettContract>
<SettleUnsettle>S</SettleUnsettle>
</TransactionDetails>
<CurrencyInformation>
<TradeCurrency>GBP</TradeCurrency>
</CurrencyInformation>
<SettlementValues>
<ActSettleUnit>164925.0000</ActSettleUnit>
<ActSettleDate>20060413000000</ActSettleDate>
<ActSettleAmt>209740.14</ActSettleAmt>
<ActSettleAcct>GBPCASH</ActSettleAcct>
</SettlementValues>
</TransactionData>
</HPSettUld>
</MsgText>
</Msg>
Durga Prasad
Top
meena
Participant
Posts: 430
Joined: Tue Sep 13, 2005 12:17 pm

Post by meena »

Hi Durgaps,
Can you please edit this in codes...It is little difficult to read it directly..

ex:

Code: Select all

Error reading XML files
Top
durgaps
Participant
Posts: 74
Joined: Sat Jul 08, 2006 4:09 am
Location: Melbourne, Australia
Contact:
Contact durgaps

Post by durgaps »

Here you go!!!

Code: Select all

<?xml version="1.0"?> 
<Msg> 
<ApplHeader> 
<ApplRef>4605779667529356871</ApplRef> 
<ApplParentRef/> 
<ApplOriginalRef>4605779667529356871</ApplOriginalRef> 
<ApplMsgType>HPSettUld</ApplMsgType> 
<ApplTimestamp>20060728103020</ApplTimestamp> 
<ApplOrgId>NAG-GSS</ApplOrgId> 
<ApplBranchId>AUMEL</ApplBranchId> 
<ApplId>EQUFEX</ApplId> 
<Channel>XML</Channel> 
</ApplHeader> 
<MsgText> 
<HPSettUld> 
<JobMetaData> 
<METLJobId>HPTXNULDXML</METLJobId> 
<InitiatingSystem>EQUFEX</InitiatingSystem> 
<UserId/> 
<InitiationDateTime>2006-07-28T00:30:20.927Z</InitiationDateTime> 
<TargetSystem>UPDATE</TargetSystem> 
</JobMetaData> 
<RunTimeParameters> 
<HPInputFileName>00010126</HPInputFileName> 
<HPInputFileExt>EQX</HPInputFileExt> 
<HPOutputPath/> 
<HPUserName><loginId></HPUserName> 
<HPCCUserNumber><userNum></HPCCUserNumber> 
<HPCCJobName>00010126</HPCCJobName> 
<HPCCSlave/> 
</RunTimeParameters> 
<TransactionData> 
<PortfolioInformation> 
<Fund>AA</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0542934</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>37537.60</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>26834.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>37537.60</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>AT</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">BARE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0141053</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>8278.45</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>1195.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>8278.45</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>AT</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0141058</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>5988.77</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>4281.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>5988.77</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>AT</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">MRKN/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0141059</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>5232.97</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>920.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>5232.97</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>CB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0297681</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>32203.52</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>23021.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>32203.52</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>CQ</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0038213</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>12494.15</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>8932.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>12494.15</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>ES</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0145845</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>16336.98</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>11679.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>16336.98</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>ES</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0145850</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>40132.59</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>28689.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>40132.59</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>GB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">BAER/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">MRGUSA</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0219847</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>73135.81</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>17080.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>73135.81</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>GB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0219851</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>113654.20</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>81245.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>113654.20</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>IG</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0081342</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>9346.18</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>6681.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>9346.18</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>IG</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0081347</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>4808.08</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>3437.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>4808.08</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>IG</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0081352</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>11693.97</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>8360.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>11693.97</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>LF</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0077878</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>13327.91</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>9528.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>13327.91</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>Q4</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">VCT/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0405283</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>13442.16</TradeSettleAmt> 
<SettContract>FE1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>1900.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>13442.16</ActSettleAmt> 
<ActSettleAcct>QGBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>TA</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">LGE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">UBSWGB</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0346532</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>31529.24</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>22539.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>31529.24</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>TS</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">MABA/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">MERRIM</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0579350</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>7861.01</TradeSettleAmt> 
<SettContract>FB1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>1600.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>7861.01</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>UB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">BARE/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0051067</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>125058.28</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>17992.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>125058.28</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>UB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">BPA/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0051069</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>279177.95</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>40368.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>279177.95</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>UB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">DIA/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0051070</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>50274.94</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>5571.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>50274.94</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>UB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">GLH/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0051074</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>99602.74</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>12135.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>99602.74</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>UB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">GUP/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0051075</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>30292.52</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>2865.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>30292.52</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>UB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">PRI/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0051078</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>64045.06</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>9606.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>64045.06</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>UB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">ROY/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0051080</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>119130.41</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>6489.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>119130.41</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
<TransactionData> 
<PortfolioInformation> 
<Fund>UB</Fund> 
<PfolioCode FormatPfolioCode="M2K"></PfolioCode> 
</PortfolioInformation> 
<SecurityInformation> 
<SecurityCode FormatSecurityCode="M2K">VOD/GBP</SecurityCode> 
</SecurityInformation> 
<BrokerInformation> 
<BrokerCode FormatBrokerCode="M2K">KLEINL</BrokerCode> 
</BrokerInformation> 
<TransactionDetails> 
<TradeDate>20060410000000</TradeDate> 
<TradeType>04</TradeType> 
<HPTradeId>0051088</HPTradeId> 
<TradeSettleDate>20060413000000</TradeSettleDate> 
<TradeSettleAmt>209740.14</TradeSettleAmt> 
<SettContract>FA1APR11</SettContract> 
<SettleUnsettle>S</SettleUnsettle> 
</TransactionDetails> 
<CurrencyInformation> 
<TradeCurrency>GBP</TradeCurrency> 
</CurrencyInformation> 
<SettlementValues> 
<ActSettleUnit>164925.0000</ActSettleUnit> 
<ActSettleDate>20060413000000</ActSettleDate> 
<ActSettleAmt>209740.14</ActSettleAmt> 
<ActSettleAcct>GBPCASH</ActSettleAcct> 
</SettlementValues> 
</TransactionData> 
</HPSettUld> 
</MsgText> 
</Msg>
Durga Prasad
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:lol: Yah, that helped alot. And meena meant edit your first post (which you can do) not post it again. If someone wants to see something more 'formatted' you'll need to paste it into a tool like XMLSpy and make it 'Pretty'.

Silly question, but why not use a Server job and the 'normal' combination of Folder and XML Input stages? Even if it's just for the initial parsing...
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”