Hi there,

I'm trying to perform the following:

EXPORT TO d:\bkA OF DEL lobs to d:\bkA MESSAGES d:\bkA\bkA.log select * from fos.bkA

However, in the the file bkA, there is this blob column which shows garbages.
How should I go about extract the data for this blob column accurately?
Please advise. Thank you very much.

Joshua,

Look into Command Ref.

It looks like you might be missing at least 2 parms lobfile and modified by lobsinfile

Hi Courgar8000,

If i don't use lobfile :

EXPORT TO d:\bkA OF DEL MESSAGES d:\bkA\bkA.log select * from fos.bkA

Inside table bkA before download is a blob which contained valid data.
But when exported, it contained garbages.
How should I export it correctly?
Please advise. Thank you.

Use db2look. That way it will figure out who to export for you since you don't know how to do it yourself.