AW: Host variable

Hi,

which release are you using?
If you are on release V5R3M0, the host variables (used in SQL statements)
must be unique in your source member. There is no workaround (at least I
don't know about a work around) other than renaming your host variables.

According to the IBM documentation there are some changes in release V5R4M0:
* The names of host variables must be unique within the program. The one
  exception is that if a stand-alone field, parameter, or both, are defined
  exactly the same as another stand-alone field, parameter, or both, the
  duplicated name is accepted. 

* If a host variable is a duplicated name and does not belong to the
  exceptional category mentioned in the previous item, but does have the
  same type, the precompiler issues SQL0314 as a severity 11 error instead
  of its normal severity of 35. If you want to ignore these severity 11
  errors, change the GENLVL parameter value on the CRTSQLRPGI command to be
  11 or higher.  

Mit freundlichen Grüßen
 
i.A. Birgitta Hauser
 
LUNZER + PARTNER GMBH
Consulting | Software | Service
Carl-Zeiss-Straße 1
63755 Alzenau
 
Tel:         + 49 6023 951-255
Fax:        + 49 6023 951-111
Internet.  www.lp-gmbh.com
              www.rpg-schulung.de
 
--------------------------------------------------------
Handelsregister: Aschaffenburg HRB 4720
Gerichtsstand und Erfüllungsort Alzenau
Ust-IdNr.: DE132093146
Geschäftsführer: Rudolf Gerbert
---------------------------------------------------------
 
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Bruce Barrett
Gesendet: Donnerstag, 1. Juni 2006 23:45
An: Midrange Systems Technical Discussion
Betreff: Host variable

                Email from one of the developers:

                SQL0314  35    4185  Position 35 Host variable WCOUNTEM
not unique.   

                According to IBM and search in MIDRANGE there were
changes with the new release fro ILE/SQL - and that there is 'work
around' - but I cannot find the 'work around'. Do you know what it is? I
think that someone had it with the previous release...

I reviewed the archives and we do have the PTFs on the partition.  The
PTFs have been superseded.  The variable is described many times in the
program.  Is there any other work around?

Bruce Barrett
PMI Mortgage Insurance Co.
3003 Oak Road
Walnut Creek, CA 94597
925-658-6152
510-520-4263 Cell
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.