Hi Guys,

I need to test the table being exported if it has LOBs.

eg.

db2 export to DBFinder.STAFF.del of del select * from DBFinder.STAFF

db2 export to DBFinder.IN_TRAY.del of del select * from DBFinder.IN_TRAY

The second statement fails because it contains LOBs.

So I need to know beforehand any table being exported does not contail LOBs.
and -- suggest me the statemennt to export LOBs table.

DB2 version 9.5


Thanks
DBFinder

Have a look at the manual. It describes the LOBSINFILE option, which you have to use to tell the export command how to handle lobs.

That's for later on.

The concern is to find out if table contains any LOBs.

You could simply specify the LOB options - or you query SYSCAT.COLUMNS to figure out whether LOBs exist or not.

Export Lobs on every table, even on tables w/o lobs. Tables with no LOBS will not generate a LOBS file.

Thanks Guys,
I used syscat.columns to know about lobs.
BTW I used HarbingL's advice to write statements.

Thanks
DBFinder