Usage
Creates a data transformation method, a procedure that changes the source data as it is being distributed to accommodate the needs and requirements at target servers.
Syntax
CREATE METHOD method-name FUNCTION function-name
LANGUAGE JAVA_LANGUAGE
[ARGUMENTS ( [optname] java-data-type, ...)]
RETURNS sql-data-type
[BODY ‘body of method-embed single quotes by doubling; use ^^ for CRLF’]
[DESCRIPTION ‘descriptive text’]
;The available Java datatypes are:
-
BOOLEAN
-
CHAR
-
DECIMAL (m, n)
-
DOUBLE
-
INTEGER