An organization has two million customers that are part of the International customer group. Validation must occur when customer records are updated. For all customers where the value of the…

Question

Exhibit

Options

• Attsbegin; while select forupdate CustTable where CustTable.CustGroup == 'International' { CustTable.DlvMode = 'Air'; CustTable.update(); } ttscommit;
• Bttsbegin; update CustTable set DlvMode = 'Air'; where CustTable.CustGroup == 'International' ttscommit;
• Cttsbegin; update_recordset CustTable setting DlvMode = 'Air' where CustTable.CustGroup == 'International' ttscommit;
• Dttsbegin; while select forupdate CustTable where CustTable.CustGroup == 'International' { CustTable.DlvMode = 'Air'; CustTable.doUpdate(); } ttscommit;
• Ettsbegin; update_recordset CustTable setting DlvMode = 'Air' where CustTable.CustGroup == 'International' ttscommit;

• A
  72% (13)
• B
  6% (1)
• D
  6% (1)
• E
  17% (3)

Explanation

A has the update call, which will run validation. While D will not as it performs a DoUpdate that only updates the value and skips all validation. E is the most effective, and also will run validation and other methods if needed. To skip validation using update_recordsset you have to call skipDataMethods method on the table first.

No community discussion yet for this question.