What are the options to import XML data, which have been generated by a select for xml auto? I managed to use a simple approach using the Load Table statement, but I don't like the restriction, that Load Table will require an exclusive lock on the table. Using openxml I don't like the necessity to provide all column types. Is there a more easy way to insert the data generated with XML auto? |
As we have customers with older SA versions than 12, we didn't use load table with xml data as that is not available before. We always used OpenXML and to my knowledge it's necessary there, to provide the data types for all columns. |
Hi Martin,
i am also waiting for the above answer,if you get anytime answer for the above question please forward to me.
My requirement:-I have one xml data i need to import the data into SQL Anywhere,how to do achive this one,i am new to this sql anywhere,please help me out.
Thnaks, Syam.
A good starting point is http://infocenter.sybase.com/help/topic/com.sybase.help.sqlanywhere.12.0.1/dbreference/load-table-statement.html
If you need more specific help, ask a question in this forum
Hi Martin,
Thanks for quick replay.
i am understanding what you suggested regarding importing data xml to sql anywhere,but here i want know how to achive the sql anywhere servee. if you have any documets can you share it it would be helpful it for me.
FWIW, the official SQL Anywhere documentation for current versions can be found here:
DocCommentXchange