Qualified object name UDFFIXSTRING not valid.

[ddiamond]

I have a user-defined function on the AS400 in a library called ddiamond.

If I login as pddiamond, and then run the following:

select 
  dxnacd,                 
  ddiamond.udfFixString(dxnae3)
from zndxdf00

I get the error message: Qualified object name UDFFIXSTRING not valid.

If I instead add ddiamond to my library list and then run

select 
  dxnacd,                 
  udfFixString(dxnae3)
from zndxdf00

It works fine. Does anyone know why I cannot qualify the udf?

 

[blom0344]

ddiamond,

I have no direct solution, but it is comparable with the situation when I try to compile a AS400 that I have build with STRPDM (Program Development Manager)
The files themselves are build with STRPDM (not with SQL) and take the field definitions from a seperate source file in another library.
I cannot compile any file build with STRPDM if I do not add the library that stores the source definition to my library list.

My (feeble)guess is that you need to permanently add the library to the library-list of all people that should work with it.

I'll ask my AS400 DBA co-worker tomorrow



Ties Blom
Information analyst

 

[ddiamond]

Thanks Ties Blom. Please let me know what your co-worker says. I'd loved to avoid permanently adding the library to everyone who needs to use my UDF if possible.

Another problem I've been having - anytime I recompile a UDF, all other dependant UDFs become invalid and I have to recompile them as well. Is that just the nature of the AS400, or is there a way to avoid this. Is it considered a good idea not to call UDFs from within other UDFs?