Inserting Blob data through SQL

Posted in 2004

LLOYD SERRAO — Fri, 23 Jan 2004 05:01:25 — source: IIUG Forums & Mailing Lists

Dear All, Has any one tried inserting a blob data through SQL. When i try to insert using dbaccess i get the below error - " (U0001) - blob_input: cannot convert LO from argument string " I know there is a workaround to do it. Appreciate you reply. Best Regards, Lloyd

↪ replying to LLOYD SERRAO

BRYAN FAY — Mon, 26 Jan 2004 16:29:17 — source: IIUG Forums & Mailing Lists

You can insert into a blob field with dbaccess if you use the load command as below where the blob text you want to insert is in a file called blobtextfilename. load from 'blobtextfilename' insert into blob_table (blob_column)

↪ replying to BRYAN FAY

LLOYD SERRAO — Tue, 27 Jan 2004 09:18:01 — source: IIUG Forums & Mailing Lists

Hi Bryan, Thanks for the feedback, does that mean we can load data in blob only through the "LOAD" command and not using insert clause. Best Regards, Lloyd

Glossary

dbaccess