Purpose
This control enables users to specify a new default tdpid for subsequent logons.
The original default tdpid is defined by the dbcname entry in CLI's System Parameter Block (SPB). The new default persists only for the current BTEQ invocation.
Syntax
| Command | Shorthand |
|---|---|
| TDP | T |
where the following is true:
Workstation-Attached Systems or Mainframe-Attached (Gateway-mediated CLI) Systems
- tdpid
- Specifies the network ID of the Teradata server.
It must be at least one character in length, but not more than 258.
It can be a full Internet name or an IPv4 or IPv6 address. For more information, see Entering IPv4 and IPv6 Network Addresses.
The TDP value can be entered in non-quoted form and quoted form.
A comment can be present before the tdpid value, with or without space separating the comment from the value. However, a comment can be accepted after the tdpid value only if the comment and the tdpid are separated by at least one space.
Mainframe-Attached (TDP-mediated CLI) Systems
- tdpid
- The identifier of the TDP that handles Teradata server traffic.
It must be at least one character in length, but not more than 8. It can contain any combination of letters and numbers. It should begin TDP... For more information, see the Teradata® Tools and Utilities for IBM z/OS Installation Guide (B035-3128).
Usage Notes
The name defined in this command must match the TDP identifier already set by the system or database administrator.
The DEFAULTS command does not affect TDP setting.
The TDP command is valid in an SQL macro.
Example 1 – TDP
.SET TDP quad1
Example 2 – TDP
.SET TDP /* tdpid */ quad1.td.teradata.com
Example 3 – TDP
.SET TDP 111.222.333.444 /* IPv4 address */
Example 4 – TDP
.SET TDP 111.222.333.444:1025 -- IPv4 address with port
Example 5 – TDP
.SET TDP /* IPv6 address */ [2002:9941:abcd::cebf]
Example 6 – TDP
.SET TDP /* IPv6 address with port */ [2002:9941:abcd::cebf]:1025