BTEQ 20.00.00.11 (64-bit) Sat Oct 24 00:20:27 2026 PID: 3666
 
+---------+---------+---------+---------+---------+---------+---------+----
-- Login omitted.

 *** Logon successfully completed.
 *** Teradata Database Release is 20.00.28.81                   
 *** Teradata Database Version is 20.00.28.81                     
 *** Transaction Semantics are BTET.
 *** Session Character Set Name is 'ASCII'.
 
 *** Total elapsed time was 1 second.
 
+---------+---------+---------+---------+---------+---------+---------+----
.SET WIDTH 240
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.SET TITLEDASHES OFF
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
-- Syntax/column availability only. No log rows are read.
SELECT CAST(MaxAmpCPUTime AS FLOAT) * (HASHAMP()+1)
         / NULLIFZERO(AMPCPUTime) AS cpu_max_to_average_factor,
       CAST(MaxAmpIO AS FLOAT) * (HASHAMP()+1)
         / NULLIFZERO(TotalIOCount) AS io_max_to_average_factor
FROM DBC.QryLogV WHERE 1=0;

 *** Query completed. No rows found. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
-- Synthetic arithmetic checks; four participating AMPs assumed explicitly.
SELECT CAST(4 AS FLOAT)*4/NULLIFZERO(8) AS cpu_factor,
       CAST(100 AS FLOAT)*4/NULLIFZERO(200) AS io_factor,
       CAST(0 AS FLOAT)*4/NULLIFZERO(0) AS undefined_zero_total;

 *** Query completed. One row found. 3 columns returned. 
 *** Total elapsed time was 1 second.

            cpu_factor               io_factor    undefined_zero_total
 2.00000000000000E 000   2.00000000000000E 000                       ?

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.LOGOFF
 *** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.QUIT
 *** Exiting BTEQ...
 *** RC (return code) = 0 


