DATE columns

In a File Manager/Db2 editor session, the display format for DATE columns depends on the setting of the DATE parameter in the Db2® DSNHDECP installation module. For further information, see your Db2® systems administrator, the Db2 UDB for z/OS SQL Reference, or other Db2® manuals.

If you edit a DATE column, you can enter a date in any format recognized by Db2®. FM/Db2 converts the date you enter into the appropriate display format. For example, to set the contents of a DATE column to represent September 27, 2004, you can enter 27.09.2004.

However, you need to be careful when choosing the separator character. If you try to enter 27/09/2004, FM/Db2 interprets 27 as a month and rejects the date as incorrect. A more subtle example is 08/05/1900 and 08.05.1900. FM/Db2 interprets the first as 5 August, 1900, but the second as May 8, 1900.