Creating an External Java Function

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

Prerequisites

Database Version	Function Privileges
SAP Sybase IQ 15.3 and 15.4	External Java function to be owned by self or any user – Requires DBA authority.
SAP Sybase IQ 16.0	External Java function to be owned by self – Requires all of: CREATE PROCEDURE system privilege. CREATE EXTERNAL REFERENCE system privilege. External Java function to be owned by any user – Requires CREATE EXTERNAL REFERENCE system privilege. Also requires one of: CREATE ANY PROCEDURE system privilege. CREATE ANY OBJECT system privilege.

The SAP Sybase IQ resource is authenticated and running.
(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 SAP Sybase IQ cannot execute the function.)

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Compiled Objects > Functions.
Click the arrow next to Functions and select New.
The Create Function Wizard appears.

On the Welcome page, specify:

Option	Description
Select a resource for which the function will be created	From the list, select the resource for which the function will be created.
Which user or group/role do you want to own the function?	From the list, select the user or role/group to own the function.
What do you want to name the function?	Enter a unique name for the new function; maximum of 128 characters.
Which SQL dialect or language do you want to use?	Select External Java.
Use SQL template	(Optional) Select to insert a hardcoded SQL template and skip the wizard page for specifying a return type. You can also set a Watcom SQL function to be deterministic or nondeterministic.

Click Next.
If you chose to use the SQL template, skip to step 8. Otherwise, on the Specify Return Type page, select the type of value to return and define a name for the return variable.
Click Next.
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.
4. (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.