Hi there,

I issued the following SQL to export data:

echo EXPORT TO D:\eCRM_Black_List_Download\bkblist.del OF DEL MESSAGES D:\eCRM_Black_List_Download\bkblist.log select black_key, input_date, source_code, internal_code, black_list_name, other_number, passport, address, effective_date, expired_date, substr(remark,8), access_control from fos.black_list; >> batch.clp

But the address and remark columns were truncated. If import it to excel with macro process, it will not extract all records.

Please help anyway not to truncate the exported file.
Thank you very much.

Regards,
Joshua

You're running an explicit substr function on the remark field. What is the datatype for the fields? Are the CLOBS?

Hi,
The address field is VARCHAR 250 and for remark field is BLOB.
Thank you.

Regards,
Joshua

I'm surprised VARCHAR(250) is truncated ... Did you check the exported file in notepad ?? Is is truncated ?

Remember BLOB works on bytes ... So, if you are using DBCS only first 4 characters will be returned by SUBSTR(blobcol,8)

Cheers
Sathyaram

Hi sathyaram_s,

I did view through notepad and realised it was truncated.
I suspected if I'm not wrong, there may be some 'carriage return' which caused the trucation.
anyway we can filter off this truncation during exporting??

Please help. Thank you so much.

Regards,
Joshua