I was recently trying to connect to my local Teradata instance via the BTEQ (Basic Teradata Query) command-line tool and ran into a problem trying to login. I usually use the Teradata SQL Assistant GUI based tool, so I don’t need to do this very often.
The command to login while in BTEQ is:
But how do you know the value of TDPID? Well, if you’re running Teradata and you’re logged into the computer it’s installed on, you can follow these steps:
- Open up Teradata Service Control.
- Choose the “Advanced Setup” menu option.
- On the dialog box, click the “Edit Hosts” button. This will open your local hosts file in an editor (probably notepad).
- Look for an entry that looks like this:
127.0.0.1 localhost localtdcop1.
You’re TDPID is the part of the string before “cop1”, so here it’s “localtd”.