Re: Same Local variable name using like( ) inmultiplesubproceduresgetsSQL0312

Michael,

Thanks very much for sending out this message - too often problems raised on
these forums are resolved and no-one ever finds out about the resolution
(especially if it's a PTF). It's nice to see a concise "Problem resolved,
here's what I did" follow-up.

Rory

On Thu, Sep 23, 2010 at 8:50 AM, Koester, Michael <mkoester@xxxxxxxxxxxxx>wrote:

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