The following table 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. 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. |
The following table describes the command-line switches 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. Use 't' to export current 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. |
m | Export, import and undo Maps. |