Db2 11.1 provides features that enable applications that were written for a Netezza Platform Software (NPS) database to use a Db2 database, without having to be rewritten. To activate fully fledged NPS compatibility features, including the optional features, set the SQL_COMPAT global variable to NPS:
SET SQL_COMPAT='NPS'
The following table shows optional compatibility features for Netezza:
|
Feature |
Format |
NPS Interpretation |
|
Double-dot notation |
<NPS_DB>..<NPS_Object> |
<Schema>.<Object> |
|
Translate Scalar Function Syntax |
translate('12345', '143', 'ax') |
a2x5 |
|
Operators |
^ and ** |
Exponential Operators |
|
Grouping by SELECT clause columns |
SELECT c1 AS a, c2+c3 AS b, COUNT(*) AS c FROM t1 GROUP BY 1, 2; |
Can specify the ordinal position or exposed name... |
