guys pls help me out here i wanna know can i put xml file as a whole into db2 9 and then retrieve data or manipulate or access it via the database ,....
thank u...

Yes, you can. db2 V9 has complete support for xml data type
see developersworks fro many articles/tutorials about xml select/updates...

hey dude i tried the import command but its still does not get the data in my xml file into the database ......

shuld i be using the xml extender

No, you can import it directly, you can read it in the docs.

Kind regards, Gert

dude i want to import the xml file directly .... in that method we have to first export it and then import it.....i want to import the xml file directly in my table.....can only exported data be imported.....

in the delimited input file for the xml column you specify the file name
11,"xxxxx","xml filename"
db2 import from delfile of del modified by lobsinfile insert into...
this will bring in the external file

thank u maan this works .... but this is not at all application friendly.....