Re: Ignore BLOB in RPG

But database doesn't expressly prohibit the non-query open

Hmmm, my statement does seem too general\overstated. However that the DB allows generally the non-query opens of database files with the /unsupported types/ I thought was obvious. All of the non-query opens for each of the commands OPNDBF, CPYF, and DSPPFM are for example, allowed without the CPF428A being issued.

However probably I should have been clearer in my quoted reply.

I was trying to emphasize that merely avoiding the external description was of no help in the proposed scenario. Because, remaining a non-query open [i.e. not being an SQL open by an SQL statement via ExecSQL in SQLRPG], the open would still fail. The database would prohibit the open, issuing CPF428A RC1, because the open was neither a query ODP nor was the "process large object fields" specified in the declaration for the non-query OPEN. There is no support for the latter in RPG [unless there is some undocumented interface like with C to enable that open option], thus the open would *always* be prevented by the database whenever the database open was requested via an RPG OPEN [implicit or explicit\UsrOpn]; full open or shared open, no matter, where the latter would fail instead with CPF417C RC6. Any mention of an open option that is unavailable to the RPG seemed moot for my earlier reply, but I suppose that would best have been explained, in order to have been clearer.

Regards, Chuck

On 05 May 2012 18:41, Bruce Vining wrote:

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 opening 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 wrote:

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

On 26 Apr 2012 10:23, Jack Tucky wrote:

I have a file that has a BLOB in it and I'm trying to read it
using standard Chain and ReadE. I don't need the BLOBs, how
can I drop them or tell the compiler to just ignore them?

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