CREATE FUNCTION Statement (Java UDF)

Creates a new external Java table UDF function in the database.

Syntax

CREATE [ OR REPLACE | TEMPORARY ] FUNCTION [ owner.]function-name  ( [ parameter, … ] )
 RETURNS data-type routine-characteristics
 [ SQL SECURITY { INVOKER | DEFINER } ]
 { compound-statement
  | AS tsql-compound-statement
  | EXTERNAL NAME 'java-call' LANGUAGE JAVA }

Parameters

parameter – IN parameter-name data-type [ DEFAULT expression ]
routine-characteristics – ON EXCEPTION RESUME | [ NOT ] DETERMINISTIC
tsql-compound-statement – sql-statement sql-statement …
environment-name – JAVA [ ALLOW | DISALLOW SERVER SIDE REQUESTS ]
java-call – '[ package-name.]class-name.method-name method-signature'
method-signature – ( [ field-descriptor, ….] ) return-descriptor
field-descriptor and return-descriptor – Z | B | S | I | J | F | D | C | V | [ descriptor | L class-name;

Examples

Example 1 – Create an external function written in Java:

CREATE FUNCTION dba.encrypt( IN name char(254) )
RETURNS VARCHAR 
EXTERNAL NAME
'Scramble.encrypt (Ljava/lang/String;)Ljava/lang/String;'
LANGUAGE JAVA

Usage

LONG BINARY and LONG VARCHAR are not permitted as return-value data types.

EXTERNAL NAME LANGUAGE JAVA—A function that uses EXTERNAL NAME with a LANGUAGE JAVA clause is a wrapper around a Java method.

iq-environment-name: JAVA [ ALLOW | DISALLOW SERVER SIDE REQUESTS ]:

DISALLOW is the default.

ALLOW indicates that server-side connections are allowed.

Note: Do not specify ALLOW unless necessary. A setting of ALLOW slows down certain types of SAP Sybase IQ table joins.

Do not use UDFs with both ALLOW SERVER SIDE REQUESTS and DISALLOW SERVER SIDE REQUESTS in the same query.

Standards

SQL—ISO/ANSI SQL compliant.
Sybase—Not supported by Adaptive Server Enterprise.

Permissions

For function to be owned by self – Requires the CREATE PROCEDURE system privilege

For function to be owned by any user – Requires one of:

CREATE ANY PROCEDURES system privilege.
CREATE ANY OBJECT system privilege.

To create a function containing an external reference, regardless of whether or not they are the owner of the function, also requires the CREATE EXTERNAL REFERENCE system privilege.