PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

How to create and Use SQL Stored Procedures?

View previous topic View next topic Go down

How to create and Use SQL Stored Procedures?

Post  maran on Thu Jul 28, 2011 1:45 pm

Stored Procedures

Stored procedures are programs that are called from SQL. These programs can be written using the SQL procedure language, but they may also be written using RPG.

So how do you write SQL Procedure? It is simple. You just need to write SQLRPGLE with “CREATE PROCEDURE” SQL Statement



Example 1.


C/Exec SQL

C+CREATE PROCEDURE GetName

C+ (IN ProgLang CHARACTER(10),

C+IN Comp CHARACTER(20),

C+INOUT FOUND INTEGER(4))

C+LANGUAGE SQL

C+SELECT COUNT(*) INTO FOUND FROM TestLib/NameData

C+WHERE TechLang = ProgLang AND Employeer = Comp
C/End-Exec


How to compile the Procedure?
You can compile the above code like any other SQLRPGLE code

How to call above procedure?
Create another RPGLE code as below

D GetName PI
D ProgLang 10A
D COMP 20A
D Found 4
.
.
.
.
Call GetName( :EMPID, :Comp, :Found);


avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum