View previous topic :: View next topic
|
Author |
Message |
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. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
In our shop we used to take default value as 01-01-1900 |
|
Back to top |
|
|
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). |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
|