3,812
What could cause DEX_ROW_TS to be updated for many records at once in IV00101 table? for example 3000 records have exactly same value in DEX_ROW_TS. The MODIFDT field has not changed. It does not seem to be due to manual editing. and it is strange they all have exactly same value in DEX_ROW_TS
Din,
Agree with David, any integration that would have updated the IV00101 table in SQL would have caused to trigger the DEX_ROW_TS timestamp field, as long as the row as affected by it.
Did you run some sort of update statement. .... even if it updated to the same value, it would cause the trigger that updates the timestamp to run.
If performed at the SQL level it would have all been one transaction which would give everything the same datetime value.
If the update had a where clause so it only updated records that needed changing, it would not have been so heavy handed.
That's my thoughts.
David
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (