DSNH049I W csectname RETURN CODE IS FORCED TO 4 BECAUSE OPTION SQL(ALL) IS IN EFFECT, ORIGINAL RETURN CODE WAS nnn

Explanation

One or more SQL-related error messages were detected by the precompiler, but because of option SQL(ALL), the return code is forced to 4 in order to let the application proceed with compilation.

The SQL syntax checking is deferred until bind time because the source might contain non-Db2 SQL syntax that the Db2 precompiler does not recognize and flags as an error. The DBRM produced by this precompilation cannot be bound successfully by Db2 if there are SQL syntax errors or non-Db2 SQL syntax.

The return code remains untouched if there are host-related syntax or semantic errors in the source.

System action

Processing continues.

User response

Ensure that the intention of this precompilation is for executing it in a non-Db2 system.

Severity

4 (warning)