Creating an External C/C++ Scalar or Aggregate Function

Set up a new external C or C++ aggregate function on a Sybase IQ server.

1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
2. In the Administration Console, expand IQ Servers > Other Objects.
3. Select Functions, click the drop-down arrow that appears to the right, and select New.
4. In the Create Function wizard, select the Sybase IQ server on which the function is to reside.
5. Select a user or group to own the function.
6. Enter a name for the function.
7. Select the C/C++ scalar or aggregate function type.
8. Check Use SQL template to insert a hardcoded SQL template and skip the wizard pages for defining the return variable, function attributes, and clauses.
9. If you chose not to use the SQL template, define a return variable on the Specify Return Type page.
10. If you chose not to use the SQL template, configure the attributes of the function, including the names of its shared library file and descriptor function, on the Function Attributes page.
11. If you chose not to use the SQL template, configure clauses that control windows on the Function Clauses page.
12. 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 of the form functionDescriptorName@libraryName.
    3. Make any other changes needed to complete your function.
13. (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.
14. Click Finish to save the function.