Did you know?

Work smarter with Stored Procedures......Re-use existing logic when remote clients need data.

Stored procedures allow you to maintain & reuse your business logic on the iSeries while acquiring the ability to integrate other systems. Once a program is declared a stored procedure on your iSeries, it can be called from any platform that supports SQL. So, for example, a GUI interface or VB app can use all the logic hosted on your iSeries!

The only problem arises when you try to test stored procedures on the iSeries. As usual, it’s a chore to get your results without actually executing the process and wading thru each piece step by step or by writing an additional program.

STE – Stored Procedure Test Environment can remedy this.

STE prompts the user for the required input parameters directly on the iSeries. The result sets are generated and the output parameters that are returned are displayed or printed. STE makes the development and testing procedure that much easier and succinct, allowing you to work smarter with stored procedures.

Features at a Glance:

Prompts the user for the required input parameters.
Displays the result set(s) that were generated.
Displays the output parameters that were returned for the stored procedure.
Printing the results is also available.
** STE requires OS400 V4R4 and above.