A stored procedure is just (in the end) a CLE program... you can use RDi to debug that CLE program (that's CLE, not CLLE.) If you run a CREATE PROCEDURE myLib/myProcName (etc.) then the CLE program object is probably named something like MYLIB/MYPROC00001.
I forget how much information there is in the CLE program that relates to the stored procedure you wrote, but I am fairly sure that there are comments in there to help you work out what each piece of code relates to.
I'm not a C expert, unfortunately, and I suspect most of us aren't, so this advice may just be a last resort for you if all else fails.
-Paul.
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Ken Killian
Sent: 25 June 2014 21:34
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] RDi 9.1 --> Debug Stored Procedure using perspective: Database Development
Sadly, I guess the Test Procedure which is called "run..." is part of IBM Data Studio, not part of RDi 9.1 <Big Frown> Inside of Data Studio 4.1, when I right click a stored procedure, I get the option to "Run...", which I can test the stored procedure. Not built in with RDi 9.1 Database Development...
<frown>
Oh well, different package...
-Ken Killian-
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Ken Killian
Sent: Wednesday, June 25, 2014 2:16 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: [WDSCI-L] RDi 9.1 --> Debug Stored Procedure using perspective: Database Development
Hi,
I am on RDi 9.1, and using the perspective: Database Development...
I thought in Development view, we had an option to debug a stored procedure. I thought it was to right-click the procedure and select TEST/DEBUG or something like that...
Am I missing something?
I also thought I could examine properties of the stored procedure to see parameters, program, etc...
When I double-click, it opens up the source view. But I prefer to use the properties view. Especially when sharing with others...
One of the best things about the Database Development to me was the ability to test stored procedures!!!
-Ken Killian-
--
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@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
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@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
Scanned by MailDefender - managed email security from intY - www.maildefender.net
Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.
We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.
Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.
midrange.com
