iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”
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
Software/Hardware used:
iSeries E8A running V5R4
ASKED:
February 4, 2010 4:36 PM
UPDATED:
February 6, 2010 12:39 AM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
