SQLCODE -401 in a Date calculation.
Posted: Sat Sep 26, 2015 8:50 am
Hi,
I am using a query for date calculation in my COBOL Program. The query is like this:
where AKSTAP has the format like: 2015-09-15-01.13.32.563275
Could any one suggest how to correct the query, as I get SQLCODE -401 with above query.
Thanks in advance.
I am using a query for date calculation in my COBOL Program. The query is like this:
Code: Select all
SELECT * FROM TABLENAME
WHERE AKSTAMP >= CURRENT DATE - 3 YEARS;
Could any one suggest how to correct the query, as I get SQLCODE -401 with above query.
Thanks in advance.