O'Reilly logo

Information Systems Transformation by Philip Newcomb, William M. Ulrich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Application Porting

This section describes the re-platforming of one of the six core applications running on the IBM mainframe under DB2 and CICS. The task for DLD was to modify the source programs (i.e., COBOL) to make them access an Oracle database instead of the original DB2 database. The following issues had to be addressed:

  • Convert DB2 ESQL to Oracle ESQL.
  • Map DB2 built-in functions to equivalent Oracle functions/procedures.
  • Verify, if any, operation against the EBCDIC character set that still works against the ASCII character set (e.g., COMP3 fields, alphanumerical sort).

The user interaction that is provided through 3270 emulation on PC client is not within the scope of this discussion.

DB2 ESQL Syntax

The SQL commands used by ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required