AS400 stored Procedure,what is the maximum parameters

30 pts.
Tags:
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.
ASKED: November 26, 2009  4:51 AM
UPDATED: December 1, 2009  4:50 AM

Answer Wiki

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

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?

Discuss This Question: 3  Replies

 
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
  • TomLiotta
    But when I am debugging the stored procedure,it is not getting executed. What happens instead? What error code do you get? Tom
    125,585 pointsBadges:
    report
  • AmuthaTPT
    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.
    30 pointsBadges:
    report
  • AmuthaTPT
    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.
    30 pointsBadges:
    report

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