| SQL adaptation guide for IBM Netezza 6.x / Data dictionary | |
When creating a table, Informix® automatically adds a ROWID integer column (applies to non-fragmented tables only). The ROWID column is auto-filled with a unique number and can be used like a primary key to access a given row.
Netezza® implements ROWIDs like Informix, except that the rowids are stored in a 64 bit integer in Netezza.
ROWIDs can be used with Netezza as with Informix, as long as you fetch rowid values into a BIGINT variable. But you should avoid ROWID-based code and use primary key constraints instead.
The SQLCA.SQLERRD[6] register cannot be supported, because Netezza rowids are 64 bit integers (BIGINT) while SQLCA.SQLERRD[6] is a 32 bit integer (INTEGER). Therefore, all references to SQLCA.SQLERRD[6] must be removed because this variable will not contain the ROWID of the last INSERTed or UPDATEd row.