Depending on option settings, the ADABAS database system can either check only the syntax of an SQL statement (syntax) or also the availability of the specified tables and columns and the compatibility of their types with host variables (check). For this purpose, a database session is opened and all SQL statements are executed at precompilation time. After precompilation, the effects of the SQL statements are cancelled. The option user specified in the program determines under which identification this database session is to be performed. Any connect statement in a program will be rejected with the error message '-3005 INVALID COMMAND'. The SQL statements are executed in the sequence of their static placement within the text, not in the dynamic order of the program statements. For various statements, e.g., dynamic SQL statements, only a syntax check can be performed.
Since the control flow of the application is not taken into consideration when testing with the precompiler, the interrelations of the SQL statements cannot be traced by means of this mechanism.
The results of the precompiler tests are stored in the precompiler listing.