Is there a Netezza equivalent to the MSSQL ROWVERSION or the Oracle ORA_ROWSCN? Essentially I'd like to know if a record changed and be confident that it changed. Using a checksum isn't reliable 100% of the time.

  • 1
    Sorry for a lame question, but why checksum is not reliable? AFAIK, checksum will be the same only if new values are the same... – Stoleg Nov 27 '13 at 22:10

I'm not sure about the ROWVERSION behaviour, but ORA_ROWSCN I believe would still change if you were to update a row with completely identical values. In other words, the row contents would remain the same but its SCN would be different.

The only practically reliable way to detect the actual change in column values would be to calculate the row checksum or hash.

To answer your question though, consider using the createxid special column in Netezza: http://pic.dhe.ibm.com/infocenter/ntz/v7r0m3/topic/com.ibm.nz.dbu.doc/r_dbuser_data_types_ntz_internal.html

And again, a changed createxid value would not necessarily mean that any column values have changed.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.