Re: SQL0314-Position 41 Host variable EXCHANGE not unique.

PMR is closed.  Evidently this is a limitation.  They have some "work 
around" ptf's:  SI17120, SI17121, SI17122.

What's new for Version 5 Release 3 in the Embedded SQL programming topic
- Rules for host variables in ILE RPG. 
>>The names of host variables must be unique within the program, even if 
the host variables are in different procedures. However, if a data 
structure has the QUALIFIED keyword, then the subfields of that data 
structure can have the same name as a subfield in a different data 
structure or as a stand-alone variable. The subfield of a data structure 
with the QUALIFIED keyword must be referenced using the data structure 
name to qualify the subfield name.<<

What a lovely "enhancement" that was.

Time to submit yet another DCR.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





rob@xxxxxxxxx 
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
02/17/2005 04:52 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: SQL0314-Position 41 Host variable EXCHANGE not unique.






Looking at some ptf cover letters it sounds like they made some changes in 

V5R3 to cause this error.  In previous editions, it might allow this but 
then corrupted data might occur.  One ptf mentions a trick in which you 
change your severity level to allow the compile to go through.  (Delayed 
ptf, of course.)

Then again, I did just put on cume 5032, which includes SI16120 and maybe 
that bad boy is causing the errors?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





rob@xxxxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/17/2005 04:42 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Subject
SQL0314-Position 41 Host variable EXCHANGE not unique.






I thought this was fixed.  In fact, I'm pretty darned sure local support 
for variables was added.  Because parts of this program have been in place 


for quite a spell now.

However now I am getting 
SQL0314-Position 41 Host variable EXCHANGE not unique.
on some of my local variables.  Another drag is, you fix one, and then it 
reports another variable.

CRTSQLRPGI OBJ(ROUTINES/SRVPGM) 
           SRCFILE(ROUTINES/QRPGLESRC)
           COMMIT(*NONE) 
           OBJTYPE(*MODULE) 
           TGTRLS(*CURRENT) 
           DBGVIEW(*SOURCE) 

WRKPTFGRP
PTF Group             Level  Status 
SF99530                5032  Installed 
SF99529                  38  Installed 
SF99503                   3  Installed 
SF99295                   2  Installed 
SF99287                   7  Installed 
SF99282                   3  Unknown 
SF99269                   4  Installed 
SF99185                   4  Installed 
SF99173                   1  Not applicable
SF99139                   1  Installed 
SF99099                   2  Installed 


Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

-- 
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.


-- 
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.