Unanswered: Unable to retrieve the Xml Document from a XMLcolum using ADO.net
Hi Iam trying to retrieve the xml document stored in a XmL enabled Column of a DB2 8.1 PE. Iam using the ADO.net to retrieve the document.
db2SelectCommand.CommandText = "Select db2xml.Content(order,'c:\order.xml'from sales_tab where invoice_num = '123456' ";
It shows " unrecoginzed escape sequnece".
I can retrieve the document using the regular the statement " Select order from sales_tab where invoice_num = '123456'" but the problem is that the document does not have any XML structure. The ADO.net places the document as whole inside a data set with no structure.
Any insight into this problem would be appreciated!!!