View previous topic :: View next topic
|
Author |
Message |
gomu_mm
New User
Joined: 05 Dec 2006 Posts: 19 Location: Chennai
|
|
|
|
Hi,
I have a field in a table as DATE, and I'm trying to insert previous day's date to that field through COBOL program. I'm using the field as
DATE(CURRENT DATE - 1 DAYS)
this is working when I try to insert through SPUFI but the same does not work when tried thru program. It gives -180 abend.
Please help.
Thanks,
Gomathi. |
|
Back to top |
|
|
a027412
New User
Joined: 05 Jul 2007 Posts: 40 Location: Minneapolis, MN
|
|
|
|
Try using CURRENT_DATE instead of CURRENT DATE |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
-180 says that the DATE TIME OR TIMESTAMP value is invalid. Please show us the "actual" COBOL code you use. Please don't post the "screen shot" of code instead use BBcode. |
|
Back to top |
|
|
gomu_mm
New User
Joined: 05 Dec 2006 Posts: 19 Location: Chennai
|
|
|
|
Hi,
Thanks for your replies.
Its resolved now.
Thanks,
Gomathi. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Thanks for the follow up...
Plesae share your solution, that might help others later. |
|
Back to top |
|
|
|