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 TRIGGER statementUse the CREATE TRIGGER statement to define a trigger on a table. You can also use CREATE TRIGGER to define an INSTEAD OF trigger on a view.
UDRs that EXECUTE PROCEDURE or EXECUTE FUNCTION callA Select trigger is activated by a UDR if the UDR contains a SELECT statement within its statement block that queries the table, and the UDR is called by an EXECUTE PROCEDURE or the EXECUTE FUNCTION statement.

UDRs that EXECUTE PROCEDURE or EXECUTE FUNCTION call

A Select trigger is activated by a UDR if the UDR contains a SELECT statement within its statement block that queries the table, and the UDR is called by an EXECUTE PROCEDURE or the EXECUTE FUNCTION statement.

For example, assume that an enabled Select trigger is defined on the table tab1, and that the user-defined routine named my_rtn contains the following SELECT statement in its statement block:

SELECT col1 FROM tab1;

Now suppose that the following statement invokes the my_rtn routine:

EXECUTE PROCEDURE my_rtn();

This statement activates the Select trigger defined on column col1 of table tab1 when the SELECT statement within the statement block is executed.