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

CHAPTER 10 • TASKBUILDER ACTIONS 109
Figure 10.2 – Database-to-Data Action
The Database-to-Data action has the following properties:
˽ Database (Value—String) – The Database property is a string that represents the name
of the individual database on the target server to connect to. A Database server, repre-
sented by the Database component, may contain a number of separate databases.
˽ Table Name (Value—String) – The Table Name property represents the table within
the given database to connect to and copy data from.
Note
The username and password combination used in the Database start component
must have Read Access to this table or the action will fail.
˽ SQL Query (Value—Filename) – The SQL Query property is optional; it represents a
text file containing a SQL Query in cases where a direct copy of all data and columns
from the source table is not desired. The SQL file should only contain one complete
SELECT statement, which represents the query to be sent to the source database to
retrieve data (see Appendix B).
If using a SQL Query is not desired for a Database-to-Data action, this property should
be left blank.
Data-to-Database Action
The Data-to-Database action (see Figure 10.3) copies the contents of a dataset in memory
directly into a specified table in the destination database.
Figure 10.3 – Data-to-Database Action
The Data-to-Database action has the following properties:
˽ Database (Value—String) – The Database property is a string representing which in-
dividual database on the target server to connect to. A Database server, represented by