Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
configured a table in a schema with a blob of about 20,000 bytes. Whenever a SELECT is issued against the table, it blows up/fails. Changed to varchar and it works fine...
I assume there are some restrictions for blobs?
Right. You have to define the field receiving the BLOB on the D spec, and specify:
D myField S SQL_BLOB( varName : 20000)
Lessons learned while watching the Steve McQueen movie has caused me to refrain from using Blobs. Better safe than sorry, right?