TDP Command | Basic Teradata Query - 17.00 - TDP - Basic Teradata Query

Basic Teradata® Query Reference

Basic Teradata Query
June 2020
Programming Reference


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.


TDP Syntax

where the following is true:

Workstation-Attached Systems

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. 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

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.

Example 1 – TDP

.SET TDP quad1

Example 2 – TDP

.SET TDP /* tdpid */

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