A fix is available
APAR status
Closed as program error.
Error description
PMR 94924,7TD,000: BIND (DYNAMIC) and PROCESS NOSQL issue ================================================================ Date reported: 07/19/2013 Severity: High Users Affected: All IMU users of MU V4.1 Problem Description: Users are getting COBOL compiler error on "EXEC SQL INCLUDE SQLCA" when using BIND(DYNAMIC) and program does not contain any SQL statements. Problem Summation The problem is caused by the "PROCESS NOSQL" statement which is unconditionally generated by the EASYTEND macro when BIND(DYNAMIC) is in effect. In addition, when there are no SQL statements in the program but PARM options related to SQL are in effect, the "EXEC SQL INCLUDE SQLCA" statement is generated along with the hard coded SQLCA layout (a duplicate layout). Problem Conclusion: The EASYTEND macro was changed to generate "PROCESS NOSQL" COBOL compiler option conditionally when BIND(DYNAMIC) and SQL statements exist in the Easytrieve Plus source. This allows the user to use BIND(DYNAMIC) even if program does not contain SQL. The EASYT007 macro was changed not to generate 'EXEC SQL INCLUDE SQLCA" if SQL statement do not exist in the Easytrieve Plus source, making SQL translator unnecessary. The following modules are impacted: FSOFT01.V4R1M0.SFSYFJCC EASYT007 - existing macro EASYTEND - existing macro ================================================================
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All IMU v4.10 users. * **************************************************************** * PROBLEM DESCRIPTION: Users are getting COBOL compiler error * * on "EXEC SQL INCLUDE SQLCA" when * * using BIND(DYNAMIC) and program does * * not contain any SQL statements. * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** The problem is caused by the "PROCESS NOSQL" statement which is unconditionally generated by the EASYTEND macro when BIND(DYNAMIC) is in effect. In addition, when there are no SQL statements in the program but PARM options related to SQL are in effect, the "EXEC SQL INCLUDE SQLCA" statement is generated along with the hard coded SQLCA layout (a duplicate layout).
Problem conclusion
The EASYTEND macro was changed to generate "PROCESS NOSQL" COBOL compiler option conditionally when BIND(DYNAMIC) and SQL statements exist in the Easytrieve Plus source. This allows the user to use BIND(DYNAMIC) even if program does not contain SQL. The EASYT007 macro was changed not to generate 'EXEC SQL INCLUDE SQLCA" if SQL statement do not exist in the Easytrieve Plus source, making SQL translator unnecessary.
Temporary fix
Comments
APAR Information
APAR number
PM94579
Reported component name
MIGRATION UTILI
Reported component ID
5697N4400
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-06
Closed date
2013-08-06
Last modified date
2013-09-03
APAR is sysrouted FROM one or more of the following:
PM93770
APAR is sysrouted TO one or more of the following:
UK96462
Modules/Macros
FSYESEND FSYET007
Fix information
Fixed component name
MIGRATION UTILI
Fixed component ID
5697N4400
Applicable component levels
R410 PSY UK96462
UP13/08/12 P F308
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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSY4B9","label":"IBM Migration Utility for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
27 October 2020