DSNH084I W csectname LINE nnnn COL cc UNACCEPTABLE SQL STATEMENT

Explanation

The referenced SQL statement is not allowed in this situation, but it will not cause an error. Depending on the option specified at precompile time, one of the following occurred.
  • The BEGIN DECLARE SECTION(*), END DECLARE SECTION(*), and UPDATE STATISTICS statements are flagged as not compatible.

    * For C applications, BEGIN and END DECLARE SECTION are not flagged.

    * For other languages, the statement is only allowed with precompiler option STDSQL(YES).

  • Using the STDSQL(YES) precompiler option, the INCLUDE SQLCA statement is flagged as a warning.

System action

The BEGIN DECLARE SECTION, END DECLARE SECTION, and INCLUDE SQLCA statements are ignored. The other statements are replaced by host language statements that will, if executed, set a warning code or SQLCODE -84 in the SQLCA.

User response

Unless this application program is used in a portable manner, remove the statement.

Severity

4 (warning)