16.20 - Time2 - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

Time2 is a four byte field that records when the TDP sends the request to the Teradata Database.

In this language... The variable name for Time2 is...
COBOL DBCAREA-TDPDBO-TIME
PL/I TDPDBO_TIME
C, C++ tdpdbo_time
IBM Assembler DBCTIME2
This routine... Does this for Time2...
DBCHINI writes
DBCHCL writes (FET)
Time2 is used by... To...
applications read

After a call to DBCHCL for the first fetch function on the specified request and if Return-time is set to ‘Y‘, the application can obtain the value of Time2.

The Time2 field is four bytes long and contains an unsigned binary timestamp. The difference between Time2 and Time1 yields the elapsed time between those two points in processing the request. The precision for Time2, or the differences between Time2 and Time1, is specified by the Timing-precision option. The validity of the Time2 field is indicated by the Time2-status field.