Re: More SQL UDF help -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.