16.10 - When SQL is Not Recorded - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

If a query encounters an error or is aborted, the data in the field SQLTextInfo might be:

  • Truncated
  • Set to Null (?)
  • Set to “Unavailable”

    The word “Unavailable” indicates that the system failed to translate correctly (for example, if the system must translate to UNICODE).

Also, in some cases, DBQL does not log the entire SQL statement. For example, DBQL logs the CREATE/REPLACE PROCEDURE statements including the arguments, but not the additional options nor statements making up the body of the stored procedure.