Home > IT Answers > AS/400 > AS400 stored Procedure,what is the maximum parameters
AmuthaTPT
30 pts.
 AS400 stored Procedure,what is the maximum parameters
AS/400 stored procedures
I have created one stored procedure with 63 IN parameters and 1 OUT parameters.This stored procedure is calling one rpgle program.For testing I am creating one SQLRPGLE pgm,this SQLRPGLE pgm calls the stored procedure.But when I am debugging the stored procedure,it is not getting executed.Please give me the possible options.

Software/Hardware used:
ASKED: November 26, 2009  4:51 AM
UPDATED: December 1, 2009  4:50 AM
RELATED QUESTIONS
Answer Wiki:
There are dozens of reasons to choose from as to why your procedure is not being executed. Is there any way you could post some of your code or a more exacting definition of what is happening in your debug session?
Last Wiki Answer Submitted:  November 30, 2009  8:57 pm  by  Teandy   5,830 pts.
All Answer Wiki Contributors:  Teandy   5,830 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

But when I am debugging the stored procedure,it is not getting executed.

What happens instead? What error code do you get?

Tom

TomLiotta
 107,845 pts.
 

Yes, I found the error, the pblm is I have passed the parameters having more length than the defined parameters, That is the reason it is not getting debugged.
Thanks for your update.

AmuthaTPT
 30 pts.
 

Hi Teandy,

Actually I passed the the parameter which is having more length than the defined parameter length. And one more reason is I did not specify user open to the file .
Thats why the file is not getting updated.

Thanks for the update Teandy.

AmuthaTPT
 30 pts.