ANSI-compliant databases

Use the MODE ANSI keywords when you create a database to designate it as ANSI compliant. Within such a database, certain characteristics of the ANSI/ISO standard apply. For example, all actions that modify data take place within a transaction automatically, which means that the changes are made in their entirety or not at all. Differences in the behavior of ANSI-compliant databases are noted, where appropriate, in the statement descriptions in the HCL OneDB™ Guide to SQL: Syntax. For a detailed discussion of ANSI-compliant databases, see the HCL OneDB Database Design and Implementation Guide.