MVSFORUMS.com

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Could any one suggest how to correct the following query for which i am getting -401 error:

Herein I am trying to get the data of 5yrs from current date.

SELECT * FROM TABLENAME
WHERE UPSTAMP >= CURRENT DATE - 5 YEARS;

Thanks in advance.
_________________
Satya

kolusu · Posted: Mon Jul 14, 2008 11:22 am Post subject:

satyenderd,

I am guessing that UPSTAMP is a Timestamp field and you are trying to compare it with a date. It is incompatible. Check this link for explanation of -401

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCJ12/2.3.152?

If UPSTAMP is indeed a timestamp field then try using

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

..and timestamp is in the following format

2002-01-15-01.14.42.563275

Thanks in advance
_________________
Satya

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Kolusu,

Thanks a lot for your quick reply.

Thank once again.

Its working fine now..

Have a nice day.
_________________
Satya

Eric.C.Bakke · Posted: Mon Jul 14, 2008 5:37 pm Post subject:

Or better, try

Code:

WHERE UPSTAMP >= CURRENT TIMESTAMP - 5 YEARS;
_________________
Eric C. Bakke
Senior DB2 DBA

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Thanks Eric
_________________
Satya