RE: Here function, function, function.

This SQL statement gives you all UDFs (well, barring any iASP complications;
iASP denotes a separate database on System i and has its own catalogues [I
think, don't have iASPs to test with])

SELECT * FROM QSYS2/SYSFUNCS;

As for Navigator, I believe you can only look at one schema (library) at a
time. Go to Databases-->right-click on Schemas-->Select Schemas to
Display-->add schemas (libraries) you want to look at-->expand the schema
you're interested in-->Functions.

Hth, Elvis


Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Re: Here function, function, function.

Thanks for your e-mail
This shows me that the particular Function does exist, however, what I was
hoping to see was somehow to list ALL functions. Unfortunately there was no
type displayed with that function.
I need some method to display ALL functions

Alan Shore