PM87753: BETTER SUPPORT FOR PP(SQL) USED ON PROGRAMS WITH NO SQL

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

Closed as program error.

Error description

Better support for PP(SQL) used on programs with no SQL

Local fix

Problem summary

****************************************************************
* USERS AFFECTED: Enterprise 4.3 users of the integrated SQL *
* preprocessor *
****************************************************************
* PROBLEM DESCRIPTION: If the PP(SQL) is specified against a *
* source program that contains no EXEC *
* SQL statements, then the DB2 backend of *
* the SQL preprocessor will not be run. *
* This means that no DBRM will be *
* created. However, some users want a *
* DBRM created even in this case. *
****************************************************************
* RECOMMENDATION: *
****************************************************************

Problem conclusion

A new SQL preprocessor option called EMPTYDBRM has been added to
the SQL preprocessor. Under this option, an empty DBMR will be
created for programs containing no EXEC SQL statements. The
default is NOEMPTYDBRM, and this default preserves the behavior
before this APAR. The option will be documented in the next
release.