Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
Chicagoland
Anyone using LOBs (CLOB, BLOB) in RPGIV?
has no ratings.
Published: 25 Aug 2011
Revised: 31 Jan 2013 - 2179 days ago
Last viewed on: 18 Jan 2019 (7686 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.

Anyone using LOBs (CLOB, BLOB) in RPGIV? Published by: Bob Cozzi on 25 Aug 2011 view comments(3)

I started using a BLOB about a year ago to store a signature captured from a Topaz signature capture device. It works fine. Then recently I started using a CLOB instead of a large VARYING field.

Anyone else using anything like this and have any tips they'd like to share? I'm wondering if there's a storage difference if I use a VarChar(32766) vs CLOB(32766) if I include the ALLOCATE(xx) keyword on both types of fields? It would be just like IBM i to store the DB2 values identically in the database and yet make it more difficult to use the CLOB than a VARYING (VARCHAR) field. Wink

I started using a BLOB about a year ago to store a signature captured from a Topaz signature capture device. It works fine. Then recently I started using a CLOB instead of a large VARYING field.

Anyone else using anything like this and have any tips they'd like to share? I'm wondering if there's a storage difference if I use a VarChar(32766) vs CLOB(32766) if I include the ALLOCATE(xx) keyword on both types of fields? It would be just like IBM i to store the DB2 values identically in the database and yet make it more difficult to use the CLOB than a VARYING (VARCHAR) field. Wink

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

COMMENTS