query - Teradata Data Mover

Purpose

The query command queries the database to output a list of databases and tables. Use the list as a template for the create command.

Syntax

Parameters

See Parameter Order.

broker.port

[Optional] You may enter a broker port to overwrite the default value specified in the commandline.properties file in order to connect to a different ActiveMQ server (and therefore a different daemon) at runtime.

61616

broker.url

[Optional] You may enter a broker URL to overwrite the default value specified in the commandline.properties file in order to connect to a different ActiveMQ server (and therefore a different daemon) at runtime.

dm-server1

database

[Optional] Database to be queried.

DB1

dir

[Optional] Output directory for the object list. A directory will be created if one does not exist.

/home/datamover/lists

The generated XML file is written by default to the current directory.

object_list

[Optional] Output file name for the object list. Existing file name will be overwritten.

objectlist.xml

The generated XML file has by default the name objlist.xml.

source_account_id

[Optional] Logon account ID for source database.

Spaces in the account name for the source or target account id causes the job to fail.

source_logon_mechanism

[Optional] Logon mechanism for source system. To log on to a source Teradata Database system, the user must provide at least one of the following:

• source_user and source_password
• source_logon_mechanism

Logon mechanisms are not supported for Teradata ARC jobs. Use logon mechanisms only for Teradata PT API and Teradata JDBC jobs. If -source_logon_mechanism is specified and -force_utility is not used, Teradata PT API is used by default. Specifying -source_logon_mechanism with Teradata ARC specified for -force_utility results in an error.

KRB5

source_logon_mechanism_data

[Optional] Additional parameters that are needed for the source system's logon mechanism.

joe@domain1@@mypassword

source_password

[Optional] Source Teradata logon password.

123456789

Not a valid parameter if -source_password_encrypted is also specified. If you do not specify a password for this parameter, the command prompts you to enter it interactively. Input is masked with a set number of asterisks, regardless of the length of the password.

source_password_encrypted

[Optional] Source Teradata encrypted logon password.

17894cc84b5637a88e36fa37a010e3662d18f64b8ce204bef8d63868ad417810

Not a valid parameter if -source_password is also specified.

source_tdpid

Source Teradata Database.

Checks

source_user

[Optional] Source Teradata logon id.

TD_API_user

If you do not specify a logon id for this parameter, the command prompts you to enter it interactively.

Spaces in the user name for the source or target id causes the job to fail.

XML File Example

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
<dmQuery xmlns="http://schemas.teradata.com/dataMover/v2009" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://schemas.teradata.com/unity/datamover.xsd"> 
<!-- source_tdpid Floyd, Source Teradata database --> 
    <source_tdpid>floyd</source_tdpid> 
<!-- source_user dmguest, Floyd, Source Teradata log on id --> 
    <source_user>dmguest</source_user> 
<!-- source_password please, (optional)Source Teradata log on password --> 
    <source_password>please</source_password> 
    <object_list>queryoutput.xml</object_list> 
</dmQuery>