RowColumn to XML Transformation

, ,
1

Hello,

I am new to webMethods and could someone tell me how to tranform row/column to XML (flow steps that are needed).

To my knowledge, we use Select SQL to get the data from the database using appropriate adapter and take the strings in the input of the Select SQL doc and map to transform to XML. But wasnt sure what steps would be required to convert to XML.

Plz provide me with a solution.

Thx

2

Pete,
Once you retrieve the data from DB using AdapterService (select)then loop thru the Results/Fields and one to one map the data to the ISDocumentType(XML structure)and once it is done then use XMLDocumentToXMLString give xmldata string and further down you can follow upon the requirement.

HTH,
RMG