Hi all, can anyone see if this looks ok… compile´s ok but getting no data in REMITTANCE_INFO, think the query might be some wrong…
The XML is:
**000002 < RmtInf >
**000003 < Strd >
**000004 < RfrdDocAmt >
**000005 < AdjstmntAmtAndRsn >
**000006 < Amt Ccy=“SEK” > 84.67 < /Amt >
**000007 < AddtlInf>Total sum of TI with currency SEK < /AddtlInf >
**000008 < /AdjstmntAmtAndRsn >
**000009 < /RfrdDocAmt >
**000010 < /Strd >
**000011 < /RmtInf >
and wanna get data from < AddtlInf > via this:
XMLCAST
(xmlquery(‘/*:RmtInf/Strd/RfrdDocAmt/AdjstmntAmtAndRsn/AddtlInf’
PASSING (REMITTANCE_INFO))
as varchar(150))
Br
PH