Midrange News for the IBM i Community

Posted by: clbirk
blobs in db2?
has no ratings.
Published: 11 Sep 2012
Revised: 23 Jan 2013 - 2429 days ago
Last viewed on: 17 Sep 2019 (3786 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)

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: 7 years 6 days 7 hours 22 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: 6 years 11 months 22 days 14 hours 58 minutes ago

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