Tuesday, December 15, 2009

Checking TD Version from UNIX

How would you check what version of teradata is being used in your UNIX env?

You simply have to create a bteq script:

bteq<<EOF

.logon databasename/username,pwd;

.show version

.QUIT

EOF

And run the script.

Or, you can do the same on commandline.