Creating a Table UDF or Table Parameterized Function

Set up an external table-valued user-defined function or table parameterized function in C/C++ or an external table-valued user-defined function in Java on a Sybase IQ server.

Prerequisites

Authenticate with Sybase IQ using an account that has DBA authority.
(Optional) If you are creating a Java procedure, install the required Java classes and JAR files in the database. (You can create the procedure if the classes and JAR files are not installed, but Sybase IQ cannot execute the procedure.)
(Optional) If you are creating a C/C++ procedure, copy the library that contains the procedure to a location accessible to the Sybase IQ server. (You can create the procedure if the library is not accessible to Sybase IQ, but Sybase IQ cannot execute the procedure.)

Task

For detailed information on UDFs, see User-Defined Functions in the Sybase IQ documentation set.

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Other Objects.
Select Procedures, click the drop-down arrow that appears to the right, and select New Table UDF/TPF.
In the Create Table UDF/TPF wizard, select the Sybase IQ server on which the procedure is to reside.
Select a user or group to own the procedure.
Enter a name for the procedure.
Select the type of procedure to create.
Check Use SQL template if you want the wizard to provide comments with syntax examples to help you define parameters and results. Leave the box unchecked if you want to use the Return Structure page to define the result.
If you chose not to use the SQL template, define the result on the Return Structure page.
On the SQL page, edit the code provided by the wizard.
1. Define input parameters using the format provided.
2. 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 procedure.
(Optional) Enter a comment describing the procedure.
Comments can include both HTML and Javadoc tags, so you can incorporate them into your generated database documentation.
Click Finish to save the procedure.

The new procedure appears in the Procedures list in the right pane of the Administration Console.