DataFlux Data Management Studio 2.6: User Guide

Target Table Options Dialog

The Target Table Options dialog enables you to set options that control the behavior of the target table when you update rows. The dialog contains the following elements:

UPDATE /*+ FIRST_ROWS(10) */ MyView

SET Col1 = 2

WHERE Col1 = 0

 

UPDATE MyTable PARTITION(MyPartition)

SET Col1 = 2

WHERE Col1 = 0

 

UPDATE MyTable

SET Col1 = 2

WHERE Col1 = 0

OPTION (hint1, hint2)

 

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfDMStd_CF_UpdateRowsOpt.html