RE: Here function, function, function.

Elvis - thanks for your reply
BINGO, there's my function
MUCH APPRECIATED



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxxxxx
P:(631) 244-2000 ext. 5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 10/08/2008 11:53:18 AM:

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


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.