PM33750: DYNAMIC SQL DOES NOT SUPPORT "SET :&HVAR = CURRENT DATE/TIME" AND "VALUES &VAL INTO :&HVAR"

APAR status

• Closed as unreproducible in next release.

Error description

• Per PMR 44797,999,000  - Dynamic SQL does not support "SET
  :&hvar = CURRENT DATE/TIME" and "VALUES &val INTO :&hvar"
  
  ===============================================================
  Date reported: 02/10/2011
  
  Severity: high
  
  Users Affected:
   All IMU users of MU V3.2 and prior versions
  
  Problem Description:
   Customer is complaining that SQL SET :&hvars = CURRENT
   DATE/TIME does not work in Dynamic SQL Mode
   Customer is complaining that SQL VALUES &val INTO :&hvar does
   not work in Dynamic SQL Mode
  
  Problem Summation
   DB2 does not support the SET and VALUES INTO statements in
   dynamic mode, therefore only selective variations
   of the SET/VALUES statement are simulated by IMU.
  
  Problem Conclusion:
   Logic to simulate additional SQL SET and SQL VALUES INTO syntax
   was added to the DYNAMSQL macro.
   Simulation is achieved by converting the above statements to
   "SQL SELECT" equivalent as per examples below.
  
   Example 1:
  
    SQL SET :WS-TIME = CURRENT TIME
             is converted to:
    SQL SELECT CURRENT TIME FROM SYSIBM.SYSDUMMY1 INTO :WS-TIME
  
     Example 2:
  
    SQL VALUES  'A' INTO :HOST-VAR
             is converted to:
    SQL SELECT 'A' FROM SYSIBM.SYSDUMMY1 INTO :HOST-VAR
  
  
    Caution: The simulated statements in Dynamic SQL mode consume
             more CPU cycles than STATIC SQL mode. Users are
             encouraged to run programs in STATIC mode whenever
             the simulated statements are repeatedly used in
             the progrm, i.e., a part of detail logic or loops.
  
  Impacted SFSYFJCC macros: DYNAMSQL
  ================================================================
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IMU v3.2 Users.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: DYNAMIC SQL does not support            *
  *                      "SET :&HVAR = CURRENT DATE/TIME"        *
  *                      and "VALUES &VAL INTO :&HVAR"           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• This problem is resolved by PTF UK66901.
  

APAR Information

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

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

Fix information

• Fixed component name

  MIGRATION UTILI

• Fixed component ID

  5697N4400

Applicable component levels

• R320 PSN

     UP