The trace file contains information sent to or received from the interface to the ADABAS kernel. The SQL statements are only recorded for parse requests to the kernel. The parse identification (parseid) can be used to find out which SQL statement is currently executed.
The information contained in the trace file depends on the TRACE statement or TRACE option.
For a simple TRACE, only the sequence of SQL statements sent to the database system is recorded, which helps when checking dynamic SQL statements and macros.
A DECLARE CURSOR statement will only be executed when the result table is opened (OPEN statement). In the trace file, it can therefore be found exactly at this place. The OPEN statement is only denoted by a comment.
SQLERRD(INDEX_3) contains the number of processed rows. Example:
If the detailed form of the trace file is required, the input and output values of the SQL parameters involved are also included. Example:
If the detailed form of the trace file is only required for the program run, the names of the host variables are not available. The input and output values of the host variables concerned only get the numbers of the parameters. Example:
