RE: SQL - List of Stored Procedures and UDFs

Gary,

This is excellent!

Thanks

Adam Driver
IBM Certified Systems Administrator - System i
Consultant - Infrastructure Technician
Exacta Corporation
608.661.6697 ext 2581
adriver@xxxxxxxxxxxx<mailto:adriver@xxxxxxxxxxxx>
Please consider your environmental responsibility before printing this e-mail.


date: Thu, 16 Feb 2012 13:47:16 +0000

from: Gary Thompson <gthompson@xxxxxxxxxxx<mailto:gthompson@xxxxxxxxxxx>>

subject: RE: SQL - List of Stored Procedures and UDFs



I have used the following with some success;

maybe others can offer suggestions to improve it:



SELECT CAST(routine_name AS CHAR(15)) AS Name,

CAST(routine_schema AS CHAR(10)) AS Library,

routine_type AS Type,

CAST(routine_definer AS CHAR(10)) AS Created_By,

function_origin AS Origin,

routine_definition AS Source_Code

FROM qsys2/sysroutines

WHERE routine_definer NOT IN ('QSYS', 'QLPINSTALL', 'QDIRSRV')

AND ( ( routine_type = 'FUNCTION' ) AND

(function_origin NOT IN ('B')) OR

(routine_type = 'PROCEDURE')

)



[Like us on Facebook!]<http://on.fb.me/t7A5KE>

- WEA Trust Confidentiality Notice -

This electronic mail message and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Dissemination, forwarding, printing, or copying of this electronic mail without the consent of the sender is strictly prohibited. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error; please immediately notify the sender by return mail.