Re: Retrieving SYSCOLUMNS field in CLLE

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Dan

Seems this is another prime example of why one does NOT use CL for this 
kind of thing - it is all so easy in RPGLE. And I suspect CL won't 
support things like LOBs on DCLF any time soon.

I suggest using DECLARE CURSOR in RPGLE - eezee-peezee!

HTH
Vern

On 8/18/2017 3:18 PM, Dan wrote:
> I have a CREATE TABLE in a CLLE program that queries SYSCOLUMNS for one
> record (never more than one record, could be zero) and I need the value
> from one field.
>
> I tried DCLF SYSCOLUMNS and did an override to the file created by CREATE
> TABLE, but upon doing a RCVF, I got CPF428A (Open failed because "The
> format for file TMPSYSCOLS contains one or more large object fields and the
> open request did not indicate that large object fields could be processed
> by the user of the open."
>
> I did specify AlwGraphic(*Yes) on the DCLF because it wouldn't compile
> without it.  But I see no option on DCLF or RCVF to process or ignore
> "large object fields".
>
> So, I am changing the query in the aforementioned CREATE TABLE to select
> the one field I need.  Now the table has the field, but since it is created
> on the fly, I have nothing at compile time for a DCLF, and I'd really like
> to avoid creating a permanent file for this.  It would just be freaking
> useful to be able to do a SELECT INTO in CL like we can in RPG.
>
> Don't know if the "late Friday after a long week brain fry" is affecting my
> memory, but is there a way to do this without creating a permanent file
> needed to compile the program?
>
> FWIW: We're on v7r1 with the latest TRs.
>
> - Dan