16.20 - Time3 - 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

Time3 is a four byte field that records when the response arrives at the TDP from the Teradata Database.

In this language... The variable name for Time3 is...
COBOL DBCAREA-TDPDBI-TIME
PL/I TDPDBI_TIME
C, C++ tdpdbi_time
IBM Assembler DBCTIME3
This routine... Does this for Time3...
DBCHINI writes (FET)
DBCHCL writes
Time3 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 Time3.

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