Skip to main content

Software  >  Software Development  >  

PQ83744: CMPL COBOL/SQL COPROCESSOR ENABLEMENT FOR DB2 V8


 A fix is available

Obtain the fix for this APAR



APAR status
Closed as program error.

Error description
Various new features of DB2 for z/OS Version 8 SQL, such as
multiple-row FETCH, multiple-row INSERT, and longer names for
SQL identifiers, table names, and column names do not work
with the SQL coprocessor (SQL compiler option).
These features need to be enabled in the Enterprise COBOL
for zOS 3.3 and 3.2 compilers.
Local fix

Problem summary
****************************************************************
* USERS AFFECTED: Enterprise COBOL for z/OS users who want to  *
*                 take advantage of SQL features that are new  *
*                 to DB2 for z/OS Version 8.                   *
*                                                              *
****************************************************************
* PROBLEM DESCRIPTION: The interface between COBOL and DB2 V8  *
*                      changed slightly late in development    *
*                      cycles, so this APAR is required to     *
*                      complete DB2 Version 8 support in       *
*                      Enterprise COBOL for z/OS V3.2 and 3.3  *
*                                                              *
****************************************************************
* RECOMMENDATION: Apply the provided PTF and recustomize       *
*                 compiler options.                            *
*                                                              *
****************************************************************
Various new features of DB2 Version 8 SQL, such as multiple-row
FETCH, multiple-row INSERT, and longer names for SQL
identifiers, table names, and column names will not work with
the SQL coprocessor (SQL compiler option) unless this APAR
is installed on Enterprise COBOL 3.2 and 3.3
Problem conclusion
IGYCDOPT and IGYTSQL2 were changed to enable the Enterprise
COBOL compiler to correctly compile programs with the new level
of SQL functionality available in DB2 Version 8.

This APAR changes the Modification level of the compilers in
order to provide an external indication that a compiler has the
necessary PTFs installed to handle DB2 Version 8 SQL.  After
this APAR fix is applied, the compilers will have a 1 as the
mod level, so that the product ID on the listing headers will
change as follows:

Enterprise COBOL for z/OS and OS/390 3.2.0  will change to:
Enterprise COBOL for z/OS and OS/390 3.2.1

Enterprise COBOL for z/OS 3.3.0  will change to:
Enterprise COBOL for z/OS 3.3.1

V3R2M0 becomes V3R2M1, and V3R3M0 becomes V3R3M1

++HOLD information:  Customized default compiler options
must be recustomized after the PTF for this APAR is applied.
If you have customized your installation default compiler
options, then this APAR fix will undo your customizations.
Save your customizations before your APPLY, then re-customize.
Simply rerun IGYWDOPT job in SIGYSAMP using instructions in
the job.
Temporary fix

Comments

APAR information
APAR numberPQ83744
Reported component nameENT COBOL FOR Z
Reported component ID5655G5300
Reported release330
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Special AttentionNoSpecatt
Submitted date2004-01-25
Closed date2004-07-29
Last modified date2004-09-03

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:
UQ91168

Modules/Macros
IGYCDOPTIGYCOPIIGYDPR06IGYSCNTLIGYSITEMIGYSSQL
IGYTSQL2     

Publications Referenced

Fix information
Fixed component name ENT COBOL FOR Z
Fixed component ID 5655G5300

Applicable component levels
R320 PSY UQ91168   UP04/08/02 P F407
R330 PSY UQ91169   UP04/08/03 P F408

  Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Software Development
 Traditional Progamming Language & Compilers
 Enterprise COBOL for z/OS
 Compile
 Software version:
  330
 Reference #:
  PQ83744
 IBM Group:
 Software Group
 Modified date:
 2004-09-03

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.