RE: SQL using subprocedure variables - v5r4

Jeff,

Are you sure that the variables names aren't used anywhere else?

At v5r3/v5r4 IBM did a better job of enforcing what was allowed to be
used as a host variable.

IIRC, v5r3 was very picky.  With v5r4, IBM added some enhancements that
allowed previously disallowed stuff.

You can find some discussions about this in the archives.  Just sure on
the message ID you are seeing.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx 
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Thursday, January 18, 2007 2:29 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL using subprocedure variables - v5r4

I have an SQL RPGLE program that in the past (V5R2) used host 
variables that were defined subprocedure parms as part of a 
Select Into clause.
The client recently upgraded to V5R4, and now I get a message 
that the host variable is not unique.
Nothing has changed in that section of the code since I 
compiled it last.
The variable names I am using are defined only in  the 
subprocedure that I am using them in.

Is this an "enhancement" or a (gasp) bug?

Thanks,
 
Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries 
Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical 
Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical 
Solutions Implementer V5R3


 
______________________________________________________________
______________________
Now that's room service!  Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097
-- 
This is the RPG programming on the AS400 / iSeries (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.