We have a column in a table defined as BIGINT. We are adding the replication of it. As part of requirement, the old value of the column is also needed. Would be easier to do via %BEFORE(column_name). But this throws a message "RA MSG 2013 Derived expression contains a reference to a BIGINT column. Help - Description..: Datatype BIGINT is currently not supported in derived expression feature. SHIP_00001 cannot be supported in derived expression"
Why is it useful?
|Who would benefit from this IDEA?||Will help to get the old (before) value for the bignit column along with the current value in the Kafka topic.|
How should it work?
Use the derived expression as:
|Priority Justification||Will help in our use case of gettting old value using %BEFORE.|
|Customer Name||Royal Caribbean Cruises Ltd|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions