Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

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.
0
bharath tata
Asked:
bharath tata
1 Solution
 
tliottaCommented:
See my responses to How do AS/400 stored procedures get output?. These seem to be duplicate questions. It's not clear which one might be deleted if they are duplicates, but responses have already been entered under the other Q.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now