>From: JohnSchore@aol.com
>Date: Fri, 1 Nov 1996 23:10:13 -0500
>X-Informix-List-Id: <list.11959>
>
>I got SQL Error -10098 when I used "load from flename insert into tbl" from
>4gl. The file "flename" was a normal text file. Tbl consisted of one column
>of type "BYTE". The error message "Improperly formatted hex value". The
>finderr utility could not find this error message no.
I think the key part of your observation is 'The file "flename" was a
normal text file'.
If you are loading data into a BYTE (as opposed to TEXT) column, you cannot
load an arbitrary text file. You have to load a file which is in the
required format, which means that each byte blob consists of an even number
of hexadecimal digits on a single line with a delimiter (normally '|')
after it. In your case, that's all it would consist of -- if you had other
fields, then the blob would be formatted like that in the middle of the
other fields.
Put another way, you cannot load an arbitrary file into a BYTE field.
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>