2.2.9 Change the "elif" Statement Behavior in ecobpg

Incompatibility

The "elif" statement now works correctly with FUJITSU Enterprise Postgres 13.

FUJITSU Enterprise Postgres 12 or earlier

The decision of the "elif" statement is made whether or not the "ifdef/ifndef" condition is met.

[Example]

000000     EXEC SQL ifdef DEF1 END-EXEC.
000000     Operation (1).
000000     EXEC SQL elif DEF2 END-EXEC.
000000     Operation (2).
000000     EXEC SQL else END-EXEC.
000000     Operation (3).

If "DEF1" and "DEF2" are true, both "Operation (1)" and "Operation (2)" are executed.

FUJITSU Enterprise Postgres 13 or later

If the condition "ifdef/ifndef" is met, the judgment of the "elif" statement is not enforced.

[Example]

000000     EXEC SQL ifdef DEF1 END-EXEC.
000000     Operation (1).
000000     EXEC SQL elif DEF2 END-EXEC.
000000     Operation (2).
000000     EXEC SQL else END-EXEC.
000000     Operation (3).

If "DEF1" and "DEF2" are true, only "Operation (1)" is executed.

Action method

Check your existing application and fix the elif statement to work correctly.