IBM PureData® System for Analytics (Netezza) and Db2 differences in internal data types
Netezza® internal data types, such as ROWID, are supported differently or are unsupported in Db2®.
| Netezza data type | Netezza column name | Db2 support |
|---|---|---|
| rowid | rowid | You can use the ROWID pseudocolumn, which has a VARCHAR (16) FOR BIT DATA data type. ROWID is an alternative to the RID_BIT() function. |
| dataslice | datasliceid | You can use the DATASLICEID pseudocolumn. This column contains the database partition number for a row. The value can be 0. |
| transaction ID | createxid, deletexid | If required, you can use an identity column (hidden, if need be) in your table to provide a unique row identifier. |
| Other types | Other internal data types are not supported. If you need help migrating these to Db2, contact IBM. |