Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Create and use triggers
Select triggers
SELECT statements that execute triggered actions
Views

Views

Select triggers execute a triggered action for views whose base tables contain a reference to a triggering column. You cannot, however, define a Select trigger on a view.

Suppose you create the following view:

CREATE VIEW view_tab AS
   SELECT * FROM tab_a;

The following statements execute a triggered action on the hits_trig trigger for each instance of a row that the view returns:

SELECT * FROM view_tab;

SELECT col_a FROM tab_a;