Re: Compiler/SQL debug options

Tom

This is great. I vaguely remember seeing that parm, but we don't develop to V5R3 as a min release at this time.

Also, I thought someone said that *SOURCE in the SQL create is effectively *ALL - not sure - and I suppose I could verify it once in debug with F15 - maybe when my curiosity o'erwhelms my time constraints!

Regards
Vern

At 10:36 PM 2/11/2008, you wrote:

A couple weeks ago, I commented that I always compiled with
DBGVIEW(*ALL). Unfortunately, I've lost the thread and wasn't able
to respond in time to a comment that was added to my comment.

I had said that I hadn't found a downside to DBGVIEW(*ALL). A
follow-up response was made that the SQL pre-compiler commands only
allowed [*NONE/*SOURCE] so *ALL was not available as a possibility.

I want to point out that there is a CRTSQLRPGI COMPILEOPT()
parameter that allows you to pass options through the SQL
pre-compiler to the language compiler. If you do not specify
anything for the DBGVIEW() parameter on the CRTSQLRPGI command, you
can specify COMPILEOPT(dbgview(*all)) in order to get the module
compiled as DBGVIEW(*ALL).

The COMPILEOPT() parameter is available at V5R3. It can be used for
many of the CRTRPGMOD parameters. I haven't used it for other
languages yet (no SQL outside RPG at the moment).

(I'm a little surprised that no one else mentioned this.)

Tom Liotta

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone 253-872-7788 x313
253-479-1416
Fax 253-872-7904
http://www.powertech.com
--
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.