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

["Koester, Michael" <mkoester@xxxxxxxxxxxxx>]

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.