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™.
INSERT statementUse the INSERT statement to insert one or more new rows into a table or view, or to insert one or more elements into an SQL or collection variable.
Execute Routine ClauseYou can specify the EXECUTE FUNCTION statement (or the EXECUTE PROCEDURE statement) to insert values that a user-defined function returns

Execute Routine Clause

You can specify the EXECUTE FUNCTION statement (or the EXECUTE PROCEDURE statement) to insert values that a user-defined function returns

Notes:

¹ See Arguments


Element	Description	Restrictions	Syntax
function, procedure	User-defined function or procedure to insert the data	Must exist	Database Object Name

When you use a user-defined function to insert column values, the return values of the function must have a one-to-one correspondence with the listed columns. That is, each return value

must be of a data type the same or compatible with the corresponding column,
and its order among return values must match the column's order in the column list.

For backward compatibility, HCL OneDB™ can use the EXECUTE PROCEDURE keywords to execute an SPL function that was created with the CREATE PROCEDURE statement.

If the called SPL routine scans or updates the target table of the INSERT statement, the database returns an error. That is, the SPL routine cannot select data from the table into which you are inserting rows.

If a called SPL routine contains certain SQL statements, the database server returns an error. For information on which SQL statements cannot be used in an SPL routine that is called within a data manipulation statement, see Restrictions on SPL Routines in Data-Manipulation Statements.