Re: sqlrpgle host variable definition confusion

[Jose Perez <joseenocperez.jp@xxxxxxxxx>]

Sorry my bad change it to *input instead of *output.

On Fri, May 4, 2018 at 3:20 PM Jose Perez <joseenocperez.jp@xxxxxxxxx>
wrote:

> Try Changing your likerec to *output instead of *all.
>  LikeRec automatically creates the data structure as Qualified, whereas
> ExtName does not. in case you need it then specify  the Qualified keyword.
>
> On Fri, May 4, 2018 at 2:08 PM Dave <dfx1@xxxxxxxxxxxxxx> wrote:
>
> > Hello,
> >
> >
> >
> > I often get the message SQL0312 ( not defined or not usable) when trying
> > to
> > use cursors and local variables in a sub procedure. I'm guessing that it's
> > a problem of the precompiler, maybe there's some rules to avoid this
> > problem?
> >
> > But here is a case I just had which I don't understand :
> >
> >
> > In the example below, when the data structure is declared with « likerec
> > »,
> > the compiler returns two messages (SQL0312) saying that SD and MyField
> > “are
> > not defined or not usable”.
> >
> >
> > If I use the “extname” definition, there are no errors. But in this case,
> > the data structure isn’t qualified, so why does it compile?
> >
> >
> >
> > Why does the first not compile and why does the second compile with no
> > error?
> >
> >      d*SD              ds                  likerec ( DSPF_Record : *ALL )
> >
> >      d SD            e ds                  extname ( MyDspF : DSPF_Record
> > )
> >
> >
> >
> >        exec sql
> >
> >          declare c1 cursor for
> >
> >          select *from myTable where : SD.MyField <> '';
> >
> >
> >
> > Thanks
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> > mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/rpg400-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: http://amzn.to/2dEadiD