Creating an External Java Function

Set up a new external Java function on a Sybase IQ server.

Prerequisites

Authenticate with Sybase IQ using an account that has DBA authority.
(Optional) Install the required Java classes and JAR files in the database. (You can create the function if the classes and JAR files are not installed, but Sybase IQ cannot execute the function.)

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Other Objects.
Select Functions, click the drop-down arrow that appears to the right, and select New.
In the Create Function wizard, select the Sybase IQ server on which the function is to reside.
Select a user or group to own the function.
Enter a name for the function.
Select the External Java function type.
Check Use SQL template to insert a hardcoded SQL template and skip the wizard page for specifying the return type.
If you chose not to use the SQL template, define a return variable on the Specify Return Type page.
On the SQL page, edit the code provided by the wizard.
1. Define input parameters: name, type, and default value.
2. If you chose to use the SQL template, replace the placeholder external name at the end of the query with a real name that follows the format of the placeholder.
3. Make any other changes needed to complete your function.
(Optional) Enter a comment describing the function.
Comments can include both HTML and Javadoc tags, so you can incorporate them into your generated database documentation.
Click Finish to save the function.

The new function appears in the Functions list in the right pane of the Administration Console.