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.
Modify data
Data integrity
Object modes and violation detection
Example of modes with data manipulation statements
Results of the insert operation when the constraint is disabled

Results of the insert operation when the constraint is disabled

If the NOT NULL constraint on the cust_subset table is disabled, the INSERT statement that user linda issues successfully inserts the new row in this table. The new row of the cust_subset table has the following column values.


ssn	fname	lname	city
973824499	jane	NULL	los altos