Backward compatibility

The precompiler is compatible with precompilers that are ANSI SQL-89-compliant. However, you may have applications created with earlier Embedded SQL versions that are not ANSI-compliant. This precompiler uses most of the same Embedded SQL statements used in previous precompiler versions, but it processes them differently.

To migrate applications created for earlier precompiler versions:

  1. Remove the following SQL statements and keywords from the application, because System 11 and later does not support them:

    • release connection_name

    • recompile

    • noparse

    • noproc

    • pcoptions sp_syntax

    • cancel

    release causes a precompiler error; the precompiler ignores the other keywords. The cancel statement causes a runtime error.

  2. Use the precompiler to precompile the application again.