1.1

COMPACTIONTHRESHOLD 80
TIMEINTERVAL 223344
WRITEBUFFERSIZE 19292393
QUEUESIZE 17374
('dir1' 456)
This example specifies multiple storage directories and directory sizes for oplog files:
CREATE DISKSTORE STORE1
WRITEBUFFERSIZE 19292393
QUEUESIZE 17374
('dir1' 456 , 'dir2', 'dir3' 532 )
CREATE FUNCTION
Creates java functions that can be invoked from other SQL expressions.
Syntax
CREATE FUNCTION
function-name on page 467
( [
function-parameter on page 467
[ ,
function-parameter on page 467
] ] * )
RETURNS data-type
[
function-element on page 467
] *
Description
This statement creates java functions that can be invoked from other SQL expressions.
function-name
[ schema-name . ] identifier
A qualified function name cannot use the SYS schema, which is reserved for internal functions.
function-parameter
[ parameter-name ] DataType
function-element
{
LANGUAGE JAVA
| EXTERNAL NAME 'external_name'
| PARAMETER STYLE parameter-style on page 468
| { NO SQL | CONTAINS SQL | READS SQL DATA }
| { RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT }
}
The function elements may appear in any order, but each type of element can only appear once. A function
definition must contain these elements:
• LANGUAGE
• PARAMETER STYLE
467
SQL Language Reference