Wavetronix Command Translator (CMD-DT) - User Guide - Manual (Page 111)

110 CHAPTER 10 • TASKBUILDER ACTIONS
the Database component, may contain a number of separate databases.
˽ Table Name (Value—String) – The Table Name property represents the table within
the destination database to copy data into.
Note
The username and password combination used in the Database component must
have Write Access to this table or the action will fail.
˽ Key String (Value—String) – If a Sybase or Oracle database is the destination in this
action, some additional information may be required in order for operations to be suc-
cessful. Sybase database tables that have primary key fields will need the primary key
column names separated by commas inserted into this string.
Example
column1,column2
For Sybase and Oracle databases, any primary key column that is auto-incremented
(i.e. assigns a number automatically without user input) will need to be marked with a
“$” character before its name.
Example
$column3
This property is optional, but may be required depending on the destination table sche-
ma for a given task.
˽ Mapping (Value—Map) – The Mapping property allows you to map the source col-
umns within the dataset to the table columns inside the destination database. To edit
mapping, click the Edit button on the Mapping property box and this will open the
Mapping sub-window (see Chapter 11). If the database connection parameters are not
inputted correctly before clicking the Edit button, a sub-window will inform you that
the parameters are incomplete and a connection to the database could not be made.