Re: Compiler/SQL debug options

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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.