Re: SQL using subprocedure variables - v5r4

This is happening in V5R3 too.  something about the SQL compiler doesn't
recognize the difference between the subprocedure's local variables and the
main procedure's global variables.  I believe...

I don't remember if this was the same in earlier versions.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
We've built a better hotcake -- Stacked and Stuffed Hotcakes -- coming
January 11th!
For hotcake tips, interviews with our chefs and more, check out the Stacked
and Stuffed blog at http://imstuffed.blogspot.com


rpg400-l-bounces@xxxxxxxxxxxx wrote on 01/18/2007 02:29:24 PM:

I have an SQL RPGLE program that in the past (V5R2) used host
variables that were defined subprocedure parms as part of a Select
Into clause.
The client recently upgraded to V5R4, and now I get a message that
the host variable is not unique.
Nothing has changed in that section of the code since I compiled it last.
The variable names I am using are defined only in  the subprocedure
that I am using them in.

Is this an "enhancement" or a (gasp) bug?

Thanks,

Jeff Young
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical
Solutions V5R2
IBM  Certified Specialist- e(logo) server i5Series Technical
Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3

____________________________________________________________________________________

Now that's room service!  Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.