Re: RPG Service programs mapped as SQL Functions

Aha! I haven't spent much time in QSYS2 before. The functions are actually 
in SYSFUNCS, which is a view over SYSROUTINES. What is interesting is the 
rest of the functions in SYSFUNCS. I will have to do some experimentation. 
Thanks! 

On 6/15/05, Rick.Chevalier@xxxxxxxxxxxxxxx <Rick.Chevalier@xxxxxxxxxxxxxxx> 
wrote:
> 
> 
> 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.
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>