Format Date Displayed

Document ID : KB000016419
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Default values can be defined for various RC/Edit settings:

- Whether authorization should be checked before a user enters RC/Edit
- The date and time formats (for browse and edit sessions)
- Comma formatting for numeric data
- Capitalization conversion for character data
- The edit method for RC/Edit and RC/Browse
- How often to commit changes during a Fast Edit
- Whether the Edit Table selection panel appears when you exit an RI/Edit session
- The way you edit views
- String delimiter characters for varying character columns of tables
- Asynchronous background fetch options

Default configuration values can be set for RC/Edit and RC/Browse in the RCEDIT and DEFAULTS members of hlq.CDBAPARM. These parameters affect RC/Edit and RC/Browse.

Question:

In the hlq.CDBAPARM(DEFAULTS) , UDATE and UTIME values, the format date is EUR but when we display a table it shows the date format is in ISO format.

What have I missed?

Environment:
DB2 for z/os
Answer:

Use the PROFILE command while browsing the table and selecting :
3 - RC/Edit Profile Variables

Check/Amend the following fields to match the required format:
Date format for RC/EDIT BROWSE       ==> ???   ISO,USA,EUR,JIS or LOCAL
Time format for RC/EDIT BROWSE       ==> ???   ISO,USA,EUR,JIS or LOCAL

 

The values stored in the users PROFILE are saved on the users ispf profile dataset. These override the values in the hlq.CDBAPARM(DEFAULTS) member for a given user.

Additional Information: