Re: INSERT Binary Data
--0__=88BBE5B0DFC273138f9e8a93df938690918c88BBE5B0DFC27313
Content-type: multipart/alternative;
Boundary="1__=88BBE5B0DFC273138f9e8a93df938690918c88BBE5B0DFC27313"
--1__=88BBE5B0DFC273138f9e8a93df938690918c88BBE5B0DFC27313
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Not directly .. but if you are on 9.x release ..and use a CLOB data typ=
e
.there are functions like FileToClob provided to do the needful.
Take a look at the program blobload.ec in the samples directory for CSD=
K.
For your simple case, u can just compile that program and use it for ur=
purpose.
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
IBM Data Management Group
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
=
Martin =
Steinwender =
<steinwender@gmx. =
To
net> informix-list@iiug.org =
Sent by: =
cc
owner-informix-li =
st@iiug.org Subj=
ect
INSERT Binary Data =
=
10/03/2004 03:10 =
AM =
=
=
Please respond to =
Martin =
Steinwender =
=
=
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
=
--1__=88BBE5B0DFC273138f9e8a93df938690918c88BBE5B0DFC27313
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Not directly .. but if you are on 9.x release ..and use a CLOB data =
type .there are functions like FileToClob provided to do the needful. <=
br>
<br>
Take a look at the program blobload.ec in the samples directory for CSD=
K. For your simple case, u can just compile that program and use it for=
ur purpose.<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer<br>
DB2/UDB Regional Advanced Support<br>
IBM Data Management Group<br>
<br>
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison<br>
<br>
<img src=3D"cid:10__=3D88BBE5B0DFC273138f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for Martin Steinwender =
<steinwender@gmx.net>">Martin Steinwender <steinwender@gmx.net=
><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE5B=
0DFC273138f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">Martin Steinwender <steinwender@gmx.net><=
/font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">10/03/2004 03:10 AM</font>
<table border=3D"1">
<tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"=
center"><font size=3D"2">Please respond to<br>
Martin Steinwender</font></div></td></tr>
</table>
</ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE5B0DFC273138f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE5B0DFC273138f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">informix-list@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE5B0DFC273138f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE5B0DFC273138f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE5B0DFC273138f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D88BBE5B0DFC273138f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">INSERT Binary Data</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE5B0DFC2=
73138f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE5B0DFC273138f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hi,<br>
<br>
I would like to INSERT Byte-Data INTO a BYTE-Coolumn using SQL<br>
<br>
This is how it works for