RE: SQL UDFS

["Wintermute, Sharon" <Sharon.Wintermute@xxxxxxxxxxxxxxxx>]

It called an rpgle service program.  It appears someone dropped it. 


Sharon Wintermute
Sr. Software Engineer - Application Solutions
YRC Logistics
913.906.4309

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of sjl
Sent: Thursday, February 04, 2010 11:49 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL UDFS

Sharon -

1) What kind of SQL function was it?  Was it native or did it call an
HLL 
program?

2) Did someone DROP the function or (If it called an RPG program for 
example) did someone delete the program object.

- sjl


"Wintermute, Sharon" <Sharon.Wintermute@xxxxxxxxxxxxxxxx> wrote in
message 
news:mailman.6485.1265304322.2580.midrange-l@xxxxxxxxxxxxxxx


In the IBM documentation it states:



SQL objects are schemas, journals, catalogs, tables, aliases, views,
indexes, constraints, triggers, sequences, stored procedures,
user-defined functions, user-defined types, and SQL packages. SQL
creates and maintains these objects as system objects.



How do I audit these system objects?  Someone deleted a UDF causing
havoc and now I need to figure out how to capture that.



TIA,





Sharon Wintermute