PK83145: QMF WILL NOT REFORMAT DATE OR TIME COLUMN DATA RETURNED THROUGH A STORED PROCEDURE RESULT SET.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QMF will not reformat DATE or TIME column data returned
  through a stored procedure result set.
  

Local fix

• No Work Around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V8.1 and V9.1 users     *
  *                 that CALL stored procedures which return     *
  *                 date or time data in a result set.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users invoking QMF for TSO/CICS in an   *
  *                      environment where the DSNHDECP DATE or  *
  *                      TIME formats are not set to ISO can     *
  *                      experience incorrect output when        *
  *                      CALLing stored procedures that return   *
  *                      DATE or TIME data in a result set. For  *
  *                      example, a user invokes QMF for         *
  *                      TSO/CICS in a database where the        *
  *                      DSNHDECP value DATE is set to 'USA'. He *
  *                      then CALLs a stored procedure that      *
  *                      returns date data in a result set. The  *
  *                      date data shown to the end user can     *
  *                      look something like: '/1/96/02/0'       *
  *                      rather than a correctly formatted USA   *
  *                      date format.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  QMF uses the precompile options DATE(ISO) and TIME(ISO) on all
  fetch related modules so that DB2 for z/OS will return all DATE
  and TIME data in ISO format. QMF then internally reformats all
  DATE and TIME data from ISO format to the format it finds when
  reading DSNHDECP upon QMF initialization. QMF was following this
  same logic for both fetch of SELECT statement reports and CALL
  statement result set reports. Unfortunately, the DATE and TIME
  precompile options are not valid with fetch of result set data.
  This led QMF to incorrectly format date and time result set data
  in the case of non-ISO defined databases. The underlying data is
  not corrupted.
  

Problem conclusion

• QMF has been modified to not reformat date or time data
  fetched through result sets. Date or time data fetched
  as a result of a CALL statement will be shown in the format
  determined by DB2 for z/OS. Because QMF cannot determine
  the format, users should not attempt to alter edit codes
  for date or time data returned from a result set. Unpredictable
  results can occur. In addition, users should not EXPORT DATA
  that is generated from a result set which contains date or time
  data in non-ISO format. The data will export successfully but
  will not be able to be imported. If the date or time data
  is in ISO format as returned by the result set, exporting of
  data is safe.
  

Temporary fix

Comments

• ž**** PE09/10/21 FIX IN ERROR. SEE APAR PK98476  FOR DESCRIPTION
  

APAR Information

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

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

  UK46559 UK46560

Modules/Macros

• DSQDCALL DSQEPSQ7 DSQEPSQ8 DSQFPSQX DSQFPSQ7
  DSQFPSQ8 DSQFRDAT DSQIPSQX DSQIPSQ7 DSQIPSQ8
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK46559

     UP09/05/15 P F905

• R910 PSY UK46560

     UP09/05/15 P F905

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.