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 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

Must have RESOURCE authority.

External Java functions must have DBA authority.