GETNETCHANGES | IGNORENETCHANGES
Valid for
Extract
Description
Use GETNETCHANGES
to retrieve fields that were changed in a particular update record, plus the primary key. Use IGNORENETCHANGES
to output all fields, changed or not.
GETNETCHANGES
remains in effect until IGNORENETCHANGES
is entered. Once entered, IGNORENETCHANGES
remains in effect until GETNETCHANGES
is entered.
GETNETCHANGES
guarantees that only changed records are retrieved. Compressed update records do not guarantee this will happen, because some update records do not actually change fields and will not be returned (for example, UPDATE TABX SET PRICE = 10 WHERE PRICE = 10
). This is common in applications that use, for example, a generic update of each column to accomplish all update tasks, regardless of what is changed.
GETNETCHANGES
retrieves and compares both before and after-images. This can result in a system resource usage increase.
Default
IGNORENETCHANGES
Syntax
GETNETCHANGES | IGNORENETCHANGES