PI12517: UNPROCESSED EXEC SQL STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PMR 22094,379,000 - UNPROCESSED EXEC SQL STATEMENT
  
  Old PMR - 89488,379,000 - UNPROCESSED EXEC SQL STATEMENT
  =========================================================
  Replaces Old APAR - APAR PI07669
  
  This PMR is an extension of PMR 89488,379,000
  
  Prerequisites - All PTFs to date
  
  Date reported: 02/25/2014
  
  Severity: High
  
  Users Affected:
   All IMU users of MU V4.1 that use DB2 called procedures in
   dynamic mode
  
  Problem Description:
   EXEC SQL CALL is ignored by the Dynamic SQL translator.
   The EXEC SQL is passed on to COBOL where it fails to
   compile/execute.
  
  Problem Summation
   IMU's SQL dynamic translator does not recognize EXEC SQL CALL
   statement by design.
  
  Problem Conclusion:
   The DYNAMSQL macro was changed to prepare CALL statement with
   EXEC SQL CALL :procedure USING    DESCRIPTOR :SQLDA.
  
   An SQL statement is constructed to execute the called
   procedure.
  
  Impact on existing users
   There is no impact on existing non-DB2 programs.
  
   Users who wish to use Called Procedures should re-install
   FSYSQLIO module to include the new logic.
  
   Users who do not use Called Procedures are not impacted.
  
  
  Impacted byte code macros:
   FSOFT01.V4R1M0.SFSYFJCC
  
        DYNAMSQL - existing macro
        FSMACSQL - existing macro
  
        FSOFT01.V4R1M0.SFSYLOAD
        FSSQLER2 - Dynamic SQL error handler
  
  
  Additional information:
  a) Additional FSYSQLIO (FSMACSQL option)
  
    PCALLS=nn parameter was added to specify the maximum number of
    supported SQL CALL statements in a   single program.
  
           The default is PCALLS=32
  
    Users who wish to change the default must add PCALLS=nn,
    to FSYSQLIO module.
  
  b) To activate these new changes, you must re-assemble and BIND
     the FSYSQLIO Dynamic SQL interface module.
     (use JCASMSQL job located in SFSYJCLS).
  ===============================================================
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IMU users of MU V4.1 that use DB2        *
  *                 called procedures in dynamic mode.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: EXEC SQL CALL is ignored by the         *
  *                      Dynamic SQL translator.                 *
  *                      The EXEC SQL is passed on to COBOL      *
  *                      where it fails to compile/execute.      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  IMU's SQL dynamic translator does not recognize EXEC SQL CALL
  statement by design.
  

Problem conclusion

• The DYNAMSQL macro was changed to prepare CALL statement
  with EXEC SQL CALL :procedure USING    DESCRIPTOR :SQLDA.
  
  An SQL statement is constructed to execute the called
  procedure.
  
  Impact on existing users
   There is no impact on existing non-DB2 programs.
  
   Users who wish to use Called Procedures should re-install
   FSYSQLIO module to include the new logic.
  
   Users who do not use Called Procedures are not impacted.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

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

Modules/Macros

•    FSYDMSQL FSYMASQL FSYQLER2
  

Fix information

• Fixed component name

  MIGRATION UTILI

• Fixed component ID

  5697N4400

Applicable component levels

• R410 PSY UI19652

     UP14/07/22 P F407

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.