Question importing data from xml file

[Abbashatim]

I am trying to import data from xml file. I have problems import the data to temp table. Can anyone please provide a sample xml files and the related temp table that can be loaded. Attached is my code and the xml file.
Thanks in advance

 

[Jean-Christophe Cardot]

The xml you are trying to import is not valid xml. There is more than one root node.
oh and hello by the way.

 

[Jean-Christophe Cardot]

You should:
1. add a root node to your xml, let's say add <xmlReport> at the beginning and </xmlReport> at the end
2. READ-XML the temp-table, it will work.

In order to produce the same xml, you could:
1. define a dataset, with a SERIALIZE-NAME "xmlReport", including your temp-table.
2. WRITE-XML the dataset, not the temp-table.

 

[Abbashatim]

Thanks for the reply.
will try and let you know.

 

[Abbashatim]

Dear Jean
Yes it works.. Thanks for the help.

 

[Abbashatim]

dear Jean
I get the xml file (original.txt). I then amend it (amended.txt) then i use import-tran.p to import data.
can you please guide me how to write the procedure to directly import from the original.xml. My main interest is in table G_TRX_CHAR_DATE

your help will be appreciated.

thanks
abbas