Using SRCDBG with an SQLRPGLE module

5 pts.
Tags:
RPGLE
SQL
SQLRPGLE
I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks.

Software/Hardware used:
AS400

Answer Wiki

Thanks. We'll let you know when a new response is added.

>> “There is no DBGVIEW option on the CRTSQLRPGI command,”

Um, there is on mine. And the v5r4 Information Center lists it as one of the parms for that command.

===============================================================

The DBGVIEW() parameter has been around for quite a while. I can see it on V5R3, but don’t know how much earlier than that. I suspect all the way back to the initial release of the command. Perhaps you need to press <F10=Additional parameters> to see what all exists.

But the preprocessor would have generated the source into QTEMP for the compile. The source is obviously no longer there.

Try:

<pre>
CRTSQLRPGI TOSRCFILE(mylib/myfile) COMPILEOPT(‘DBGVIEW(*SOURCE)’)
</pre>

Have the preprocessor place the source into a file of your choosing. And consider placing various options directly in the source, so you don’t have to remember the next time you compile. E.g.:

<pre>
C/Exec SQL Set Option CompileOpt(‘DBGVIEW(*SOURCE’)
C/End-Exec
</pre>

Tom

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Splat
    DBGVIEW on the CRTSQLRPGI command is either *NONE or *SOURCE.
    7,035 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following