SAP Sybase IQ supports referential integrity with RESTRICT action (the ANSI default) at the statement level.
This means that SAP Sybase IQ denies requests for updates and deletes on a primary key or any column with a unique constraint that removes any value upon which correspondent foreign keys depend. (You must carefully consider the order in which you request deletes and updates.) SAP Sybase IQ issues an error message and rolls back load operations that violate referential integrity, but does allow you to specify that certain rows can be ignored.