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?
Ask/Clarify the questions on EASYTRIEVE
1 post • Page 1 of 1
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.
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program
- FILEAID Reference
Explains how to browse , edit and delete datasets
- Change Man Reference
Quick Start tutorial on Changeman
- Abend Reference
Important Abend codes explained
- FaceBook Page
MainframeGurukul FaceBook Page
- LinkedIn Page
MainframeGurkul Linkedin Page