How do I list the installed jar files inside Teradata Database?

Database
Enthusiast

How do I list the installed jar files inside Teradata Database?

Where the installed jar files stored inside Teradata? Is there any querry to find the installed jar files in teradata?

Tags (1)
4 REPLIES
Teradata Employee

Re: How do I list the installed jar files inside Teradata Database?

Jar files are listed in the SQLJ.JARS view. This information is documented in the Teradata Database "Data Dictionary" Reference.

Enthusiast

Re: How do I list the installed jar files inside Teradata Database?

How to delete the DBC.JARS tables ? From which user i need to login?  @tomnolan

Teradata Employee

Re: How do I list the installed jar files inside Teradata Database?

DBC.JARS is a Data Dictionary view, and you are not permitted to delete rows directly from the underlying Data Dictionary table.

In order to remove a Jar file from your Teradata Database, you must call the built-in stored procedure SQLJ.REMOVE_JAR.

This is documented in the Teradata Database Reference book "SQL External Routine Programming", Chapter 8 "Administration", section "Removing Registered JAR or ZIP Files".

Enthusiast

Re: How do I list the installed jar files inside Teradata Database?

@tomnolan friend thank you so much for the reply, I got this.