Re: SQL Error -10098 in 4GL/Loading into blob fields.

>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>