PM96192: SQLCODE804 WHEN CHAR FIELD DEFINED IN STORED PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Receive SQLCODE -804 when a CHAR field is defined to a stored
  procedure and in the CALL statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V10 and V11 users       *
  *                 who CALL stored procedures.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a CHAR parameter in a CALL to a      *
  *                      stored procedure was represented by     *
  *                      a global variable, the CALL could       *
  *                      fail with SQLCODE: -804                 *
  *                      SQLERRM: 09 "Invalid length for input   *
  *                      variable."                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The length of CHAR parameters being passed to DB2 in a stored
  procedure CALL was being incorrectly calculated if the
  parameter was represented by a global variable.
  

Problem conclusion

• QMF code has been amended to determine the correct length of
  parameters.
  

Temporary fix

Comments

• ž**** PE14/04/24 FIX IN ERROR. SEE APAR PI16714  FOR DESCRIPTION
  

APAR Information

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

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

  UI12043 UI12044 UI12111

Modules/Macros

• DSQDCALL DSQDCPAR DSQDCVAL DSQGPSQM DSQGPSQS DSQGPSQX DSQHPSQM
  DSQHPSQS DSQIPSQM DSQIPSQS DSQIPSQX
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UI12111

     UP13/11/06 P F311

• RB10 PSY UI12044

     UP13/11/05 P F311

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.