DATA Step, Macro, Functions and more

Reading XML from a table

Reply
New Contributor
Posts: 2

Reading XML from a table

Hi, 

 

I have a table with XML data stored in an column of an MySQL table. I would like to read and parse the data into individual tables. 

 

All the example that I have found read the data from a xml file. I have the map file ready to parse the data. 

 

How do I import such stored data? 

 

-NG

Super User
Super User
Posts: 7,392

Re: Reading XML from a table

Well, the simplest way, without looking at documentation to see if direct code is possible, is to just read the database as string, and write it out to a temporary file.  Then import it in using normal methods and your map file.  I know its writing out and reading in but its only a few lines of code.  

New Contributor
Posts: 2

Re: Reading XML from a table

With all the reading and writing, this will soon become a time consuming process. I would rather have a way to directly read the data and then parse it using a map. 

 

This might be the hail mary option.

Occasional Contributor
Posts: 5

Re: Reading XML from a table

Please go thru from the given belo link pdf. you will get the idea.

 

http://scsug.org/SCSUGProceedings/2008/papers/app/Mayumi_Takada.pdf

 

Thanks,

Abhi

Ask a Question
Discussion stats
  • 3 replies
  • 109 views
  • 0 likes
  • 3 in conversation