I have a need to HOLD some data as XML and then write that data into a single cell in a table via SQL passthru. Anyone have an idea how to do this? Also, I'll need to retrieve this data later in my process and turn it back into a HOLD file. One last thing to note, I need to do this within a fex and not via a WF tool.

Thanks for the help

This message has been edited. Last edited by: FP Mod Chuck,

It shouldn't be that difficult.

How much data is expected? XML pads the data out.

Also what "style" of xml ?

It isn't a lot of data, 3 columns and probably no more than 300 rows. As for the xml "style", it just has to be a format recognized by WebFOCUS to be converted back into a HOLD file.

If you are building the SQL to do the update, then I don't see an issue.

Can I ask why you need xml ?

It doesn't need to be xml. It could be csv or json. I just need to be able to re-transform it back into a HOLD file that can be used

I think CSV will be a much smaller and more manageable format.

quote:

It doesn't need to be xml. It could be csv or json. I just need to be able to re-transform it..

The following post talks about displaying a JSON formatted string within a WebFOCUS report. Not exactly sure what your input or output requirements are, and thought this might assist.
http://forums.informationbuild...1057331/m/9117099786