> Can anyone please supply the syntax required for inserting/updating BLOB
> (Text) fields.
> For instance INSERT tablename (COL1, BLOBCOL)
> VALUES ('firstvalue', ??????????)
> Dave Goldsbrough
You have to write a "small program". ESQL/C or Java-JDBC is fine.
If you are using Smart BLOBS (IDS 9.x requested) you can use two nice
functions to "select" and "write" (insert) those BLOBs called "lotofile"
and "filetoblob". For syntax look at the SQL Syntax Guide from the Answer