Focal Point
[CLOSED] insert xml HOLD file into cell in table

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7387033296

January 13, 2020, 12:06 PM
Troy_proffitt
[CLOSED] insert xml HOLD file into cell in table
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,


WF version 8105
all output
January 13, 2020, 01:41 PM
Waz
It shouldn't be that difficult.

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

Also what "style" of xml ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

January 13, 2020, 01:49 PM
Troy_proffitt
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.


WF version 8105
all output
January 13, 2020, 02:18 PM
Waz
If you are building the SQL to do the update, then I don't see an issue.

Can I ask why you need xml ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

January 13, 2020, 02:21 PM
Troy_proffitt
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


WF version 8105
all output
January 13, 2020, 02:55 PM
Waz
I think CSV will be a much smaller and more manageable format.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

January 14, 2020, 09:57 PM
David Briars
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