Re: Problem debugging RPG SQL

Vern, I do not know too much about SQL RPG. I was using the STRDBG.
Where can I read more about this type of RPG?
 
Happy 4th of July, especially to our Military people in harms way, may be protected at all times.

--- On Thu, 7/3/08, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:

From: vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx>
Subject: Re: Problem debugging RPG SQL
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Date: Thursday, July 3, 2008, 10:40 PM

CRTSQLRPGI takes your source - with the embedded stuff - and creates a source
file in QTEMP - if you do your compile in batch, you will not have any
connection to that QTEMP.

What debug view are you using on the CRT* command? You almost have no choice -
*SOURCE. Also, what release are you at? Which CRT command are you using?

Have a lovely 4th!
Vern

-------------- Original message --------------
From: Adam West <adamster@xxxxxxxxx>

HI I try to Debug a SQLRPGLE program but got this message. I
have this code ok Http_Debug(*On);

Message ID . . . . . . : CPF9C27 Severity . . . . . . . : 40
Message type . . . . . : Diagnostic
Date sent . . . . . . : 07/03/08 Time sent . . . . . . : 12:17:26

Message . . . . : File QSQLTEMP1 not available.
Cause . . . . . : Member in file QSQLTEMP1 in library QTEMP could
not be retrieved for display. Either the file could not be found or you

are

not authorized to the file or library.
Recovery . . . : The source debugger requires that the source files be
available and that you have the correct authorization to those files to
properly display the module source.
Technical description . . . . . . . . : *USE authority is required on

files

used by the source debugger.





--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.