Home > IT Answers > AS/400 > Explain Stored Procedures in AS/400
Mohan K
695 pts.
 Explain Stored Procedures in AS/400
AS/400 development, AS/400 stored procedures, Stored Procedures
Hi, Can any one please explain me 1.What is stored procedures in AS/400. 2.What is the use of Stored Procedure 3.Please give me small example how to code stored procedures in AS/400 4.What is the object type of Stored procedures 5. How can we code stored Procedures and how can we call it. and main purpose of this Stored Procedures. i am really interested to know about this concept in AS/400 can any one help me please.. ?

Software/Hardware used:
ASKED: February 20, 2009  8:31 AM
UPDATED: February 20, 2009  2:06 PM
RELATED QUESTIONS
Answer Wiki:
Stored procedure is: 1. Called by SQL 2. Is either a program written in PL-SQL or 3. Identifies a program (in languages like RPG/Cobol/CL etc) on the AS/400 to run 4. Can receive a set of IN parameters 5. Can return a set of OUT parameters 6. Can receive and return a set of IN-OUT parameters 7. Can return one or more record sets Here is a site that might help http://publib.boulder.ibm.com/html/as400/v4r5/ic2924/index.htm?info/db2/rbafymst148.htm There are also a few books you might want to pick up Phil
Last Wiki Answer Submitted:  February 20, 2009  2:06 pm  by  philpl1jb   44,150 pts.
All Answer Wiki Contributors:  philpl1jb   44,150 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _