Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 JES2 EXIT 6 QUESTION Randy Horowitz All Other Mainframe Topics 30 Tue Feb 06, 2018 5:47 pm
This topic is locked: you cannot edit posts or make replies. UTC Timestamp Log Thangavel COBOL Programming 5 Mon Jan 22, 2018 9:04 pm
No new posts COMP Variables Mismatch gayu7 COBOL Programming 5 Wed Dec 20, 2017 5:06 pm
No new posts question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am

Back to Top
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us