Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in


Timestamp mismatch question

Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Warnings : 1

New User

Joined: 16 Jan 2007
Posts: 11
Location: Bangalore

PostPosted: Tue Jul 01, 2008 2:50 pm    Post subject: Reply to: Explain db2 precompiler process
Reply with quote

if you are modifying the program and if you are not binding it, you will get a timestamp mismatch error.


Ur comment is fine about If anything changed in the modified source code, without rebind , We'll get timestamo mismatch, but one more part is pending in the question, Without changing anything in the code, If I rebind , Will I get timestamp mismatch error? Pls clarify.
Back to top
View user's profile Send private message


New User

Joined: 21 Jun 2007
Posts: 28
Location: pune

PostPosted: Wed Jul 02, 2008 3:03 pm    Post subject: reply ...
Reply with quote

hi chandrupegasus,

Plz try to understand the compilation procedure of a COBOL-DB2 program. When you compile your program the precompiler will replace the SQL code with COBOL Call statement where it provides a timestamp to identify the SQL statements later on.
So If you compile your program even without making any changes in your code you need to BIND it again as the precompiler has put different Timestamp over there.
If you haven't compiled it then the timestamp in the DBRM and the program will always be the same. Hence no need of bind it again.

Back to top
View user's profile Send private message
rakhi asthana

New User

Joined: 24 Oct 2007
Posts: 1
Location: pune

PostPosted: Sat Jul 03, 2010 6:10 pm    Post subject:
Reply with quote

thanks for your information!!
Back to top
View user's profile Send private message
Anurag Paul

New User

Joined: 12 Feb 2011
Posts: 1
Location: Chennai

PostPosted: Sat Feb 12, 2011 10:53 am    Post subject: Reply to: Timestamp mismatch question
Reply with quote

But what about the time stamp error in DB2 when we are using it in a cics program????

I am putting breakpoints in the module and giving values for a particular timestamp for a record in DB2 , but its showing a -180 sqlcode.... whenever its matching with the record
Back to top
View user's profile Send private message
dick scherrer

Site Director

Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Feb 12, 2011 11:21 am    Post subject:
Reply with quote

Hello and welcome to the forum,

Why do you believe your problem is related to this topic? It is not. . .

Did you look up the -180 sql code? I suppose not. . .

From the manual:

Explanation: The length or string representation of a DATE, TIME, or TIMESTAMP value does not conform to any valid format.
Suggest you give proper values rather than invalid values.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1


Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fault Analyzer - listings question. egrove IBM Tools 4 Thu Aug 11, 2016 5:31 pm
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 pm
No new posts Converting EBCDIC to Unicode (TimeStamp) muralikrishnan_new COBOL Programming 2 Mon Jul 25, 2016 10:42 pm
No new posts Convert Timestamp Value mrdinesh DFSORT/ICETOOL 7 Thu May 05, 2016 6:01 pm
No new posts SQL Order By related question Joseph K Thomas DB2 8 Fri Mar 18, 2016 12:53 pm

Back to Top
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us