Re: Fields Used in SQL Statements

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Hi Bill

You are not alone. I've long wished that host variables would be part 
of the outline. And file references in SQL statements - they CAN be 
parsed, after all, otherwise they could never be run by the system. 
So it is not impossible, just not in scope, it seems.

One area where it'd be more complicated - again, not impossible, in 
my view - is when a statement is held in a character variable and 
then prepared. There can be more than one string used in the same 
PREPARE, too. But, again, not impossible to deal with. I hope it 
happens - perhaps report it to IBM Support as a defect - see what 
happens. If they say it is by design, follow Rob's advice and submit 
a DCR - Design Change Request.

Regards
Vern

At 07:41 AM 11/21/2007, you wrote:

> When I look at the outline view and choose fields the :fields only find
> the D spec and not where they are used in an SQL program.  I learned to
> put indicator variables in my Fetch Into fields to reduce the number of
> log entries.  The outline view shows these as being defined but not
> used.  Is this a feature and I should just live with it, or am I the
> only one to which this is happening?
>
>
>
> Bill Barnes
>
> Sr Programmer Analyst
>
> The Pantry, Inc
>
> 919-774-6700 Ext 5211
>
>
>
> --
> This is the Websphere Development Studio Client for 
> iSeries  (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.