HI All,
I am trying to insert an XML content into XML Column datatype in SQL Server table. But I am able to insert only half of the XML.
I am using ODBC Connector stage to insert XML content.
can anyone help me in this please
Thanks
Naren
Inserting XML into SQL Server table XML column
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
Inserting XML into SQL Server table XML column
Thanks
Naren Babu Ch
Naren Babu Ch
Hard to say...could be a Connector issue, or a mid-job truncation issue, or something else. Depends on how/where you are losing the xml content. If you send it to disk instead of to SQL Server (use a sequential stage and use none/none for quote character and delimeter) with a longvarchar column and long length, does it get truncated at the same place?
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What is the data type (especially the size) of the column to which you are attempting to write? And how large is your XML fragment? Finally, do you have double-byte character (Unicode) capability enabled?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.