SQL_COMPAT global variable

This built-in global variable specifies the SQL compatibility mode. Its value determines which set of syntax rules are applied to SQL queries.

This global variable has the following characteristics:
  • It is a read/write variable, with values maintained by the user.
  • The type is VARCHAR(3).
  • The schema is SYSIBM.
  • The scope of this global variable is session.
  • It has a default value of NULL.
This global variable must have a value of NULL, 'DB2', or 'NPS', or 'ORA' (SQLSTATE 42815).
NULL
The default setting ('DB2') is used.
'DB2'
Db2® syntax rules are applied to SQL queries.
'NPS'
Netezza syntax rules are applied to SQL queries. If you use this setting, some SQL behavior will differ from what is documented in the SQL reference information. To determine the potential effects of a compatibility feature on your SQL applications, see Compatibility features for NetezzaCompatibility features for Netezza Compatibility features for Netezza.
'ORA'
Oracle syntax rules are applied to SQL queries. If you use this setting, some SQL behavior will differ from what is documented in the SQL reference information. To determine the potential effects of a compatibility feature on your SQL applications, see Compatibility features for Oracle.