×
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.
Gary,
"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."
From page 97 of the System I Database DB2 Universal Database for iSeries Embedded SQL programming V5R4 manual.
I believe D*B wants to use the same host variable name in different procedures and have a SQL statement coded in each procedure use the appropriate variable.
Paul Morgan
Principal Programmer Analyst
IT Supply Chain/Replenishment
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Friday, October 21, 2011 9:29 AM
To: RPG programming on the IBM i / System i
Subject: Re: SQLRPGLE cursor questions
D*B - thanks: good information
Darren wrote:
Better support for local host variables might
come first, before local cursor declaration.
I am curious; can you give an example of better support for local host
variables ?
midrange.com
