RE: Same Local variable name using like( ) in multiplesubproceduresgetsSQL0312

Thanks so much David.
I'll have SysAdmin get right on it, and if it works, I owe you a beer. If it doesn't, the PMR will go forward. Stay tuned...
Michael

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Thursday, September 09, 2010 3:10 AM
To: RPG programming on the IBM i / System i
Subject: RE: Same Local variable name using like( ) in multiplesubproceduresgetsSQL0312

Hi,

We had this after going to V6R1. I got the info from this list that eventually led me to the PTF here :

http://www-01.ibm.com/support/docview.wss?uid=nas3dab5996c2cd7e54186257728005d9165

After that, Admin took over and I don't know what happened.

-----Message d'origine-----
De : rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Koester, Michael
Envoyé : mercredi 8 septembre 2010 22:41
À : RPG programming on the IBM i / System i
Objet : RE: Same Local variable name using like( ) in
multiple subproceduresgetsSQL0312

Thanks Mark.
Sadly, I'm not familiar with the PMR process, but I can
forward the gory details to our SysAdmin, and he can make it happen.
I just thought this may have been encountered by others, and
that I just needed to have aforementioned SysAdmin acquire
the appropriate PTF.
If not, I'll wait until the PMR happens and post the findings here.
Michael

~~~~~~~~~~~~~~~~~~~~
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S. Waterbury
Sent: Wednesday, September 08, 2010 4:09 PM
To: RPG programming on the IBM i / System i
Subject: Re: Same Local variable name using like( ) in multiple
subproceduresgetsSQL0312

Hello, Michael:

If this compiled at V5R4 and now it does not compile at V6R1,
you should

open a PMR with IBM Support.

(That is what IBM Support is for.)

Mark S. Waterbury

-----Original Message-----
> On 9/8/2010 3:54 PM, Koester, Michael wrote:

I'm re-posting this with sample code, hoping someone can

point me to a

PTF that will help our sql precompiler in v6.1 adjust to

the multiple

subprocedures using the same variable name defined with

Like(). This

compiled in our v5r4 environment, but requires a shoehorn

now to get

past SQL0312.
I dummied up a sample program that demonstrates the problem in the

link

below. See the comment at line 85. See my earlier post for a

complete

explanation of the problem.

http://code.midrange.com/efee525726.html

Thanks.
Michael Koester

--
This is the RPG programming on the IBM i / System i
(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.