SQLJ.REMOVE_JAR

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.

SQLJ.REMOVE_JAR

New to creating UDFs in teradata. Have installed few jar files and could see the jars in the SQLJ.JARS view. Now, trying to remove them using SQLJ.REMOVE_JAR, but getting an error message Call failed 6839: 'REMOVE JAR' operation on 'TESTJARID' not allowed. Referenced by other objects(s). Wondering where the jars referenced and would appreciaye assistance on how to remove them from Teradata DB.


Accepted Solutions

Re: SQLJ.REMOVE_JAR

Found the dependency, Teradata function that refers to the external Jar had to be removed first to remove the jar from the DB.

 

1 ACCEPTED SOLUTION
1 REPLY

Re: SQLJ.REMOVE_JAR

Found the dependency, Teradata function that refers to the external Jar had to be removed first to remove the jar from the DB.