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