Re: Loading BYTE data types from DBACCESS?

Fred Prose wrote: > I need to populate a table that will contain BYTE data types > (employee information and badge pictures). The character data > is in delimited files and the pictures are JPG images and both > are available on my server. Is there a way to accomplish this > through DBACCESS. I don't have access to ESQL or 4GL. Sort of, but not directly. The only way of getting DB-Access to enter BYTE data is via the load statement, and the BYTE data for a LOAD statement must be a continuous stream of hex digits representing the bytes of the data. Consequently, you need to merge the JPG images into your other data. Or you should get ClientSDK for your machine and use an ESQL/C program. There's a simple one called updblob in the IIUG archives (http://www.iiug.org) which would allow you to load the non-BYTE data into the table, leaving the BYTE portions null, and then load direct from the files. You'd need to do some work on it to make it into a production program; a single run can only update a single row. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>