Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2005
    Posts
    7

    Smile Unanswered: Exported field truncated

    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

  2. #2
    Join Date
    Aug 2003
    Location
    austin,tx
    Posts
    104
    You're running an explicit substr function on the remark field. What is the datatype for the fields? Are the CLOBS?

  3. #3
    Join Date
    Dec 2005
    Posts
    7

    Smile

    Quote Originally Posted by craigmc
    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

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Dec 2005
    Posts
    7

    Smile Exported Fields Truncated

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •