Compatibility features for Netezza Platform Server (NPS)

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

Several NPS compatibility features are always active. For information about these features, see Compatibility features that are always active.

In addition to the NPS compatibility features that are now generally available in Big SQL, you can use the SQL_COMPAT global variable to activate the following custom NPS compatibility features:
  • 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 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, you can use the NZPLSQL language in addition to the SQL PL language.