You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by Dave Birdsall <da...@esgyn.com> on 2018/01/02 21:50:22 UTC

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

RE: What functions or procedures are used by a library?

Posted by Dave Birdsall <da...@esgyn.com>.
Thanks, Venkat.

-----Original Message-----
From: Venkat Muthuswamy [mailto:venkat.muthuswamy@esgyn.com] 
Sent: Tuesday, January 2, 2018 2:03 PM
To: dev@trafodion.apache.org
Subject: RE: What functions or procedures are used by a library?

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

RE: What functions or procedures are used by a library?

Posted by Venkat Muthuswamy <ve...@esgyn.com>.
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