Hi All,
i have a requirement to generate the data file in XML, where i can able to generate the xml file by using single SQL query.
issue : since i am using single sql query the header tags are getting repeated for every line tag which should not be the case.
Can any one help me please it is very urgent requirement .
thanks in advance.
please find the sample
data file which is given by client.
<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03 file:///H:/XML/pain.001.001.03.xsd">
<CstmrCdtTrfInitn>
<GrpHdr>
<MsgId>AP_CHE1210250650</MsgId>
<CreDtTm>2012-10-25T11:45:37</CreDtTm>
<NbOfTxs>1</NbOfTxs>
<CtrlSum>11187.82</CtrlSum>
<InitgPty>
<Nm>ABC Company</Nm>
<PstlAdr>
<PstCd>77042</PstCd>
<TwnNm>Houston</TwnNm>
<CtrySubDvsn>TX</CtrySubDvsn>
<Ctry>US</Ctry>
<AdrLine>2101 CityWest Blvd</AdrLine>
</PstlAdr>
<Id>
<OrgId>
<Othr>
<Id>BOFAECSUSO</Id>
<SchmeNm>
<Cd>BANK</Cd>
</SchmeNm>
</Othr>
<Othr>
<Id>SENDERID</Id>
<SchmeNm>
<Cd>CUST</Cd>
</SchmeNm>
</Othr>
</OrgId>
</Id>
</InitgPty>
</GrpHdr>
<PmtInf>
<PmtInfId>AP_CHECK_BOFA_201210250650</PmtInfId>
<PmtMtd>CHK</PmtMtd>
<PmtTpInf>
<LclInstrm>
<Prtry>CII</Prtry>
</LclInstrm>
</PmtTpInf>
<ReqdExctnDt>2012-10-25</ReqdExctnDt>
<Dbtr>
<Nm>ABC Company</Nm>
<PstlAdr>
<PstCd>77042</PstCd>
<TwnNm>Houston</TwnNm>
<CtrySubDvsn>TX</CtrySubDvsn>
<Ctry>US</Ctry>
<AdrLine>2101 CityWest Blvd</AdrLine>
<AdrLine> </AdrLine>
</PstlAdr>
</Dbtr>
<DbtrAcct>
<Id>
<Othr>
<Id>9999999999</Id>
</Othr>
</Id>
<Tp>
<Cd>CACC</Cd>
</Tp>
<Ccy>USD</Ccy>
<Nm>ABC Company</Nm>
</DbtrAcct>
<DbtrAgt>
<FinInstnId>
<ClrSysMmbId>
<MmbId>acc number</MmbId>
</ClrSysMmbId>
<Nm>BANK NAME</Nm>
<PstlAdr>
<Ctry>US</Ctry>
</PstlAdr>
</FinInstnId>
</DbtrAgt>
<CdtTrfTxInf>
<PmtId>
<EndToEndId>367049</EndToEndId>
</PmtId>
<Amt>
<InstdAmt Ccy="USD">11187.82</InstdAmt>
</Amt>
<ChqInstr>
<ChqTp>CCHQ</ChqTp>
<ChqNb>0000023748</ChqNb>
</ChqInstr>
<Cdtr>
<Nm>BENEFICIARY</Nm>
<PstlAdr>
<PstCd>92620-2626</PstCd>
<TwnNm>IRVINE</TwnNm>
<CtrySubDvsn>CA</CtrySubDvsn>
<Ctry>US</Ctry>
<AdrLine>48 MINERS TRAIL</AdrLine>
<AdrLine> </AdrLine>
</PstlAdr>
</Cdtr>
</CdtTrfTxInf>
</PmtInf>
</CstmrCdtTrfInitn>
</Document>