IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error code -180


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gomu_mm

New User


Joined: 05 Dec 2006
Posts: 19
Location: Chennai

PostPosted: Fri May 01, 2009 1:26 am
Reply with quote

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
View user's profile Send private message
a027412

New User


Joined: 05 Jul 2007
Posts: 40
Location: Minneapolis, MN

PostPosted: Fri May 01, 2009 2:23 am
Reply with quote

Try using CURRENT_DATE instead of CURRENT DATE
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri May 01, 2009 2:31 am
Reply with quote

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
View user's profile Send private message
gomu_mm

New User


Joined: 05 Dec 2006
Posts: 19
Location: Chennai

PostPosted: Fri May 15, 2009 1:18 pm
Reply with quote

Hi,

Thanks for your replies.
Its resolved now.


Thanks,
Gomathi.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri May 15, 2009 2:43 pm
Reply with quote

Thanks for the follow up... icon_smile.gif

Plesae share your solution, that might help others later.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
Search our Forums:

Back to Top