I need to create a XML file from a Focus on table hold file using a custom XML schema (.xsd file). We do not have a license for the XML adaper, or the Data Migration tool. I can create a focus file with a table file of 'ON TABLE FILE HOLD ?? FROMAT XML', but I need the data formatted for this custom schema.
Other then hard coding the tags etc.. in the report file, what other options exist. We have just upgraded to WF V7.6.1

Jan

try this

ON TABLE PCHOLD FORMAT XML

And see this discussion here.

And special the point from Tony and Alan B.

You can also search on the forum by the "find" button.

Jan,
I think that the only solution to this is to create your own.
The XML format that webfocus produces is really only suitable for use with webfocus itself. After all, anyone can define their own xml. Yes, there are some standards (or attempts), but the webfocus xml output does not comply with these.
Creating your own xml-output is not really that hard to do. It took me max 4 hours to do, depending on the desired xml-structure.

You may want to consider liscensing DataMigrator. It lets you automatically create a sysnonym for an xsd file and then map to it as a target in a data flow.