Midrange News for the IBM i Community

Posted by: clbirk
blobs in db2?
has no ratings.
Published: 11 Sep 2012
Revised: 23 Jan 2013 - 3162 days ago
Last viewed on: 20 Sep 2021 (4274 views) 

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.

blobs in db2? Published by: clbirk on 11 Sep 2012 view comments(2)

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?

Return to midrangenews.com home page.
Sort Ascend | Descend


(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Comment on: blobs in db2?
Posted: 9 years 9 days 5 hours 55 minutes ago

Right. You have to define the field receiving the BLOB on the D spec, and specify:

D myField      S             SQL_BLOB( varName : 20000)
Posted by: RalphAMiller
Premium member *
Franklin, TN
Comment on: blobs in db2?
Posted: 8 years 11 months 25 days 13 hours 31 minutes ago

Lessons learned while watching the Steve McQueen movie has caused me to refrain from using Blobs. Better safe than sorry, right?