Re: Problem debugging RPG SQL -- RPG400-L

Adam

Not sure where to start - there is an SQL Programming manual under Database in Infocenter - that is probably the best jumping-off point. There are chapters on the various languages.

To debug you want to say *SOURCE for the debugging view - STRDBG works fine - taking F15 in STRDBG brings various options - I usually end up using the RPG listing.

Some of this depends on the release of the OS that you have - and having the latest PTFs for database, as well as the CUME fixes.

Anyhow, find the SQL Programming manual - it may be called different things at different releases - heh. Paul Conte also has fine book about SQL on AS/400 - a few years old but still valid. There is also a redbook on performance, 2 of the writers are in this list - Elvis Budimlic, with whom I once worked, and Birgitta Hauser.

HTH
Vern

-------------- Original message --------------
From: 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 wrote:

From: vhamberg@xxxxxxxxxxx
Subject: Re: Problem debugging RPG SQL
To: "RPG programming on the AS400 / iSeries"
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

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.

--
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.

--
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.