Change in how to specify UPDATE during simple specification of database table information
|
In previous versions, you specified either Use INSERT or Use UPDATE as the update method during simple specification of database table information, and then specified a WHERE clause in the SQL statement.
From DataMagic Ver.3 onward, you can now perform one of the following operations to reduce the workload of specifying SQL statements:
Selecting INSERT
All records are registered (INSERT).
Selecting INSERT by using direct path loading function
Records are registered (INSERT) using Oracle direct path load. This option is displayed only if an Oracle database is connected.
Selecting UPDATE rows that match the key value
A record is updated if the key value matches the record (UPDATE), or a record is added if the key value does not match the record (INSERT).
If you specify Use INSERT as the update method during simple specification of database table information in HULFT-DataMagic Ver.2, the specification method is changed from Simple specification to SQL statement specification when you upgrade to DataMagic Ver.3, SQL1 will be created. If the bind variable is not specified in the WHERE condition of SQL statement, SQL1 is created by using bind variable of Oracle format (:n n is a serial number from 1).