Question importing data from xml file

Abbashatim

New Member
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
 

Attachments

  • import-tran.p
    2.4 KB · Views: 8
  • 21-03-25-import.txt
    245.5 KB · Views: 6
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

New Member
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
 

Attachments

  • original.txt
    14.6 KB · Views: 2
  • amended.txt
    13.5 KB · Views: 2
Top