jdbc update_insert want to update date create or update date

[katie_doody2]

Hi, I am using jdbc to successfully update and insert three relational tables. I am trying to figure out how I can know whether it is an update or insert. I noticed I am updating both the create date column and update column with the same values. I would like to update the create date only on insert and the update date only upon update.

Thanks,

Katie

[engswee · Accepted solution]

Hi Katie

If you are using an UPDATE_INSERT statement for your JDBC receiver channel, then the determination of whether it is an UPDATE or an INSERT is at the database level and will not be visible to PI.

If there's no way to determine if it is an UPDATE or INSERT from the sender side, then one option would be to perform a relevant SELECT statement via a JDBC Lookup during Message Mapping.

Regards

Eng Swee