Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE FUNCTION statementUse the CREATE FUNCTION statement to create a user-defined function, to register an external function, or to write and register an SPL function.
Privileges necessary for using CREATE FUNCTIONYou must hold the Resource privilege or the DBA privilege on a database to create a function within that database.

Privileges necessary for using CREATE FUNCTION

You must hold the Resource privilege or the DBA privilege on a database to create a function within that database.

Before you can create a function, you must also hold the Usage privilege on the programming language in which the function is written. The GRANT USAGE ON LANGUAGE statement can specify the SPL, C, or Java™ language when it grants a language-level privilege to a user or to a role. For more information, see Language-Level Privileges.

By default, Usage privilege on SPL is granted to PUBLIC.

To register functions in the C or Java external programming languages, you must also hold the built-in EXTEND role, unless the IFX_EXTEND_ROLE configuration parameter is set to 0 or to Off.