Hi Mark


I've never used the COMPILEOPT parameter, DBGVIEW(*SOURCE) has always given me more than that option in CRTSQLRPGI than it does for CRTBNDRPG - the latter only puts a reference to the source member in the program object. I have believed that IBM treated *SOURCE like *ALL, not sure now, although I get everything I need for debugging with *SOURCE. As of 7.5, I thought IBM have added *ALL, but I don't see it. It did seem to add some text to the help on the command parameter. The help text for the DBGVIEW parameter ot CRTSQLRPGI at 7.3 is not very helpful, as here -


*SOURCE
The SQL precompiler will provide the source views for the root and if necessary, SQL INCLUDE statements. A view is to be provided which contains the statements generated by the precompiler.


In addition, that help says nothing about the *STMT and *LIST options on the DBGVIEW parameter.


To the Turnover user (se also use it), check the defaults for commands - seems that the defaults now include useful debug settings - it used to use *NONE or *STMT for default, and we've never changed it here.


RDi uses *SOURCE for CRTSQLRPGI and CRTBNDRPG, last I looked.


If you DMPOBJ a program, you can find the various debug views in the object. I just checked on an SQLRPGLE program and see Source View (only the source member reference), SQL Output View, Listing View, ILE RPG Source View, ILE RPG Copy View, and Statement View. I'd used the *SOURCE option. This does make for a rather larger object size, with 4 copies of the source, basically. Using *LIST in COMPILEOPT would be much smaller.

Cheers
Vern


On Thu, 13 Jul, 2023 at 7:23 AM, Mark Waterbury <mark.s.waterbury@xxxxxxxxxxxxx> wrote:


To: midrange systems technical discussion

Darren,

IBM has anticipated your needs. :-)

Prompt the CRTSQLRPGI command, press F10=Additional parameters, then page down to the bottom, where you will see the large input field for "Compiler options" (COMPILEOPT keyword).

You can type into this field any keywords and options from the underlying CRTRPGMOD or CRTBNDRPG command that you need ... so in your case, you might have:

CRTSQLRPGI OBJ(MYPGM) ... COMPILEOPT('DBGVIEW(*ALL)')

Personally, I prefer DBGVIEW(*LIST) to DBGVIEW(*ALL).

Hope that helps,

Mark S. Waterbury

On Thursday, July 13, 2023 at 08:09:05 AM EDT, Darren Strong <darren@xxxxxxxxx<mailto:darren@xxxxxxxxx>> wrote:

DBGVIEW(*ALL) is not available on the CRTSQLRPGI command for me.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.