To facilitate the error search for the programmer, SQL-PL provides the following translation options:
The SQLTRACE option causes all SQL statements of the routine to be recorded in an operating system file.
The SQLTRACE ALL option causes all subsequent SQL statements to be recorded in an operating system file up to the end of the program.
The MODULETRACE option causes all subsequent calls of routines and forms to be recorded from the call of the module onward.
The name of the protocol file can be set in the SET menu.
Example:
Mr Miller has chosen the trace options in one of his SQL-PL routines:
After he has started his program and has inserted a data record, the following content is contained in the protocol file:
When using the MODULETRACE or SQLTRACE option, the WRITETRACE statement can be used for additional test output that is to be written into the protocol file (see chapter Processing Files ).
Syntax:
