bharath tata
asked on
How to create a stored procedure in AS400
I need to create a store procedure which calls a CL program.
I want the stored procedure to return the output when called.But when i define a stored procedure with input and output parameters im not able to call the procedure.
If i define it with only input parameters and call it i'm able to view the result in debug mode.But if im not in debug mode im getting a return statement "call statement successful',but im not able to view the output.
My question is how can i view the output..?
system: AS400
**stored procedures are created on DB2 by using create procedure command.
I want the stored procedure to return the output when called.But when i define a stored procedure with input and output parameters im not able to call the procedure.
If i define it with only input parameters and call it i'm able to view the result in debug mode.But if im not in debug mode im getting a return statement "call statement successful',but im not able to view the output.
My question is how can i view the output..?
system: AS400
**stored procedures are created on DB2 by using create procedure command.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.