DB2 graphic  QMF Version 8

Locally defined date/time formats on z/OS

To define local formats, your installation creates two formatting routines. One of these, named DSNXVDTX, formats dates. The other, named DSNXVTMX, formats times. Creating these routines is a DB2 administration task. If you yourself must do it, see information on locally defined formats in the DB2 UDB for z/OS Administration Guide.

Specifying the format

When creating a report, a user can specify the local format for either type of data: TDL for dates; TTL for times. QMF does the formatting by calling the appropriate routine. You must ensure QMF can load both DSNXVTMX and DSNXVDTX.

Making the edit routine available

You can make these routines available by placing their load library in the STEPLIB concatenation of your users' JCL. Make certain that this library is searched before the DB2 program library. If the program library is searched first, QMF loads and uses two IBM-supplied stubs from the DB2 library. These stubs are meant to be used when no local formats are defined: they do no formatting at all. For example, the formatting routines are in the library XYZ.FORMAT. The library is properly placed in the STEPLIB statement in Figure 39, where the DB2 program library is DSN230.SDSQLOAD.

Figure 39. Making the edit routine available
//STEPLIB DD DSN=ISP.V2R2M0.ISPLOAD,DISP=SHR
//        DD DSN=ISR.V2R2M0.ISRLOAD,DISP=SHR
//        DD DSN=QMF710.SDSQLOAD,DISP=SHR
//        DD DSN=XYZ.FORMAT,DISP=SHR          (local formatting library)
//        DD DSN=DSN230.DSNLOAD,DISP=SHR      (DB2 program library)
//        DD DSN=GDDM.OSPID.GDDMLOAD,DISP=SHR


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004