TDP - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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