Loading large XML files into db2
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am trying to load a large XML file into pureXML field in db2 9.5. The XML is too large to fit inside the INSERT statement so I have to use the load or the import tools in db2. However it doesn't work The statement that executes the load is CONNECT TO Databasename LOAD FROM "C:\XMLData\XML1.xml" OF DEL METHOD P (1) MESSAGES "C:\XMLData\log.txt" INSERT INTO XMLTABLE (XMLCOL) COPY NO INDEXING MODE AUTOSELECT; CONNECT RESET It seems that is successfully executed and I get no errors, however when I open the table empty. No rows at all. The table has only one column the XMLCOL without any indexing. Please assist