IBM Exam Questions

What are the three "Write mode" properties that allow the possibility of multiple SQL acti

Your job design calls for using a target ODBC Connector stage. The target database is found on a
remote server. The target table you are writing into contains a single column primary key. What
are the three “Write mode” properties that allow the possibility of multiple SQL actions? (Choose
three.)

A.
Join then update

B.
Truncate then add

C.
Insert then update

D.
Delete then insert

E.
Update then insert

Explanation: