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:


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