Hello ALL:

We are trying to copy a PDF file into a byte variable (BLOB) in an Informix table. Does anybody knows how? I tried the FILETOSTR function but for some reason I'm not able to paste the resulting value to the SQL I have to pass to Informix. The code I have so far looks something like this:

img=FILETOSTR("welt.pdf")
sqlstmt= "UPDATE document SET dm_doc = '"+img+"' where dm_pages=99"
res=SQLEXEC(gconn, sqlstmt)


Any Ideas are very welcome.

TIA,

Carlos