Re: INSERT Binary Data

June C. Hunt wrote: > June C. Hunt wrote: > >> Martin Steinwender wrote: >> >>> Hi, >>> >>> I would like to INSERT Byte-Data INTO a BYTE-Coolumn using SQL >>> >>> This is how it works for SQL-Server: >>> >>> INSERT INTO tblSlime ( ID, Name, Slime ) >>> VALUES (2, 'Fritz', 0x234323432343234323fc4350fc4350fc4350fc4350fc);>>> >>> Is something like this possible for INFORMIX >> > > > Seem to be having problems sending mail this morning. The full response > should be... > > From the IBM Informix Guide to SQL: Reference (Version 9.4, Part No. > CT1SPNA): > > > You can insert data into BYTE columns in the following ways: > - With the dbload or onload utilities > - With the LOAD statement (DB-Access) > - From BYTE host variables (IBM Informix ESQL/C) > > You cannot use a quoted text string, number, or any other actual value > to insert or update BYTE columns. > > > If you don't already have it, you can find Informix documentation online > at http://www.ibm.com/software/data/informix/library Strewth Sheila, can't ya just abbreviate that as RTFM???? You don't half go on... -- Strewth! Stick a sock in it, Sheila!

My Name Is Bruce and I'm A Sock Puppet wrote: > June C. Hunt wrote: > > >>June C. Hunt wrote: >> >> >>>Martin Steinwender wrote: >>> >>> >>>>Hi, >>>> >>>>I would like to INSERT Byte-Data INTO a BYTE-Coolumn using SQL >>>> >>>>This is how it works for SQL-Server: >>>> >>>>INSERT INTO tblSlime ( ID, Name, Slime ) >>>>VALUES (2, 'Fritz', 0x234323432343234323fc4350fc4350fc4350fc4350fc);>>>> >>>>Is something like this possible for INFORMIX >>> >> >>Seem to be having problems sending mail this morning. The full response >>should be... >> >> From the IBM Informix Guide to SQL: Reference (Version 9.4, Part No. >>CT1SPNA): >> >> >>You can insert data into BYTE columns in the following ways: >>- With the dbload or onload utilities >>- With the LOAD statement (DB-Access) >>- From BYTE host variables (IBM Informix ESQL/C) >> >>You cannot use a quoted text string, number, or any other actual value >>to insert or update BYTE columns. >> >> >>If you don't already have it, you can find Informix documentation online >>at http://www.ibm.com/software/data/informix/library > > > Strewth Sheila, can't ya just abbreviate that as RTFM???? You don't half go > on... > echo "2|Fritz|234323432343234323FC4350FC4350FC4350FC4350FC" > byte.unl create table tblslime(id int, name char(8), slime byte); load from byte.unl insert into tblslime;