The following table describes the terms used in the command line feature.
| Term | Syntax |
|---|---|
| Execution Plan |
{
{ Online Plan description} ||
{ -f <Offline Execution Plan file name>}
}
|
| Online Plan Description |
{ <Logon Specification>
-d <database name>
{-rc <Range condition> || -t <query tag> }
{ -ux || -unx }
}
|
| Online XML Plan Description |
{ <Logon Specification>
-d <database name>
-xml
{-rc <Range condition>}
{ -ux || -unx }
}
Only available for Teradata Database version 13.10 and later.
|
| Logon Specification |
{ { -l <Server Name>\<User Id>\<Password>
[-am<Authentication Mechanism>\<Authentication Parameter>]
[-scs<Session Character Set Name>]}
|| { -c <ODBC DSN Name\password>
[-am[<Authentication Mechanism>\]<Authentication Parameter>]
[-scs<Session Character Set Name>]}
}
|
| Range Condition |
{QueryId1 [{, || -} QueryId2….]}
|
| Query Tag |
{-t <querytag>}
|
| Compare attribute |
{ { -a } || {-cs} || {-sc} || {-jo} || {-jc} || {-ta} ||
{-op} || {-opd} || {-rsc}
}
|
| View Mode |
{ [-v expanded || -v compressed] }
|