Adaptive Server Enterprise and Adaptive Server Anywhere are more liberal than ANSI permits on which view definitions are updatable when the WITH CHECK option is not requested.
Adaptive Server Anywhere offers the ANSI_UPDATE_CONSTRAINTS option to control whether updates are restricted to those supported by SQL-92 or a more liberal set of rules.
IQ only permits UPDATE on single-table views that can be flattened. IQ does not support WITH CHECK