Re: Problem debugging RPG SQL

[Adam West <adamster@xxxxxxxxx>]

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.