× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.






Hi All,
I know that having unique host variable names within the program is
frustrating.  Especially when the SQL starts acting funny and the error
isn't obvious.  Before v5r3, the type of a duplicate name was not
dependable and may even affect data structures.  That is why the manual
states the names must be unique.   In v5r3, the precompiler changed the way
duplicate names are handled.  As some of you have seen, you are now getting
SQL0314.  Having QUALIFIED helps a little.  I also did make a small
exception, that if there is a stand alone defined exactly like another
stand alone, I won't error with name not unique.  If you look in the XREF,
you will see that it is only in there once.  Note that I said small
exception...it currently doesn't even support duplicate names defined with
the same LIKE.  I'm currently working on a v5r3 PTF that will expand the
exception to parameter names which are defined exactly the same and stand
alone/parameters that are defined with LIKE.

Gina


>date: Wed, 25 Aug 2004 10:36:48 -0400
>from: CWilt@xxxxxxxxxxxx
>subject: RE: Subroutines vs Subprocedures was RE: Indicators
>
>Well, like I said I end up relearning this all the time.
>
>But try having the global zip have different attributes.
>
>Also, try putting it into a DS.
>
>>From the manual:
>v5r2 - "The names of host variables must be unique within the program,
even
>if the host variables are in different procedures."
>
>v5r3 - "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."
>
>
>Charles


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.