Re: Fetching joined views

[Carel Teijgeler <coteijgeler@xxxxxxxxx>]

Trevor,

which ddlWRK to fetch into: no 1 or no 2?

Regards,
Carel Teijgeler

On 3-6-2014 16:58, Briggs, Trevor (TBriggs2) wrote:
> I have a SELECT in an RPG program that joins an existing view  MYVIEW
> (in QTEMP) and a table MYTABLE. I tried to declare the combined input
> buffer like this:
>
>
>
>       d ddLWRK1       e ds                  ExtName(MYVIEW)
>
>       d ddLWRK2       e ds                  ExtName(MYTABLE)
>
>       d ddLWRK          ds                  Qualified
>
>       d   ddLWRKDS1                         LikeDS(ddLWRK1)
>
>       d   ddLWRKDS2                         LikeDS(ddLWRK2)
>
>
>
> and my fetch would be:
>
>
>
> exec sql
>
>    FETCH SqlCsr Into :ddLWRK;
>
>
>
> But I get an "SQL0312: Position 40 Variable DDLWRK not defined or not
> usable" error
>
>
>
> Is it even possible to do what I'm attempting - i.e. avoiding having to
> define the input fields manually?
>
>
>
> We're currently on bare-bones release 7.1.
>
>
>
> Thanks,
>
>
>
> Trevor Briggs
> Analyst/Programmer
> Lincare, Inc.
> (727) 431-1246
> TBriggs2@xxxxxxxxxxx
>
> ************************************************************************************************************************************************************************************************************
> This message originates from Lincare Holdings Inc. It contains information which may be confidential or privileged and is intended only for the individual or entity named above.
> It is prohibited for anyone else to disclose, copy, distribute or use the contents of this message.
> All personal messages express views solely of the sender, which are not to be attributed to Lincare Holdings Inc., and may not be copied or distributed without this disclaimer.
> If you received this message in error, please notify us immediately at MailAdmin@xxxxxxxxxxx or (800) 284-2006.
> ************************************************************************************************************************************************************************************************************