Re: Ignore BLOB in RPG

A minor point as it doesn't apply to the original question concerning RPG
opens), but the Control Language for Files (CLF) product does allow the
direct openiing of a database containing BLOBs. With the CL ReadRcdCLF
command you cannot access the contents of the BLOB, but you can work with
all of the "normal" type fields/columns in the record/row. Somehow I doubt
that Jack wants to change his program from RPG to CL though :) But
database doesn't expressly prohibit the non-query open (though it doesn't
make it easy either :) )

Bruce Vining (the author of CLF)

On Fri, Apr 27, 2012 at 12:52 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

On 27 Apr 2012 10:01, Justin Taylor wrote:

Would it work to define I-specs and omit that column?

No. The database expressly prohibits the non-query open [effectively
non-SQL open; i.e. CQE allows open, but IIRC has limited support beyond
accepting the inclusion of the fields as part of a query] of the file
with a record format that has the unsupported types. What the RPG
program claims to be the record format with its internal descriptions is
moot. See msgid: CPF428A

Regards, Chuck
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.