UPDATETIME

Determines which timestamps are sent by the source for the &TIMSTAMP journal control field for the before and after images of an update.

If UPDATETIME=BEFORE, both the before and after image of an update will have &TIMSTAMP equal to the time that the before image was deleted from the table. &TIMSTAMP for the before and after image of an update will therefore always be the same.

If UPDATETIME=AFTER, both the before and after image of an update will have &TIMSTAMP equal to the time that the after image was written to the table. &TIMSTAMP for the before and after image of an update will therefore always be the same.

If UPDATETIME=BOTH, the before image will have &TIMSTAMP equal to the time that the before image was deleted from the table and the after image will have &TIMSTAMP equal to the time that the after image was written to the table. &TIMSTAMP for the before and after images, therefore, may be the same or they may be different. This is the legacy behaviour.

This keyword is optional.

Default Setting—AFTER