Friday, November 19, 2010

Read XML in Temenos T24 Infobasic

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:

Burak Altın on January 19, 2012 at 12:16 PM said...

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

Sarfraz Ahmed Farooq on March 7, 2012 at 2:23 AM said...

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

 

Blog Info

A Pakistani Website by Originative Systems

Total Pageviews

Tutorial Jinni Copyright © 2015 WoodMag is Modified by Originative Systems