Buddy, Thank you for your proposed solution. It is most probably the best solution.
Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: maandag 19 oktober 2015 14:43 To: [email protected] Subject: [RBASE-L] - RE: How to Load a more complex XML file Tony I would load the XML file into a temporary table with one column only. Then using the DECLARE CURSOR loop the table. Since XML is unforgiving there should be a starting and ending tag. I would assume that the first starting tag would be the table <TABLE> then the row, column you would have to keep track of starting and ending tag If the next fetch row a </COLUMN> then you know that row has ended. If it is </ROW> Keep backing out until you get to the </TABLE> Inside you while loop you will either being doing INSERT or UPDATE. If it is the 1st column, 1st row then insert otherwise you would be doing an update. Depending on how the XML file is set up you may have ITEM tags to show column. I'm assuming your XML file would be set up something like this <TABLE> Tablename <ROW> <COLUMN> Something to insert </COLUMN> <COLUMN> Something to update WHERE COUNT = INSERT </COLUMN> </ROW> </TABLE> <TABLE> Nexttable name <ROW> <COLUMN> Something else to INSERT </COLUMN> <COLUMN> Something else to update WHERE COUNT = INSERT </COLUMN> </ROW> </TABLE> Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema Sent: Monday, October 19, 2015 2:58 AM To: [email protected] Subject: [RBASE-L] - How to Load a more complex XML file I have to develop an input program which is able to load a rather complex XML file. The XML file contains up to 10 tables, each with about 10 to 30 columns. I am interested in tips how to load such a file into the database. Tony
