Re: Embeded SQL - hostvar defined in subprocedure - compile works on some servers but not others

Åke,

Since all boxes are at v5r4, any chance that the boxes it
succeeds/fails on are doing something besides TGTRLS(*CURRENT)?

IBM tightened up the rules at v5r3, v5r4. So if I recall correctly,
code that may have compiled at v5r2 wouldn't at v5r3. But I seem to
recall that the rules loosened somewhat at v5r4.

Charles



On Fri, Sep 18, 2009 at 3:24 AM, Åke Olsson <ake.olsson@xxxxxx> wrote:

We have a package that runs on several I servers worldwide.



Recently - during a full recompile of the package - we ran into problems with the SQL pre-compiler on some servers but not on others.



The OS level everywhere is 5.4.



The problem is for SQL select statements where the host variable is defined locally in a sub-procedure. The pre-compile errors out with error messages saying that the variable is undefined.



Since the compile works on some systems but not others it seems to me that a PTF must be missing. Cannot find out which one though.



Upgrade to 6.1 is planned but there is no time schedule right now.





Med vänlig hälsning / Best regards


Åke H Olsson



Box 433   SE 551 16  Jönköping   Sweden   visit: Brunnsgatan 11

phone: +46 (0)36 342976   mobile: +46 (0)705 482976 fax: +46 (0)36 34 29 29

ake.olsson@xxxxxx <mailto:ake.olsson@xxxxxx>     www.pdb.se





This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.
--
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.