Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

File IO Status Record Has Changed

edited Oct 30, 2018 2:17PM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered

I have a question about File_IO_Status RECORD_HAS_CHANGED.

I found the following in the Oracle documentation (647066.1):

NOTE: The check box for "Check for Record Change" in the Update operation will inform you if the record has been changed between the time the record was fetched and the time it has been updated.

I have an update statement where I have the "Check for Record Change" option set. I thought that if I did an "if SV File_IO_Status is equal to CO RECORD_HAS_CHANGED" after the update that I would be able to detect when it skipped updating a record because it detected that the record changed after the select happened. But, that doesn't seem to be happening.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center