Hi,

In the databse the date field is define as

STARTDATE SYSIBM DATE 4 0 Yes
ENDDATE SYSIBM DATE 4 0 Yes

but the data coming as input is in mm/dd/yyyy format.

The date field is always not updated in table. Si it because of this length issue?

Date fields only take up 4 bytes of storage. That is how they are stored. When the information is presented to you it is shown in a format thay you will understand (mm/dd/yyyy). It is not stored that way. DB2 converts it to and from your human readable format to its internal format automatically.

Why the date field is not always updated is a separate issue. Do you get any error code? If so what is it? Also list your DB2 version and OS.

Andy

When inserting date values, it is best to use the ISO format that DB2 will always understand regardless of the territory code of the client or database server you have.

'YYYY-MM-DD'

If you want to retreive data in that format, you can use:
select CHAR(BIRTHDATE, ISO) from employee;