Default value to a DATE field in DB2 database?

ibmforum · New User Joined: 20 Jun 2006 Posts: 2

All:

In my DB2 database a field is declared as DATE field.
my requirement is to move default values to this field.

so can i move SPACES to a DATE field? and will it not result in SOC7 when i try to move this spaces in DATE field to working storage variable.

Please advise if i need to move zeroes or some other predefined value as default to this DATE field.

Thanks.

guptae · Posted: Tue Jun 27, 2006 3:00 pm

In our shop we used to take default value as 01-01-1900

subbareddy46 · New User Joined: 30 May 2006 Posts: 4

yes,
we can move spaces as default to date field in db2.
b'coz the pic clause of date equivalent in cobol is pic x(10).

ibmforum · New User Joined: 20 Jun 2006 Posts: 2

But guys when i want to update spaces to the DB2 table, will it work?

i am facing problem now with sqlcode of -180, proabably spaces are not allowed to be directly stored in DB2 table.

so i believe we need to update 0001-01-01 as default to the DB2 tale.

Thanks.