Installing a Java JAR File into an SAP Sybase IQ Database

Install a Java JAR file to an SAP Sybase IQ database. 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 You must have DBA authority.
SAP Sybase IQ 16.0 You must have the MANAGE ANY EXTERNAL OBJECT system privilege.
Task

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

  1. From the application menu bar, select View > Open > Administration Console.
  2. In the left pane, expand IQ Servers > Compiled Objects > External Environments > Java, and then select JAR.
  3. Click the arrow beside JARs and select New.
    The Install JARs wizard appears.
  4. On the Welcome page, specify:
    Option Description
    Select an SAP Sybase IQ resource on which the JAR file will be installed: Select an SAP Sybase IQ resource from the list.
    (Multiplex only) Select a multiplex server on which the JAR 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.
    JAR file path Enter the path to the JAR file. It must be on a file system accessible to the SAP Sybase IQ resource
    JAR name Enter a unique name for the JAR file.
    Comment (Optional) Enter a comment describing the class or JAR.
  5. Click Next.
  6. On the Select Classes page, select all classes or a subset of the classes to install from the JAR.
  7. Click Finish to install the class or JAR.
Related tasks
Installing a Java Classes File into an SAP Sybase IQ Database
Updating a Java Classes File
Deleting a Classes File
Viewing or Modifying Java Classes File Properties
Updating a Java JAR File
Deleting a JAR File
Viewing or Modifying the Java JAR File Properties
Testing the Configuration of a Java External Environment
Viewing or Modifying Java External Environment Properties
Authenticating a Login Account for a Managed Resource
Registering and Authenticating an SAP Control Center Agent
Related reference
Java External Environment Privilege Summary