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
How to create a trigger
Declare a trigger name

Declare a trigger name

The trigger name identifies the trigger, and must be unique among trigger names within the database. The trigger name follows the words CREATE TRIGGER in the statement. Like any SQL identifier, can be up to 128 bytes in length, beginning with a letter and consisting of letters, digits, and the underscore ( _ ) symbol. In the following example, the portion of the CREATE TRIGGER statement that is shown declares the name upqty for the trigger:

CREATE TRIGGER upqty       -- declare trigger name