BTEQ - Changing the TDPID in Teradata

You can change the TDPID for the following types.

Type 1:
change the server for a single logon only

This can be achieved by LOGON with TDPID.


Type 2:
change the server for all logons within the current session.
.SET TDP tdpid

Entering the TDP command specifies the Teradata RDBMS that BTEQ accesses for all the logons during the current BTEQ session.