Oracle (Sun) JDK 6.0 and JDK 7.0 include the Apache Derby database, which is implemented in 100% Java.
This article is not about the Apache Derby database; instead, this is about a command-line interactive SQL tool that is included with Apache Derby.
The Apache Derby "ij" interactive SQL tool is quite useful. It is a command-line SQL tool similar to BTEQ, and it works with any JDBC Driver and any database, not just the Apache Derby database.
The following instructions show how to use the ij tool with the Teradata JDBC Driver.
First, you need to have a JDK installed (not just a JRE) that includes the Apache Derby jar files. The Apache Derby jar files are typically located in the db/lib directory under the main JDK install directory. (Note that some builds of JDK 6.0 have problems with installing the Apache Derby files.)
Second, you need to have the Teradata JDBC Driver jar files terajdbc4.jar and tdgssconfig.jar available.
Assuming that your JDK 6.0 or 7.0 is installed in directory c:\jdk and that your Teradata JDBC Driver jar files are located in c:\terajdbc