Re: User Defined Function Not Found In Library List

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Post the PI, the UDF definition and the test statement.

Charles

On Thu, Dec 4, 2014 at 10:53 AM, <jhaskins@xxxxxxxxxxxx> wrote:

> I've tried running it from both STRSQL and Run SQL Scripts, I get the same
> message.
>
> The function was created in the same library as our production data
> files.  The service program that the function executes is in a different
> library, though.  From what I can tell, the program library isn't in the
> library list for the job the Run SQL Scripts runs under.  I tried creating
> the service program in the production data library and it didn't correct
> the problem.
>
> Janell Haskins,
> Senior Business Analyst &
> Systems Manager
>
> Knit-Rite, Inc.
> 120 Osage Ave.
> Kansas City, KS 66105
>
> (913)279-6342
> -----Original Message-----
> From: Gary Thompson [mailto:gthompson@xxxxxxxxxxx]
> Sent: Thursday, December 04, 2014 8:47 AM
> To: RPG programming on the IBM i (AS/400 and iSeries)
> Subject: RE: User Defined Function Not Found In Library List
>
> How are you running your UDF; STRSQL, Run SQL Scripts, Debug session ?
> First guess is the library list is not what you assume it to be . . .
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> jhaskins@xxxxxxxxxxxx
> Sent: Thursday, December 04, 2014 7:33 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: User Defined Function Not Found In Library List
>
> Good morning;
>
> I'm attempting to create my first SQL user defined function (UDF) based on
> a service program written in RPGLE.
>
> The function was created without any errors and I can see it when I look
> at the functions for the schema (database) that I created it in.  However
> when I try to test it in a SQL select statement I get a message saying that
> it isn't found in the library list.  Since it's in the same library as the
> files in the schema, I can't understand why it isn't being seen.
>
> Obviously, since this is my first time, I've done something wrong and/or
> missed a step.  Can you offer any advice or suggestions about what is going
> on and how to correct the problem?
>
> Thanks!
>
>
> Janell Haskins,
> Senior Business Analyst &
>
> Systems Manager
>
> Knit-Rite, Inc.
> 120 Osage Ave.
> Kansas City, KS 66105
>
>
> (913)279-6342
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/rpg400-l.
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/rpg400-l.
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.