Compatibility features for Netezza Platform Software (NPS)

Db2® Big SQL provides features that enable applications that were written for a Netezza® Platform Software (NPS®) database to use Db2 Big SQL with only minor modifications.

Several NPS compatibility features are always active. For information about the features that are always active in the IBM® Common SQL Engine, see Compatibility features that are always active.

In addition to the NPS compatibility features that are now generally available in Db2 Big SQL, you can use the SQL_COMPAT global variable to activate the following custom NPS compatibility features:

When operating in NPS compatibility mode, you can specify the exposed name of a SELECT clause column in the HAVING clause of a query.
You can use double-dot notation to specify a database object.
The TRANSLATE scalar function syntax and semantics in NPS compatibility mode are different than those in Db2 Big SQL.
Which symbols are used to represent operators in expressions depends on whether NPS compatibility mode is being used.
When operating in NPS compatibility mode, you can specify the ordinal positions or exposed names of SELECT clause columns when grouping the results of a query.
When operating in NPS compatibility mode, an expression can refer to column aliases that are set in the select list.
When operating in NPS compatibility mode, the AS clause of a CREATE TABLE statement can use the same syntax as the corresponding clause of a Netezza CREATE TABLE AS command (sometimes referred to as a CTAS command).
When operating in NPS compatibility mode, the SUBSTR scalar function allows the start value to be negative, zero, or positive.
When operating in NPS compatibility mode, the AGE scalar function returns a decimal duration instead of an integer value.
When operating in NPS compatibility mode, you can use the NZPLSQL language in addition to the SQL PL language.

Restrictions

Netezza style external tables are not supported in Db2 Big SQL.