Re: SQL precompiler problem?

[David Gibbs <david@xxxxxxxxxxxx>]

Is the c data structure qualified?

On Sat, Dec 11, 2021 at 2:14 PM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

> This is from the DBGVIEW of a SQLRPGLE. The embedded SQL Statement is shown
> commented out and then the generated code. You can see that the SQL
> Statement has :C.GHRID but the generated SQL shows only GHRID.  This really
> screws up the program as you can imagine. Anyone seen this before?
>
> 145000   //*    exec sql select plt into :plt
>
> 145100   //*      from locplt00
>
> 145200   //*      where rid=:c.ghrid and bld=:locrec.bld  and
> sec=:locrec.sec
> 145300   //*      and ais=:locrec.ais and slt=:locrec.slt and
> lvl=:locrec.lvl;
> 145300      SQL_00005 = GHRID;
>
> 145300      SQL_00006 = LOCREC.BLD;
>
> 145300      SQL_00007 = LOCREC.SEC;
>
> 145300      SQL_00008 = LOCREC.AIS;
>
> 145300      SQL_00009 = LOCREC.SLT;
>
> 145300      SQL_00010 = LOCREC.LVL;
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com