Backward compatibility

The System 11 and later precompiler is compatible with precompilers that are SQL-89-compliant. However, you may have applications created with earlier Embedded SQL releases 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 releases:

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

    • release connection_name

    • recompile

    • noparse

    • noproc

    • pcoptions

    • cancel

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

  2. Use the System 11 and later precompiler to precompile the application again.