iSeries SQL function in a SQL procedure

15 pts.
Tags:
AS/400
IBM iSeries
iSeries SQL
Hi everyone. I have created an SQL procedure using Create Procedure interactively after starting SQL with STRSQL on an iSeries V5R4. I then created a function using the Create Function statement interactively in SQL on the iSeries. I put the function in the select field prior to the where clause. The function works interactively in a SQLRPGLE and the procedure works without the function included in the select. However, when I put the function in the select I receive the error message function name "in *LIBL type *N not found". I qualified the library in the create function statement and qualified the library on the "SPECIFIC" parameter. Drilling down further in the error message indicates the external name and the usage name are different. What am I missing here? Thanks

Software/Hardware used:
iSeries E8A running V5R4

Answer Wiki

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

There are at least three things you’re missing here.
<ol>
<li>The CREATE PROCEDURE statement is missing.</li><li>The CREATE FUNCTION statement is missing.</li><li>The statements that work and don’t work are missing.</li>
</ol>

Without those, there’s not much anyone can add to what you wrote above. You need to show us the statements in order for us to make more than random guesses. Post them in the ‘Discussion’ area below. At the least, someone might be able see from them that there are other things you also need to post — library structure, RPG creation parameters, authorities…

Tom

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