The following SQL statements provide a mechanism which supports partial testing of database applications.
Those parts of the application which are to be tested must begin with the SQL statements SET TRACE ON or SET TRACE LONG and end with SET TRACE OFF. In accordance with the control flow of the program, the SQL statements included in the part to be tested are stored in a file which may then be evaluated. All SQL statements in called translation units (external subroutines, modules, etc.) are also tested. SET TRACE statements may be specified at any places where, in accordance with the syntax rules, statements of the programming language are permitted.
TRACE options which may be specified will suspend the TRACE statements for a translation unit. Under UNIX, the name of the file containing the test results receives the suffix '.pct'. As an alternative, the filename can be specified after the TRACE FILE option (<trace filename>).
See also: