Explain Stored Procedures in AS/400

695 pts.
Tags:
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.. ?
ASKED: February 20, 2009  8:31 AM
UPDATED: February 20, 2009  2:06 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following