When SQL is Not Recorded - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

When SQL is Not Recorded

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.