How to Insert an XML document in DB2??

[inziam]

I cant able to insert an XML document in a table of XML datatype in DB2.........


wen i try for this in control center it displays XML document is empty and

when I try for in command editor it displays an error "An unexpected token "END-OF-STATEMENT" was found following.. Expected tokens may include: "<insert_spec>" .
SQLSTATE=42601 "

Pls help me .........I have tried a lot but not getting how to store XML document in DB2..........
Kindly inofrm if u came o know.......pls. .......

[sakumar9]

I cant able to insert an XML document in a table of XML datatype in DB2.........


wen i try for this in control center it displays XML document is empty and

when I try for in command editor it displays an error "An unexpected token "END-OF-STATEMENT" was found following.. Expected tokens may include: "<insert_spec>" .
SQLSTATE=42601 "

Pls help me .........I have tried a lot but not getting how to store XML document in DB2..........
Kindly inofrm if u came o know.......pls. .......

You can refer to the sample SQLLIB/samples/xml/clp/xmlinsert.db2

This sample demonstrates how you can insert XML documents into a table.

Regards
-- Sanjay

[inziam]

You can refer to the sample SQLLIB/samples/xml/clp/xmlinsert.db2

This sample demonstrates how you can insert XML documents into a table.

Regards
-- Sanjay

The site you have given is in different language....... ..
So I am on the same old stage.......... ..
Cant able to insert XML document....... ........on DB2 version 9.1
Plsssss........ ..Help me.........Plss ss.........
When I create an XML column type an tried to insert XML document it displays a message XML document not found.......... .

Pls help me Sir............ ..


Regards Inzia

[cburnett]

Simple example:

create table testxml (id int not null, xmlcol xml)

insert into testxml values (1, '<xml>test data</xml>')