DB2 Date error

[kpsita]

Hi,

I have a simple sql used in a DB2 enterprise stage. When I view data I am geting proper values for couple of date field. But when the same job accessing the same table in a different environment gives some default values like '1901-01-01' for those two date fields.The datatype is date for these fields.

Is it something related to environmental settings.

Thanks,

[DaleK]

... same table in a different environment gives some default values like '1901-01-01' for those two date fields.....

Have you querried the table from another tool to verify that those dates aren't really 1901-01-01 in the table in the 2nd environment? My first guess is a DB2 default value for a not nullable field.

Dale

[kiran0435]

I faced the issue when running a particular job in new environment.

It is null values that will be replaced by 1901-01-01. Then some patch was installed by Infrastructure support team which solved the problem.