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.