| Pro*COBOL Release Notes Release 11.2.0.2.0 E XXXXX-01 |
|
May 2010
E XXXXX-01
This file contains important information about Pro*COBOL Version 11.2.0.2.0, which is the precompiler release corresponding to the 11.2.0.2.0 Oracle database. It contains the following topics:
This section briefly describes new features introduced in Pro*COBOL Release 11.2
Pro*COBOL can run in Instant Client (IC) mode. Developing Pro*COBOL applications in an IC environment is also supported.
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.
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.
This section lists new features introduced to Pro*COBOL in previous releases.
SQL99 syntax support: Pro*COBOL now supports SQL99 syntax for SELECT, INSERT, DELETE, and UPDATE statements and the body of the cursor in a DECLARE CURSOR statement.
Additional array INSERT and array SELECT syntax support: Pro*COBOL now supports the array INSERT and array SELECT syntax of the DB2 precompiler.
Fix execution plan: To ensure better performance of a Pro*COBOL application during deployment, the 'outline' feature of the database is used to fix the execution plan.
Implicit buffered insert: Pro*COBOL now supports the implicit buffering of a single INSERT statement executed in a loop.
Dynamic SQL statement cache: Statement caching improves the performance of dynamic SQL statements.
Scrollable cursor support: Pro*COBOL now supports a scrollable cursor to fetch data in a non sequential manner.
Platform endian support: Pro*COBOL now supports retrieving unicode data in OS endian in the PIC N host variable.
Flexible B Area length for Pro*COBOL: The length of B Area can now be from 8 to 253 columns.
The following section lists bugs fixed in Pro*COBOL. Numbers in parentheses following the description refer to bug numbers in the Oracle Bug Database.
Pro*COBOL will now be able to parse COPY statements with more
than one period at the end (9470397).
EXEC SQL PREPARE can now be done at remote database by passing a string instead of bind variable (9402996).
Pro*COBOL will now be able to handle buffered inserts for NCHAR variables (9381997).
Pro*COBOL now allows the usage of JUSTIFIED clause with Host Variables (9266470).
Pro*COBOL will now be able to parse BLANK SCREEN statements (9151190).
Pro*COBOL now accepts a scalar host variable for the AT clause even when those used in the SQL statement are arrays (9147830).
Pro*COBOL will now be able to parse COPY statements when used in OCCURS clause of an array declaration (9128157).
Pro*COBOL will now be able to parse COPY statements in OCCURS clause correctly (9055457).
Pro*COBOL now correctly generates code for SQL statements which
contain a list of lists (8932394).
Pro*COBOL now supports client result cache with static EXEC SQL statements (8771479).
Pro*COBOL no longer flags a syntax error for CURSOR declarations when both OUTLINE and OUTLNPREFIX command line options are specified (8770900).
Pro*COBOL will now be able to parse an EXEC SQL INCLUDE statement without an ending period in DATA DIVISION (871340).
Pro*COBOL no longer flags a syntax error for OPEN CUSROR statements on IBM AIX platforms (8578753).
Pro*COBOL will now be able to parse an EXEC SQL INCLUDE statement without a period at the end in PROCEDURE DIVISION (8546581).
Pro*COBOL no longer fails with SIGSEGV when attempting to select an integer into a PIC N variable (8285576).
Pro*COBOL no longer flags a syntax error for the use of "CREATE SCHEMA … " in an EXEC SQL … statement (7644365).
Pro*COBOL no longer flags a syntax error for the use of "CREATE TABLE … " in an EXEC SQL … statement (7644387).
Pro*COBOL no longer flags a syntax error for the use of "CREATE VIEW … " in an EXEC SQL … statement (7644423).
Pro*COBOL no longer flags a syntax error for the use of "CREATE VIEW … WITH CHECK OPTION" in an EXEC SQL … statement (7644449).
Pro*COBOL no longer goes into memory fault while pre-compiling huge files (more than 65K lines) with the EXEC SQL INCLUDE directive (7557301).
When an EXEC SQL statement is used with an EXEC SQL INCLUDE statement in an "EXEC ORACLE IFDEF XYZ" block, Pro*COBOL no longer loses track of whether the macro "XYZ" is defined or not, and no longer includes the files mentioned in the EXEC SQL INCLUDE statement when not expected (7484318).
When PICN_ENDIAN=OS is set, Pro*COBOL no longer tries to do conversion that results in truncation of length (7306555).
REPLACE statements with longer pseudo-texts no longer causes Pro*COBOL precompilation to crash on certain platforms (7288085).
Instant Client support for Pro*COBOL application execution (runtime) and application development is now available on UNIX or Windows platforms (7045925).
When DML statements are issued with a RETURNING clause in a Pro*COBOL application, the application now receives all rows affected by the DML statement (7029239).
For Pro*COBOL support, please contact your local Oracle Support Services Center.
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Copyright © 1992, 2010 Oracle Corporation.
All Rights Reserved.
|
|
![]() Copyright © 1992, 2010 Oracle Corporation. All Rights Reserved. |
|