Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ASIQ load problem, help needed

I have the following table into which an imaghe file will be loaded on daily basis: 

CREATE TABLE Image_tbl

(

  ci_image_ind   char(30) NULL,  

    ci_image              image    NOT NULL,

  ci_load_date   date     NULL

   

)

When I run the following load command, it fails giving the below message:

load table MYUSER.Image_tble

(

ci_image

)

using client file 'd:/xxx/yyy//IMAGE.TIF'

ESCAPES OFF

QUOTES OFF

FORMAT BINARY

Could not execute statement.

   The datatype of column 'BLOB' is not valid.

   -- (db_sqlins.cxx 13703)

   SQLCODE=-1013037, ODBC 3 State="HY000"

   File: "ld_4864" on line 1, column 1

   load table MYUSER.Image_tble

   (

   ci_image

   ...

Have tried to find out teh reason of failure with no success, at least not on the SAP-Sybase documents. Please help me undestand what is wrong in my load statement.

Former Member
Not what you were looking for? View more on this topic or Ask a question