Home
SQL programmingYou can use the HCL Informix® implementation of the SQL language to develop applications for Informix® database servers.
Guide to SQL: TutorialThe Informix® 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

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.