DB2 SQL error sqlcode=-104 sqlstate=42601

Question

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?

Side note: you generally shouldn't be using SELECT *. Explicitly list out the columns you're interested in. — Clockwork-Muse
– Clockwork-Muse, Commented Aug 11, 2015 at 12:54

jmsbrook · Accepted Answer · 2018-12-12 15:16:59Z

22

You miss the from clause

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

edited Dec 12, 2018 at 15:16

jmsbrook

156 bronze badges

answered Aug 11, 2015 at 11:14

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DB2 SQL error sqlcode=-104 sqlstate=42601

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related