Re: SQL precompiler problem?

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

--
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding in the American Diabetes Association's Tour de Cure to raise
money for diabetes research, education, advocacy, and awareness. You can
make a tax-deductible donation to my ride by visiting
https://mideml.diabetessucks.net.

You can see where my donations come from by visiting my interactive
donation map ... https://mideml.diabetessucks.net/map (it's a geeky
thing).

I may have diabetes, but diabetes doesn't have me!
--
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