Purpose
Sets the tdpid as a default for subsequent logons during the current BTEQ session.
Syntax
where the following is true:
Workstation-Attached Systems
- tdpid
- Specifies the network ID of Teradata Database.
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. 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.
Mainfame-Attached Systems
- tdpid
- The identifier of the TDP that handles Teradata Database 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... Refer to the Teradata Tools and Utilities for IBM z/OS Installation Guide (B035-3128) for details.
Usage Notes
The name defined in this command must match the TDP identifier already set by the system or database administrator.
The effect of this command is temporary, lasting only as long as the BTEQ session remains open on the client.
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