BTEQ - TIMEMSG command in Teradata

It will enable you to print the total time of a specified request.

Syntax:
.SET TIMEMSG QUERY


In a Teradata SQL macro appears as:
ECHO ’.SET TIMEMSG QUERY’;


Example:
.LOGON localtd/dbc, dbc;
SELECT * from forgetcode.tbl_employee;
.LOGOFF;

Output:
*** Total Query time was 1 second.


Please note that total query time is the output of TIMEMSG command and it is different from Total elapsed time.