Frequently Asked Questions about Teradata Tools and Utilities.

Expand All The Latest
Question: How do I get Access to Java External Stored Procedures in Teradata 12.0 Express

Assuming you Installed the Sun JRE as part of your Teradata 12.0 Express Environment, you may need to configure this.

Within your TD12 environment open up a Teradata Command prompt and use "cufconfig" with the -o (output to screen) option.

Check if the JREPath is set in a manner similar to that below.

(more...)

Question Detail: While you need a Java Development Kit (JDK) to compile and JAR (Java ARchive) Java External Stored Procedures (JXSP's) within your development environment you also need to ensure that the Teradata Java Runtime Environment (JRE) is installed within the TD12+ environment upon which you wish to install and run the resultant JAR files.
Answer:

Assuming you Installed the Sun JRE as part of your Teradata 12.0 Express Environment, you may need to configure this.

Within your TD12 environment open up a Teradata Command prompt and use "cufconfig" with the -o (output to screen) option.

Check if the JREPath is set in a manner similar to that below.

JavaLibraryPath: C:\Program Files\NCR\Tdat\tdconfig\jarlib\
JREPath: C:\Program Files\Teradata\TDJRE\12.00.00.00\
JavaLogPath: c:\Temp\
JavaEnvFile:
JavaServerTasks: 20
JavaVersion: 0x10004
JavaBaseDebugPort: 8000
JSVServerMemPath: C:\Program Files\NCR\Tdat\TdTemp\jsvsrv\
MallocLimit: 33554432

If JREPath is empty or points to a non existent directory, you will need to install TDJRE.

Go back to your Teradata 12.0 Express Instalation CD/Download and run setup.exe again to get to the Install Additional Sfotware page.

Teradata Express - Install Additional Server

Once you can see that TDJRE is installed you need to let the database know where it is.

One approach is to set the Environment Variable (Start -> Control Panel -> System -> Advanced -> Environment Variables) TD_JAVA_HOME to the address of the corresponding installed JRE (like C:\Program Files\Teradata\TDJRE\12.00.00.00) then run "cufconfig -i -o" (remember to open a new Teradata command prompt to let new Environment Variables get loaded).

Alternatively you can create a small text file within the working directory of the Teradata command prompt, say setJRE.txt and insert the lines:

JREPath: C:\Program Files\Teradata\TDJRE\12.00.00.00\

Then use "cufconfig -f setJRE.txt" to change the JREPath value.

If the JavaBaseDebugPort does not have a reasonable value (say 8000) you can repeat this process with a line like:

JavaBaseDebugPort: 8000

Once the configuration presented by "cufconfig -o" matches your physical configuration restart the DBS with "tpareset -f be".

Question: Why can't I get Java External Stored Procedures (JXSP) to work on my Laptop

If you are using a 32bit Operating System then the installation process for Teradata 12.0 Express will not install the SQLJ capability as Java and SQLJ are only supported on 64bit. However, it is possible to override the default behaviour (but remember NOT Supported).

(more...)

Question Detail: I have Teradata 12.0 Express installed on my laptop but when I try and do any of the Java External Stored Procedures tutorials it says that SQLJ is missing.
Answer:

If you are using a 32bit Operating System then the installation process for Teradata 12.0 Express will not install the SQLJ capability as Java and SQLJ are only supported on 64bit. However, it is possible to override the default behaviour (but remember NOT Supported).

My personal cheat sheet for this reads as follows:

Start -> Teradata Database -> Teradata Command Prompt
dbscontrol
mod int = true
mod int 119=2
write
quit

Start -> Teradata Database -> Database Window -> Supvr
In the Supvr Window.
start DIP
<Your DBC Password>
14 (for DIPSQLJ)
N

When you explore your Database in Teradata IDE you should now see the SQLJ schema and it's Stored Procedures and Views.

SQLJ Schema

Tags: Java External Stored Procedures JXSP SQLJ Teradata 12.0 Express