Installing a Java Classes File into an SAP Sybase IQ Database

Install a Java classes file to an SAP Sybase IQ database using Sybase Control Center. This enables the database to execute functions and procedures written in Java.

Prerequisites

Database Version	External Environment – Java Privileges
SAP Sybase IQ 15.3 and 15.4	Requires DBA authority.
SAP Sybase IQ 16.0	Requires MANAGE ANY EXTERNAL OBJECT system privilege.

The SAP Sybase IQ resource is authenticated and running.
Copy the Java classes file to a location accessible to the SAP Sybase IQ server.

Task

A Java external environment appears in the list of external environments in the Sybase Control Center Administration Console even when none of its classes files have been installed.

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Compiled Objects > External Environments > Java > Classes.
Click the arrow beside Classes and select New.
The Install Java Classes wizard appears.

On the Welcome page, specify:

Option	Description
Select a Sybase IQ resource on which the Java class will be installed:	Select an SAP Sybase IQ resource from the list.
(Multiplex only) Select a multiplex server on which the Java class will be installed	Select a multiplex server from the list.
SCC agent status	Indicates the current status of the SCC agent. If the SCC agent is not registered, click Register Agent and enter the required registration information. If the SCC agent is not authenticated, click Authenticate Agent. Enter a user ID, password, and port for SCC to use when it logs in to the SCC agent.
Java class file path	Enter the path to the Java class file. It must be on a file system accessible to the SAP Sybase IQ resource.
Comment	(Optional) Enter a comment describing the class.

Click Finish to install the class.