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.
Other syntax segmentsThese topics describe syntax segments, which are language elements, such as database object names or optimizer directives, that appear as a subdiagram reference in the syntax diagrams of some SQL or SPL statements.
Routine modifier A routine modifier specifies characteristics of how a user-defined routine (UDR) behaves.
Modifier Descriptions
COSTFUNC (C)Use the COSTFUNC modifier to specify the cost of a UDR. The cost of the UDR is an estimate of the time required to execute it.

COSTFUNC (C)

Use the COSTFUNC modifier to specify the cost of a UDR. The cost of the UDR is an estimate of the time required to execute it.

Occasionally, the cost of a UDR depends on its inputs. In that case, you can use a user-defined function to calculate a cost that depends on input values.

To execute cost_func, you must have Execute privilege on it and on the UDR.