Programming for a PostgreSQL environment
1.2.0.6+
With the fix pack for APAR PH65575 installed, you can write COBOL programs that integrate with a PostgreSQL database through embedded SQL statements that enable you to retrieve, update, insert, and delete data.
PostgreSQL, also known as Postgres is a popular open source database. IBM COBOL for Linux on x86 offers a coprocessor for PostgreSQL, where EXEC SQL statements are converted to COBOL statements by the compiler during the compilation process.
Note: The COBOL for Linux coprocessor for PostgreSQL is based on the PostgreSQL ECPG preprocessor,
modified to support COBOL instead of C. The coprocessor is integrated into the COBOL compiler. When
a COBOL program with embedded SQL statements runs, it uses the same library that the ECPG
preprocessor uses to run a C program. Because of the commonality between the COBOL coprocessor and
the ECPG preprocessor, much of the ECPG documentation has information that is also useful for COBOL
programmers, as it is applicable to embedded SQL in general, not just in the context of a C
program.
This section augments the ECPG documentation, providing details on using the COBOL coprocessor, and points out places where it differs from what is documented for ECPG. For more information about ECPG, see ECPG — Embedded SQL in C.