A fix is available
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 number
PM99098
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-10-15
Closed date
2013-11-27
Last modified date
2013-12-02
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
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
02 December 2013