RE: RPG Service programs mapped as SQL Functions

I believe table SYSPROCS will give you the information you want.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Tony Carolla
Sent: Wednesday, June 15, 2005 4:19 PM
To: RPG programming on the AS400 / iSeries
Subject: RPG Service programs mapped as SQL Functions


I have created a few SQL Functions, mapped to service programs. Luckily, I
haven't gotten so many as to lose track of them (of course, they are
documented ;-) ). My question is this: Is there a way I can look on my
system, and see a list of SQL Functions that are currently mapped to service
programs, using "CREATE FUNCTION"? I don't see any object that gets created,
so there must be some sort of lookup table?

--
"Enter any 11-digit prime number to continue..."
"In Hebrew SQL, how do you use right() and left()?..." - Random Thought
"If all you have is a hammer, all your problems begin to look like nails"

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.