I exported all columns in a table to an ixf file.
One of the columns is a blob which contains XML.
The values one on of the tags in the xml in empty and I need to update it.
If I just edited the ixf file and then try the import I get an error with SQL3089N A non-D record was found where a D record was expected.
How do I best go about exporting the data and then importing the data with updated values for the UserName tag?
if data needs to be modified - do not use ixf = internal format
convert xml-blob to character data
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be