Improvement on simple specification of database table information
|
In previous versions, during simple specification of database table information, if you specified Use UPDATE as the update method, you had to specify a WHERE clause in the SQL statement.
From DataMagic Ver.3 onward, you are saved the work of always specifying a WHERE clause. When using simple specification, you can now specify the table update method simply by setting the Update method combo box and a key value. This reduces the work of specifying the WHERE clause. You can select the update method from the following items.
-
INSERT
-
INSERT by using direct path loading function. (You can select this option in case of Oracle.)
-
UPDATE rows that match the key value