DB2 SQL error sqlcode=-104 sqlstate=42601

Question

I am almost new to DB2 but not to SQL. I am encountering the below error when attempting 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

Below is the error that I am getting:

DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=TCCAWZTXD;SELECT*;, DRIVER=3.66.46

How can I fix this error?

Answer 1

Here, In the statement which you had mentioned above, you're missing the from clause.

So it should be like this,

SELECT *  from TCCAWZTXD.TCC_COIL_DEMODATA WHERE CURRENT_INSERTTIME  BETWEEN(CURRENT_TIMESTAMP)-5 minutes AND CURRENT_TIMESTAMP

Looking for a SQL Tutorial? Join the SQL Course to gain more knowledge on SQL.