trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Venkat Muthuswamy <venkat.muthusw...@esgyn.com>
Subject RE: What functions or procedures are used by a library?
Date Tue, 02 Jan 2018 22:03:14 GMT
Dave,

Yes, there is. 

GET PROCEDURES FOR LIBRARY SCH.LIB1
GET FUNCTIONS FOR LIBRARY SCH.LIB1

Regards
Venkat

-----Original Message-----
From: Dave Birdsall [mailto:dave.birdsall@esgyn.com] 
Sent: Tuesday, January 2, 2018 1:50 PM
To: dev@trafodion.apache.org
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

Mime
View raw message