When SQL is Not Recorded - Teradata Database

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.