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:
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.
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.
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.
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.