Dave, Yes, there is.
GET PROCEDURES FOR LIBRARY SCH.LIB1 GET FUNCTIONS FOR LIBRARY SCH.LIB1 Regards Venkat -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Tuesday, January 2, 2018 1:50 PM To: [email protected] Subject: What functions or procedures are used by a library? Hi, If I try to drop a library that has UDRs defined on it, the DROP LIBRARY will fail with SQL error 1366. All well and good. I can figure out what UDRs are defined on it by joining the metadata ROUTINES table to the metadata LIBRARIES table on ROUTINES.LIBRARY_UID = LIBRARIES.LIBRARY_UID, and placing an appropriate predicate on the column LIBRARIES.LIBRARY_FILENAME. But I'm wondering if there is a simple utility that would do this for me? Something like GET ROUTINES ON LIBRARY x? Thanks, Dave
