RE: Same Local variable name using like( ) inmultiplesubproceduresgetsSQL0312

Just wanted to wrap this up: SysAdmin finally got the PTF applied, and my test program compiled fine, proving that the PTF SI39274 did indeed fix the problem. If someone else has this same issue, be aware that one of the pre-requisite PTFs (SI38731) required an IPL.

To recap briefly, the issue was that I had a SQLRPGLE source that compiled fine when we were at V5R4, but now on 6.1, that same source threw SQL0312 (Variable not defined or not useable) from the SQL precompiler because there were multiple subprocedures defining the same local variable with LIKE(theGlobalVariable).

And I owe David Foxwell a beer.
Many thanks.
Michael


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Koester, Michael
Sent: Thursday, September 09, 2010 7:56 AM
To: RPG programming on the IBM i / System i
Subject: RE: Same Local variable name using like( ) inmultiplesubproceduresgetsSQL0312

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.