on 09-17-2014 5:08 PM
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.
Hi Rameau,
The error message could be somehow misleading. Try load without "Format Binary".
Loading large objects has a couple of specifications to consinder.
I can read this from IQ manuals :
"You can load large object data of unlimited size, unless restricted
by the operating system, from a primary file in ASCII or BCP format.
The maximum length of fixed-width data loaded from a primary file
into large object columns is 32K - 1."
"Sybase IQ does not support loading large object columns from primary files using LOAD TABLE…FORMAT BINARY.
You can load large object data in binary format from secondary files."
Hope this helps.
Regards,
Tayeb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In order to load binary data, you have to follow a two step process. The first file contains a pointer to the actual file to be loaded. The second set of files are those referenced in the first file.
You cannot do as you are trying which is to load a TIF directly into a cell.
Mark
No problem. The error message is confisung as well!
For information, an Engineering change request CR#606692 is logged to give a clear error message in next releases.
Btw, disucssions in SCN are interactive source to share concerns and knowledge. So, Welcome !
Mark, thanks for the clarfications. I appreciate!
Regards,
Tayeb.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.