The SET COMPATIBILITY command is used to specify a mode of operation. When a particular mode is in effect, SQL commands must adhere to the syntax of that mode.
Restriction: This topic applies to Windows environments only.
Invocation
SET COMPATIBILITY is an executable XDB Server utility command that can be issued interactively or embedded in a host language. SET COMPATIBILITY can be dynamically prepared.
Authorization
No special authorization is required to specify an XDB Server compatibility mode.
Syntax
SET COMPATIBILITY {DB2 | XDB | ANSI}
Example:
To specify the DB2 compatibility mode enter the following:
SET COMPATIBILITY DB2
Description
This command allows compatibility to change dynamically so you can mix compatible commands only available in certain modes within a particular program. (The functionality of this command is identical to the DB2 command SET CURRENT RULES.) This is useful within an application that executes predominantly in one mode, but in which you need to change to another mode for a particular operation.