 |
Software > Software Development >
|
 |
 |
 |
PQ83744: CMPL COBOL/SQL COPROCESSOR ENABLEMENT FOR DB2 V8
|
 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 number | PQ83744 |
| Reported component name | ENT COBOL FOR Z |
| Reported component ID | 5655G5300 |
| Reported release | 330 |
| Status | CLOSED PER |
| PE | NoPE |
| HIPER | NoHIPER |
| Special Attention | NoSpecatt |
| Submitted date | 2004-01-25 |
| Closed date | 2004-07-29 |
| Last modified date | 2004-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
| IGYCDOPT | IGYCOPI | IGYDPR06 | IGYSCNTL | IGYSITEM | IGYSSQL |
| 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. |
|
 |
| 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. |
 |
 |
 |
| Please take a moment to complete this form to help us better serve you. |
 |
 |
 |
|
|
|
 |
 |
| 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 |
 |
|