RE: RPG Service programs mapped as SQL Functions

Tony,

SQL statement:

Select * from sysfuncs

Will show all functions 

Select * from sysprocs

Will show all stored procedures

Cheers
Colin.W

http://as400blog.blogspot.com 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tony Carolla
Sent: 15 June 2005 22:19
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?