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:
** STE requires OS400 V4R4 and above
DBU access to the System i AS/400 database is available thru the traditional green screen, our graphical user interface and even thru IBM's Systems Navigator and WDSc. Just let us know what you are most comfortable with & we will get you up and running!
IBM Platforms
AS/400, iSeries, i5, Sytem i, IBM i and Power Server