Hi

DB2 8.2.6 on windows 2000

We have an archives of large hsitory table with blobs. The archive is an export in ixf format of the table. There is a requirement to select specific rows for import. Is there a way to do this?

Thanks

There is no direct way using DB2 tools or commands. What I would suggest is that you create a dummy table just like the one you want to import into. Use DB2 LOAD to put all the data into it. Then use SQL INSERT to copy just the rows you want.

HTH

Andy

Another idea to avoid the copying is to create a view over the table, put an INSTEAD OF INSERT trigger on that view and then import into the view. The trigger can filter out the rows that you don't want to have.