The trace file contains information sent to or received from the interface to the ADABAS kernel. The SQL statements are only recorded for parse orders 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 which was sent to the database system is recorded: this aids in checking dynamic SQL statements and macros.
A declare cursor statement is only executed with the opening of the result table (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 host variables 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:
