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.
Error reading XML files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 74
- Joined: Sat Jul 08, 2006 4:09 am
- Location: Melbourne, Australia
- Contact:
Error reading XML files
Durga Prasad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 74
- Joined: Sat Jul 08, 2006 4:09 am
- Location: Melbourne, Australia
- Contact:
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.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 ...
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
Hi Durgaps,
Can you please edit this in codes...It is little difficult to read it directly..
ex:
Can you please edit this in codes...It is little difficult to read it directly..
ex:
Code: Select all
Error reading XML files
-
- Participant
- Posts: 74
- Joined: Sat Jul 08, 2006 4:09 am
- Location: Melbourne, Australia
- Contact:
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
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...
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
"You can never have too many knives" -- Logan Nine Fingers