Previous Topic: SQLWA - Format for C LanguageNext Topic: Interaction of Multiple Preprocessors


Error Handling

If the Preprocessor detects an SQL error that causes the program to be nonexecutable, the Preprocessor terminates processing. The plan being built and the statements are backed out. The previous plan (if one existed) for the program is restored. See the CA Datacom/DB Message Reference Guide for a list of possible return codes generated by the Preprocessors.

In COBOL, if the Preprocessor completes with a condition code other than 0, you should check SYSPRINT for the messages and the SQLCODE. The Preprocessor returns the following condition, depending on your environment:

z/OS

Condition code 12

z/VSE

Abnormal termination without a dump

For PL/I, C, and Assembler, all return codes that are equal to or greater than 16 indicate that the Preprocessor encountered an abnormal problem and terminated.