Fields Used in SQL Statements

HI Bill

Me too.
Wierd thing is I tried to save the generated SQL source to TOSRCFILE,
CRTSQLRPGI OBJ(MYLIB/MYPGM) SRCFILE(MYLIB/QRPGLESRC) SRCMBR(MYPGM)
OBJTYPE(*PGM) REPLACE(*YES) TOSRCFILE(MYLIB/QSQLSRC).
When I open the source generated by the SQL precompiler the outline
view STILL is not helpful.
I can see no obvious link between the generated SQL data structures
and the files and fields that are being updated. Reading the generated
code I cannot understand how the SQL APIs know what to process.
The SQL precompiler is my pet peeve.

I use the FIND ALL function to find SQL field usages, but it is a
kludge compared to the outline view.
Frank Kolmann

date: Wed, 21 Nov 2007 08:41:43 -0500
from: "Bill Barnes" <bbarnes@xxxxxxxxxxxxx>
subject: [WDSCI-L] Fields Used in SQL Statements
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