Command‑Line Switches
Table 7 describes the command‑line switches for Teradata Set. Command‑line switches are not case‑sensitive.
Switch |
Task |
am |
Set authentication mechanism and parameter for connecting to a database. |
c |
Connect using ODBC. |
dsp |
Capture execution plan information for a specific date when queries are added for export using the function CURRENT_DATE. The date must be specified with this switch in mm-dd-yyyy format. For example, -dsp 02-12-2008. |
ed |
Export by database for the specified database name. |
esr |
Export table data used by query optimization. Note: This function is available only when command‑line switch p (execution plans) is specified in the export options. |
eqf |
Export by query for the queries contained in the specified file. |
eqt |
Export by query for the query specified on the command line. |
ewl |
Export by workload for the specified workload name. |
ewr |
Export specific recommendation tags during an export by workload. |
f |
Save the exported information to the specified file. |
i |
Import information from the specified file. |
icf |
Read the command switches from the specified file instead of the command line. |
l |
Connect using CLIv2. |
lsr |
Insert table data used by query optimization to tables on the test system. |
qcd |
Export and import QCD-related information. |
scs |
Specify session character set. |
u |
Clean up information using the specified file. |
unx |
Retrieve Data Dictionary information and QCD data using non-X views. |
ux |
Retrieve Data Dictionary information and QCD data using X views. |
uxq |
Retrieve data from the QCD using X views. |
xapp |
Keep the application open and connected following an export, import, or undo‑import (cleanup) operation. By default, the application automatically disconnects and closes after the operation completes or an unsuccessful log on occurs. |
dbql |
Export DBQL query specified on the command line using the parameters DBQL Database name and DBQL Query ID |
tardbql |
Import DBQL XML Plans into the specified Target DBQL Database. The target DBQL Database name should be provided followed by the switch. |
x |
Export execution plans in XML form for queries either entered manually (specified on the command line using switch eqt) or selected from file. |
Table 8 describes the command‑line switches specifically for export and import options. Options can be specified in any combination and in any order. For example, typing ‑drs or ‑d ‑s ‑r achieves the same result. If no option is specified, all options are considered.
Switch |
Task |
d |
Export, import, and undo object definitions. |
e |
Export, import, and undo cost profiles |
g |
Export, import, and undo demographics. |
o |
Export, import, and undo Optimizer cost parameters and DBS Control information. |
p |
Export, import, and undo execution plans. |
q |
Import and undo import the DBQL XML Plans. |
r |
Export, import, and undo RAS. |
s |
Export, import, and undo statistics. |
w |
Export, import, and undo workload information, including workload definitions and index recommendations. |