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

Thx,

Peter

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

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:

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

--
June Hunt

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|234323432343234323FC4350FC4350FC4350FC435 0FC" > byte.unl
create table tblslime(id int, name char(8), slime byte);
load from byte.unl insert into tblslime;