Version of teradata software 1

[dwtech]

I am using bteqwin. I want to find out which version of teradata rdbms / software is running. Is there any command I can use from qteq or queryman?

Thanks in advance!

 

[dnoeth]

select * from dbc.dbcinfo;

*** Query completed. 2 rows found. 2 columns returned.
*** Total elapsed time was 1 second.

InfoKey InfoData
------------------------------ ------------------------
RELEASE V2R.05.00.00.17
VERSION 05.00.00.17

Dieter

 

[dwtech]

Thanks dnoeth. Can you point me to some other system tables or views that I can check out. I am recent entrant to Teradata world , having been in Oracle for years previously. If there is useful websites that I can use please let me know. How to find out all the systems tables etc. that I can use?

Thanks for your help.

 

[tdatgod]

Hi,
I would suggest looking at

http://www.info.ncr.com/Teradata/eTeradata-BrowseBy.cfm?page=Teradata Database

specifically the Data Dictionary manual.

Click on the link and then find the version of the manual which corresponds to your version of the software.

Then you might want to look at some of the other manuals.

Database Administrator
Introduction to Teradata
SQL/Data Dictionary Quick reference guide
The SQL reference manuals. ( Vol 1 through 6 )