SET COMPATIBILITY

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}

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.

Example:

To specify the DB2 compatibility mode enter the following:

SET COMPATIBILITY DB2