You can set HCOPG to automatically convert DB2 statements to PostgreSQL statements. The conversion details are determined by a set of rules and defaults, some of which are customizable.
HCOPG DB2 to PostgreSQL conversion is triggered by setting the DIALECT compiler directive option to either MAINFRAME or MIXED, and setting the TARGETDB directive to one of POSTGRESQL, PGSQLAWS, or PGSQL. HCOPG converts all DB2 statements automatically, and converts DB2-compatible PostgreSQL statements as specified using statement prefixes.
The following topics provide important information on key features of HCOPG that enable you to optimize DB2 to PostgreSQL conversion: