Ok. Now I have working scalar UDFs to implement my "Display Value"
conversion, and I've even got a VIEW that incorporates a call to it.
But here's something interesting <<SNIP UDF CREATE statements>>
If I call the DISPLAYVAL function from either a stored procedure
called from STRSQL, or a SELECT statement executed in STRSQL, or by
opening the aforementioned VIEW from STRSQL, I get the expected (and
desired) results, as long as WTFLDD and WTTBLE exist somewhere in my
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.