Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands
Resource Adapters Reference Guide
65
Password (-PW or -PASSWORD)
Use the Password adapter command (-PASSWORD) to specify the password that
authenticates the user logon. This command can be used for a source or target, or
in a
DBLOOKUP, DBQUERY, GET, or PUT function.
-PASSWORD
password
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.
Stored Procedure Name (-PR or -PROC)
Use the Stored Procedure Name adapter command (-PROC) to specify the name of
a stored procedure to be executed in an output of a map. Use this command
either for a target or in a
PUT function.
-PROC
procedure_name
Note If the Stored Procedure Name adapter command (-PROC) is specified, it overrides
the value in the DatabaseQueryFile > Table output card setting.
Query (-Q or -QUERY)
Use the Query adapter command setting (-QUERY) for a source to specify the
name of a query in an .mdq file as specified using the Database/Query File
adapter command (
-MDQ) and the database defined by the Database Name
adapter command (
-DBNAME).
-QUERY
query_name
Note The name of the query ( query_name ) you supply is case-sensitive. Also, if the
Query adapter command (-QUERY) is specified, it overrides the value in the
DatabaseQueryFile > Query input card setting.