IBM Support

PM94579: COBOL COMPILER ERROR ON "EXEC SQL INCLUDE SQLCA" WHEN USING BIND(DYNAMIC)

A fix is available

Subscribe

You can track all active APARs for this component.

 

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