PI99456: CREATE QMF GLOBAL VARIABLE TOGGLE FOR DSQSFISO

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Add ability to change DSQSFISO program parameter from within a
  QMF session by adding new global variable DSQEC_DSQSFISO.
  
  DSQSFISO allows users to change default formatting of function
  CHAR(datetime-expression) data to match their local Db2 date and
  time formats.
  
  QMF defaults had always returned CHAR(datetime-expression) data
  in ISO format.
  
  DSQSFISO allowed override of this default but restricted the
  override to be specified on initialization of QMF.
  
  The addition of global variable DSQEC_DSQSFISO allows individual
  users to make the behavior change as needed with no QMF
  administrator involved.
  
  
  For example, if the DATE FORMAT on my Db2 subsystem is USA and
  global variable DSQEC_DSQSFISO is set to a value of '0', running
  the following query:
  
  SELECT CHAR(CURRENT DATE) FROM SYSIBM.SYSDUMMY1
  
  will produce a report with the current date formatted in USA
  format as follows:
  
  COL1
  ----------
  06/20/2018
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V12.1 users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds new function to QMF for  *
  *                      TSO and CICS V12.1. This fix adds new   *
  *                      global variable DSQEC_DSQSFISO which    *
  *                      gives users the ability to change the   *
  *                      DSQSFISO program parameter from within  *
  *                      a QMF session.                          *
  *                                                              *
  *                      QMF V11.2 introduced program parameter  *
  *                      DSQSFISO. DSQSFISO allows users to      *
  *                      change default formatting of function   *
  *                      CHAR(datetime-expression) data to match *
  *                      their local Db2 date and time formats.  *
  *                                                              *
  *                      QMF defaults had always returned        *
  *                      CHAR(datetime-expression) data in ISO   *
  *                      format.                                 *
  *                                                              *
  *                      DSQSFISO allowed override of this       *
  *                      default but restricted the override to  *
  *                      be specified on initialization of QMF.  *
  *                                                              *
  *                      The addition of global variable         *
  *                      DSQEC_DSQSFISO allows individual users  *
  *                      to make the behavior change as needed   *
  *                      within a QMF session with no QMF        *
  *                      administrator involved.                 *
  *                                                              *
  *                      For example, if the DATE FORMAT on my   *
  *                      Db2 subsystem is USA and global         *
  *                      variable DSQEC_DSQSFISO is set to a     *
  *                      value of '0', running the following     *
  *                      query:                                  *
  *                                                              *
  *                      SELECT CHAR(CURRENT DATE) FROM          *
  *                      SYSIBM.SYSDUMMY1                        *
  *                                                              *
  *                      will produce a report with the current  *
  *                      date formatted in USA format as         *
  *                      follows:                                *
  *                                                              *
  *                      COL1                                    *
  *                      ----------                              *
  *                      06/20/2018                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  One new global variable DSQEC_DSQSFISO is added.
  
  DSQEC_DSQSFISO (length of 1):
  
  Specifies the format of CHAR(datetime-expression)
  data within a QMF report.
  
  The following values are used:
  
  0 - The result of CHAR(datetime-expression) data
      is in the format specified in the DATE FORMAT
      and TIME FORMAT fields on Db2 installation
      panel DSNTIP4. The current Db2 DATE and TIME
      format values can be found by referencing global
      variables DSQAO_DATE_FORMAT and DSQAO_TIME_FORMAT.
  
  1 - The result of CHAR(datetime-expression) data
      is in ISO format.
  
  DSQEC_DSQSFISO takes its default value from the
  value of program parameter DSQSFISO. The DSQSFISO
  program parameter setting may be seen in state
  global variable DSQAO_DSQSFISO. Note that if
  DSQEC_DSQSFISO is modified, the value of
  DSQAO_DSQSFISO will not change. DSQEC_DSQSFISO
  should be referenced for the current behavior
  settings.
  
  Message DSQ51247 is added to remind the user that
  the QMF data object must be reset prior to changing
  the DSQEC_DSQSFISO global variable.
  
  As the QMF DSQPNLE panel library is updated
  with this change, the service level found on
  the 'About QMF' panel is updated to show
  APAR number PI99456. The 'About QMF' panel is
  accessed from option 17 from the main QMF
  Help tree.
  
  The QMF 12 publications have been updated with this
  information as well as much more detail.
  

Problem conclusion

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:

  UI56793

Modules/Macros

•    DSQCELTT DSQCGVSI DSQCPARM DSQCRSNC DSQCSETS
  DSQPNLE
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RC10 PSY UI56793

     UP18/06/26 P F806

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.