Re: V3R2: stored procedure testing

["Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>]

Dan,

We are just getting started with stored procedures and I would like to see 
how you are testing them.
I did ours in ILE COBOL with the debug option and that worked ok. I also 
have a question that perhaps
you could answer; How do you return multiple rows to the calling program? or 
must an area or file
be set up to recieve an answer set?
 ----------
From: midrange-l-owner
To: MIDRANGE-L
Subject: Re: V3R2: stored procedure testing
Date: Thursday, July 17, 1997 5:20PM

Dan:

The best way to test a stored procedure is to write a little test
program and invoke the procedure.   I created a dspf with a dozen i/o
fields of various types and sizes and use the procedure to exfmt data.
Also, you should run this program under debug and check out all possible
kinks.  Let me know if you need the code and dspf for the test
program.   I recycle it everytime I create a new procedure (which is
almost everyday).

Dan Swartz wrote:

> Does anyone know of a way to test the call of a stored procedure?
>
> I realize that I can test the individual program that is referred to
> but
> I'm looking to test the calling of the stored procedure, including the
>
> input and output parameters.
>
> I want to make sure my AS/400 is processing properly so that during my
>
> client/server application, I can further narrow any problem areas.
> Thus my
> PC app might need to be reviewed.
>
> Thanks in advance for any help.
>
> Dan

 --
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
uucp
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *