PI07669: UNPROCESSED EXEC SQL STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PMR 89488,379,000 - UNPROCESSED EXEC SQL STATEMENT
  
  ====================================================
  Prerequisites - All PTFs to date
  
  Date reported: 12/06/2013
  
  Severity: High
  
  Users Affected:
   All IMU users of MU V4.1
  
  Problem Description:
   EXEC SQL CALL is ignered by the Dynamic SQL translator.
   The EXEC SQL is passed on to COBOL where it fails to compile.
  
  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 for
   immediate request.  A prepare statement is constructed to
   execute CALL in IMMEDIATE mode.
  
  Impact on existing users
   There is no impact on existing users.
  
  Impacted byte code macros:
  
   FSOFT01.V4R1M0.SFSYFJCC
     DYNAMSQL - existing macro
  
  Additional information:
  Host variable types recognized by DYNAMSQL are:
    CHARTYPE
    VARCTYPE
    VARLTYPE
    GTYPE
    VARGTYPE
    LVARGTYP
    FLOATYPE
    FLOATYPE
    DECTYPE
    INTTYPE
    HWTYPE;
  
   EXEC SQL &command  commands recognized by DYNAMSQL are:
  
  -- command --    -- comments ------
  -----------------------------------------------------
    ALTER
    ASSOCIATE
    CLOSE
    COMMIT
    CREATE
    DECLARE       (GLOBAL, TABLE, VARIABLE and STATEMENT are not
                   supported)
    DELETE
    DROP
    FETCH
    FREE
    GRANT
    HOLD
    INCLUDE
    INSERT
    LABEL
    LOCKL
    OPEN
    RELEASE
    RENAME
    REVOKE
    ROLLBACK
    SAVEPOINT
    SELECT
    SET          (some SET combinations are limited because they
                  do not work in Dynamic mode)
    VALUES
    CALL
    UPDATE
  ----------------------------------------------------------------
  ================================================================
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IMU V4.1 Users.                          *
  ****************************************************************
  * 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.  *
  ****************************************************************
  * 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 for
  immediate request.  A prepare statement is constructed to
  execute CALL in IMMEDIATE mode.
  
  Impact on existing users
  There is no impact on existing users.
  
  Additional information:
  Host variable types recognized by DYNAMSQL are:
    CHARTYPE
    VARCTYPE
    VARLTYPE
    GTYPE
    VARGTYPE
    LVARGTYP
    FLOATYPE
    FLOATYPE
    DECTYPE
    INTTYPE
    HWTYPE;
  
   EXEC SQL &command  commands recognized by DYNAMSQL are:
  
  -- command --    -- comments ------
  -----------------------------------------------------
    ALTER
    ASSOCIATE
    CLOSE
    COMMIT
    CREATE
    DECLARE       (GLOBAL, TABLE, VARIABLE and STATEMENT
                   are not supported)
    DELETE
    DROP
    FETCH
    FREE
    GRANT
    HOLD
    INCLUDE
    INSERT
    LABEL
    LOCKL
    OPEN
    RELEASE
    RENAME
    REVOKE
    ROLLBACK
    SAVEPOINT
    SELECT
    SET          (some SET combinations are limited because they
                  do not work in Dynamic mode)
    VALUES
    CALL
    UPDATE
  -----------------------------------------------------------
  

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
  

Fix information

• Fixed component name

  MIGRATION UTILI

• Fixed component ID

  5697N4400

Applicable component levels

• R410 PSY UI14634

     UP14/01/31 P F401

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.