Re: Fields Used in SQL Statements

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.