Trying to call a DB2 stored procedure in IBM System i Access
Tags:
I'm trying to test a DB2 stored procedure that's running on an AS/400 system. Our company currently has the IBM System i Access for Windows installed that runs SQL commands against the DB2 database.
My big question: What is the syntax to execute a stored procedure that takes in a parameter / returns a result as an output parameter and print the value to the screen?
I'm basically trying to figure out if I can execute the procedure and see the results in the GUI tool. Thanks for all the help.
My big question: What is the syntax to execute a stored procedure that takes in a parameter / returns a result as an output parameter and print the value to the screen?
I'm basically trying to figure out if I can execute the procedure and see the results in the GUI tool. Thanks for all the help.
Asked:
Last updated:
Related Questions
Answer Wiki
-
Last updated:54,090 pts.
- History
-
Contributors
- Ordered by most recent
-
54,090 pts.
Discuss This Question: 3 Replies
//in Navigator - run SQL script
//if you need to run any cl's --
CL: ADDLIBLE TESTDTA;
CL: ADDLIBLE TESTPGM;
//to call stored procedure
Call proclib.procName('Char Parm', 15, '005',003);
// So procName had 4 parameters (Char, Decimal , char, decimal)
I've got the options set to:
Display Results in a seperate window. <-- in/out paramenters will apear at the bottom of calling window but result sets will each be in a seperate window.
What is the syntax to execute a stored procedure that takes in a parameter / returns a result as an output parameter and print the value to the screen?
As Phil mentions, the syntax is the normal syntax for a SQL CALL statement. The 'Messages' pane will show OUT and INOUT parm values after a CALL successfully completes.
If the purpose is to return a value rather than a result set, you'd almost certainly be better off creating a FUNCTION than a PROCEDURE.
Tom