Re: More SQL UDF help

["Lennon_s_j@xxxxxxxxxxx" <lennon_s_j@xxxxxxxxxxx>]

You need to redefine you JDBC connection to specify System Naming.  You 
will also have to define the library list in the connection, or live 
with whatever is the default library list when the connection is made.

You will need *something like* this to tell JT400 how to connect:

jdbc:as400://your.400.com;libraries=LIB1,LIB2,LIB3;naming=system

Unfortunately I'm at home now so I don't have access to my SQuirrel setup.

Sam

On 3/29/2011 7:28 PM, James Lampert wrote:

> But here's something interesting (in the sense of "May you live in
> interesting times"):

> But if I use SQuirreL SQL (which uses JDBC), any attempt to use the
> functions will result in this:
> > Error: [SQL0204] WTTBLE in *LIBL type *FILE not found.
> > SQLState: 42704
> > ErrorCode: -204
>
> (I also get the same message if I try to use the UDF from STRSQL without
> the *LIBL set properly)
>
> I've tried SET SCHEMA, and that doesn't seem to do a damned thing.
>
> I'd like to have DISPLAYVAL automatically recognize, and use, whatever
> library is used for the data it's being fed.
>
> --
> JHHL