PM99098: DSQ50973 THE LOCAL DATE/TIME ROUTINE DSNXVDTX ISSUES RETURN CODE-258

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSQ50973 The local date/time routine DSNXVDTX issues return code
  -258
  
  MSGDSQ50973
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS users with a local DB2  *
  *                 time or date exit that use the table editor. *
  ****************************************************************
  * PROBLEM DESCRIPTION: A user had started DB2 for z/OS with a  *
  *                      local date exit (DSNXVDTX) available    *
  *                      but had their DSNHDECP configured to    *
  *                      use DATE=USA (a DB2 defined date        *
  *                      format) along with DATELEN=18 (the      *
  *                      length of their local date format).     *
  *                      When using the QMF EDIT TABLE command   *
  *                      on a table containing a date column,    *
  *                      the table editor showed the date format *
  *                      in the locally defined format. If an    *
  *                      invalid date format was entered in the  *
  *                      table editor, during validation of the  *
  *                      format the user received: "The local    *
  *                      date/time routine DSNXVDTX gave return  *
  *                      code  -258." (DSQ50973).                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  As documented by DB2, if using a locally defined date format,
  DSNHDECP should have variable DATE set to a value of LOCAL and
  DATELEN should be the maximum length of the local format.  If
  using a DB2 defined format such as USA, ISO, JIS or EUR, then
  DATELEN should be 0.  (QMF determines the values that were
  defined in DSNHDECP DATE and DATELEN values from the session
  variables SYSIBM.DATE_FORMAT and SYSIBM.DATE_LENGTH.)  In the
  situation for this user, QMF was displaying date formats in the
  USA format but when it got to the table editor, QMF displayed
  the date in the local format and then subsequently validated the
  date incorrectly. QMF has been fixed to display the date in the
  DB2 defined format (in this case USA) in configuration
  situations such as this.
  

Problem conclusion

• QMF has been amended to display the date in the
  DB2-defined format in configurations such as that
  described in the PROBLEM DESCRIPTION. A correct configuration
  should follow these rules: If a locally defined date
  format is being used, the DSNHDECP variable DATE should be set
  to LOCAL, and DATELEN should be the maximum length of the local
  format.  If a DB2-defined format such as USA, ISO, JIS or EUR
  is used, DATELEN should be 0.
  QMF will now display date and time formats in the DB2-defined
  format defined in DSNHDECP DATE(SYSIBM.DATE_FORMAT) and
  DSNHDECP TIME (SYSIBM.TIME_FORMAT).
  QMF will use these formats as the default formats for reports
  and the Table Editor. When a DATELEN or TIMELEN is found along
  with a DB2-defined format (rather than the word LOCAL), QMF will
  allow the change to the local-defined format via the
  TDL or TTL edit code.
  

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:

  UI13046 UI13047

Modules/Macros

• DSQGDRCI
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UI13046

     UP13/11/28 P F311

• RB10 PSY UI13047

     UP13/11/28 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.