Solved

How to create a stored procedure in AS400

Posted on 2016-09-19
1
97 Views
Last Modified: 2016-09-22
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
Comment
Question by:bharath tata
1 Comment
 
LVL 27

Accepted Solution

by:
tliotta earned 500 total points
ID: 41805206
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question