Click here to Skip to main content
15,889,693 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear Sir,
Let me known that How to crate a Store Procedure in db2/400 V7R2M0 for
Select records in table. and how to use this store Procedure in MVC application. pls guide me.

Thanks.
Daulat Singh.

What I have tried:

create procedure QGPL.PP4(IN a# INT,OUT b# Varchar(35))
Language SQL
BEGIN
select HDSUBJ into b# from ERPLXUSRF.KHDS where HDINNO=a#;
END

Test with On IBM iseries Navigator :
call QGPL.PP4(10,?)

But Can't Apply with MVC Application.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900