working with dates

Ask/Clarify the questions on EASYTRIEVE

Moderators: DikDude, Moderator Group

Post Reply
sucharita14
Member
Posts: 5
Joined: Thu Sep 03, 2015 11:15 pm

working with dates

Post by sucharita14 » Thu Oct 08, 2015 11:45 am

hello,
I have an issue. I embedded db2 query in an easytrieve program. The program is running currectly but when I am trying to check whether enddate is greater than current date in the where clause, it is throwing an -401 sqlcode error. The format of date in my table is dd.mm.yyyy
and the query which I wrote is where enddate>sysdate. And I assume that sysdate is in the format dd/mm/yyyy. What should I write in where clause then,
Can anyone please help me through this?

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others