Demonstration Applications

Enterprise Developer provides a number of demonstration applications for HCOPG that illustrate programming techniques and behavior at run time for application migrations using HCO for PostgreSQL.

The demonstration files are located in the $COBDIR/demo/sql/hcopg directory.

Each sample application comes with a Readme file to explain how to use the application.

The HCOPG demonstration applications all produce a console log displaying their progress. They all terminate on receipt of an error, after displaying an error message.

HCOPG - Array Insert

Demonstrates how array inserts work with PostgreSQL when using mainframe DB2 syntax.

HCOPG - Function Emulation

Demonstrates how to add math functions to PostgreSQL that emulate standard math functions in DB2.

HCOPG - Labeled Durations

Demonstrates how HCOPG manages DB2 date formats and labeled duration calculations. PostgreSQL does not support labeled calculations directly. HCOPG handles the conversion to PL/pgSQL to emulate DB2 labelled duration syntax.