Temenos T24 infobasic provide a very convenient method of reading a XML file using the READXML infobasic function, it simple as
Writing XML.
Command Syntax
READXML rec FROM file, id
ELSE STOP 202,id
above command read a record from a file using the style sheet held in DICT->@READXML to transform the data into xml format. To illustrate this further we will show an example how data will look like when it is not in XML format and when in XML.
Example
READ rec FROM file,id THEN
CRT rec
END
READXML xml FROM file,id THEN
CRT xml
END
Output
CLIVE^PIPENSLIPPERS^999 LETSBE AVENUE
Plain output, output of first command
<?xml version="1.0" encoding="UTF-8"?>
CLIVE
PIPENSLIPPERS
999 LETSBE AVENUE
XML formatted output, output of second command.
2 comments:
Hi,
I use READXML command but everytime I can't solve below error.
** Error [ XML_ERROR ] **
XML conversion failed, error number -1 on file ../bnk.data/st/FBNK.CUST000
Line 20 , Source TB.BURAK.DENEME
Trap from an error message, error message name = XML_ERROR
Source changed to /opt/globus9/TBASTP3/bnk/bnk.run/TBSRC.BP/TB.BURAK.DENEME
0020 READXML xml FROM F.CUSTOMER,CUS.ID THEN
Hi,
from my point of view you are getting this error because the in F.CUSTOMER is not in XML form at Jbase level. If you are using Oracle,DB2, or MSSQL, then jedi driver convert the xml format to jbase format but you can give try to make an XML file and read that file.xml and use readxml statement.
Hope that will resolve the problem.
Post a Comment