Skip to Content
0
Former Member
Sep 17, 2014 at 04:08 PM

ASIQ load problem, help needed

37 Views

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.