Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands
Resource Adapters Reference Guide
71
Update (-UP or -UPDATE)
Use the Update adapter command (-UPDATE) to enable update mode which
causes update operations to be performed for tables or views based upon the
defined update keys and key columns to update. For information about defining
updating keys and key columns to be updated, refer the Database Interface
Designer Reference Guide.
If enabled, the default is to update each row, if possible, and upon failure, to
insert the data. Optionally, you can specify to insert a row or update each row, if
possible, and upon failure, to not insert the data. This command can be used
either for a target or in a
PUT function.
If used in a
PUT function, you must define your update keys and columns to
update in an .mdq file. Then specify this .mdq file in the
PUT function using the
Database/Query File adapter command (
-MDQ), together with the Database Name
adapter command (
-DBNAME), the Table Name adapter command (-TABLE), and
the Update adapter command (
-UPDATE). The .mdq file must be available at
runtime.
-UPDATE [OFF|ONLY]
Value Description
OFF
Insert a row. Insertions are allowed regardless of success or
failure.
ONLY
Update each row, if possible. Upon failure, do not insert the
data.
User ID (-US or -USER)
Use the User ID adapter command (-USER) to specify the user ID for connection
to the database. This command can be used either for a source or target, or in a
DBLOOKUP, DBQUERY, GET, or PUT function.
-USER
username
Note If you specify the parameter as $( env_var )where env_var represents the name
of an environment variable, the actual value of the password is retrieved from this
environment variable.