Depending on options set, ADABAS 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 the host variables (CHECK). For this purpose, a database session is opened and all SQL statements are executed at precompilation time. The effects of the SQL statements are cancelled after precompilation. The option USER specified in the program determines under which identification this database session is to be performed. A CONNECT statement which might be included 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.