I am relatively new to DB2 but not to SQL. I am experiencing the below error when trying a SELECT
statement while subtracting a few minutes from a timestamp
:
SELECT * TCCAWZTXD.TCC_COIL_DEMODATA
WHERE CURRENT_INSERTTIME BETWEEN(CURRENT_TIMESTAMP)-5 minutes AND CURRENT_TIMESTAMP
The error that I am experiencing is:
DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,
SQLERRMC=TCCAWZTXD;SELECT*;, DRIVER=3.66.46
How can I fix this error?
Best Answer
You miss the
from
clause