16.20 - TDP - Basic Teradata Query

Basic Teradata Query Reference

Basic Teradata Query
October 2018
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.


where the following is true:

Workstation-Attached Systems

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

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.

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