Re: Thoughts/experiences with JSON/XML on DB2

[Booth Martin <booth@xxxxxxxxxxxx>]

Is the history file still having records added, or is it a historical file?

In any event why not a one-shot, and move the data to a properly 
designed normalized data base and then deal with it as you wish?  Thats 
got to be a lot easier than what you are looking at.  Even if the file 
is still having records added, you could insert a trigger that moved the 
data to a modern database?

On 3/31/2016 7:18 PM, Justin Taylor wrote:
> Has anyone worked with the JSON/XML support in DB2?  I'm thinking about using it in a project and am looking for insights.
>
>
> In a nutshell:
> My order history data is in a multi-format S/36 file (not sure the exact terminology).  The format makes SQL incredibly difficult, and I'm looking for a way to make ad-hoc queries easier.  I tried extracting it into DB2 tables.  I ended up with five tables before I started looking for other options.  From what I've read, I can extract each order into a JSON or XML document, store it in DB2 table, and then run queries over the DB2 table.
>
> Thanks