Re: Debugging sqlrpgle based UDTF with RDi

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I've been able to test with SEPs...

Did you end and restart the debug server?

Charles

On Tue, Aug 13, 2019 at 2:13 PM Rob Berendt <rob@xxxxxxxxx> wrote:

> I'm down to debugging the old fashioned way:
>     command = 'SNDMSG MSG(''Input parms ' +
>               library_name +  ' ' + object_type + ' ' + object_name +
>               ''') TOUSR(ROB)';
>     CommandLength = %len(%trim(command));
>     callp qcmdexc(command: CommandLength);
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
> -----Original Message-----
> From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
> Berendt
> Sent: Monday, August 12, 2019 10:27 AM
> To: WDSC LIST <wdsci-l@xxxxxxxxxxxxxxxxxx>
> Subject: [WDSCI-L] Debugging sqlrpgle based UDTF with RDi
>
> I followed Scott's example of a RPG based UDTF at:
>
> https://www.scottklement.com/presentations/RPG%20User%20Defined%20Functions%20%26%20Table%20Functions.pdf
>
> I am having a few issues and I'd like to debug it using Rational Developer
> for i.
> I run it by using Run SQL Scripts and executing this command:
> select *
> from table(Retrieve_Program_information('ROB', '*ALL', '*SRVPGM')) as t ;
>
> Assume that I'm either new or really rusty using the debugger.
> I did some searching on this and came across one link which says to ensure
> that turn off "Terminate debug session on program completion".  Well, this
> box is unchecked and greyed out.
> I started out with
> IBM i: Debug Batch Application  (maybe this is a bad start?) Added my
> *SRVPGM.
> Step into: on
> Terminate debug session on program completion: off Search i Projects first
> for debug source: on Update production files: on How to start: has some
> SBMJOB in there by default
>
> I had clicked on a "just has to run" line of code and selected it to be a
> SEP.
>
> Doesn't seem to come up in debugger or anything when I run that statement
> in Run SQL Statements.
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
> to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
> --
> This is the Rational Developer for IBM i / Websphere Development Studio
> Client for System i & iSeries  (WDSCI-L) mailing list To post a message
> email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change
> list options,
> visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/wdsci-l.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
> --
> This is the Rational Developer for IBM i / Websphere Development Studio
> Client for System i & iSeries  (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/wdsci-l.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com