This article may help...
http://www.systeminetwork.com/artarchive/newsletter/w/1001/n/5012/i/6259
/a/53910/An_Easier_Way_to_Debug_Batch_Jobs.html
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Planet of the Apes
Sent: 03 October 2007 22:01
To: RPG programming on the AS400 / iSeries
Subject: Re: Debugging RPGIV program used by SQL UDF (was Extraction
problem)
I'll have to disagree with you there, Buck.
I used STRDBG to set a breakpoint in the RPGIV program, then used STRSQL
to execute the UDF, but it wouldn't stop at the breakpoint. SO, I did a
Google search on 'debug iseries user-defined function' and found another
ITJungle article that indicates that in order to debug a SQL UDF (at
least in a green-screen session) you must start another green-screen
session and use STRSRVJOB to debug the program in the green-screen job
where the SQL is being executed.
See:
http://www.itjungle.com/mgo/mgo062503-story01.html
BTW, I'm using WDSC these days and I also tried without success to debug
it by setting a Service Entry Point from WDSC to debug it. I was able
to set an SEP on the program, but it wouldn't start debugging the
program in WDSC when I was using STRSQL on the green-screen session. I
guess I need a tutorial in debugging with WDSC...
At least I can use the old tried-and-true green-screen method in the
meantime.
However, I'm making an earnest attempt to switch over to WDSC - I would
really like to figure out how to debug this pgm with an SEP.
Regards,
sjl
----- Original Message -----
From: "Buck" <kc2hiz@xxxxxxxxx>
Newsgroups: midrange.rpg400-l
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, October 03, 2007 2:41 PM
Subject: Re: Debugging RPGIV program used by SQL UDF (was Extraction
problem)
Planet of the Apes wrote:
I found the INCR function and program in Ted Holt's article (in the
itjungle link below) to be useful. Now I'm trying to debug it, to no
avail. What is required to debug a program like this one - that is
run as the result of a SQL user-defined function call?
You can run your function using STRSQL in an interactive session. You
can put the RPG program in debug in the same interactive session
before you use STRSQL.
You can also use WDSC and SEP to debug from any job.
--buck
--
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.
midrange.com
