What's New in Pro*COBOL?

This section describes new features of Oracle releases and provides pointers to additional information. New features information from previous releases is also retained to help those users migrating to the current release.

The following sections describe the new features in Oracle Pro*COBOL:

• Oracle 11g Release 2 (11.2) New Features in Pro*COBOL

• Oracle 11g Release 1 (11.1) New Features in Pro*COBOL

Oracle 11g Release 2 (11.2) New Features in Pro*COBOL

The following are the new features and enancements in the Pro*Cobol application in Oracle11g Release 2:

• Support for 8-Byte Integer

  Previously, the size of integer variable declarations using COMP/ COMPU/ COMP-4/ COMP-5/ BINARY storage specification was restricted to 9 digits on 32-bit platforms. Now integers up to 18 digits can be used on all platforms. Declarations greater than 9 and less than or equal to 18 are mapped to C's long long int datatype during code generation.

  See Also:

  Quick Reference

  DECLARE CURSOR (Embedded SQL Directive)

• New command-line option for held cursor behavior after ROLLBACK

  A new command-line option, CWH_SQL99, sets the ROLLBACK behavior for held cursors. By default, CWH_SQL99, is set to YES and held cursors are closed after ROLLBACK. Set CWH_SQL99 to NO for backward compatible behavior where held cursors remain open after ROLLBACK.

  See Also:

  DECLARE CURSOR (Embedded SQL Directive)

Oracle 11g Release 1 (11.1) New Features in Pro*COBOL

The following are the new features and enancements in the Pro*Cobol application in Oracle11g Release 1:

• SQL99 Syntax Support

  With this enhancement, the SQL99 syntax for SELECT, INSERT, DELETE, and UPDATE statements and the body of the cursor in a DECLARE CURSOR statement will be supported.

• Additional Array Insert/Select Syntax

  The array INSERT and array SELECT syntax of the DB2 precompiler is now supported by Pro*Cobol.

• Fix Execution Plans

  By using the outline feature, you can ensure that the performance of the database is not affected when modules are integrated and deployed into different environments.

• Using Implicit Buffered Insert

  Pro*Cobol supports the implicit buffering of a single INSERT statement executed in a loop.

• Dynamic SQL Statement Caching

  Statement caching can be used to improve the performance of dynamic SQL statements.

• Scrollable Cursors

  Pro*Cobol now supports a scrollable cursor in the Pro*Cobol application to fetch data in a non sequential manner.

• Platform Endianness Support

  Retrieving unicode data in OS endian in the PIC N host variable is now supported for the Pro*Cobol application.

• Flexible B Area Length

  The length of B Area for the Pro*Cobol application can now be from 8 to 253 columns.