DB2 SQL 错误 sqlcode=-104 sqlstate=42601
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/31940220/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
DB2 SQL error sqlcode=-104 sqlstate=42601
提问by Lawrence
I am relatively new to DB2 but not to SQL. I am experiencing the below error when trying a SELECTstatement while subtracting a few minutes from a timestamp:
我对 DB2 比较陌生，但对 SQL 不是。SELECT在从 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
DB2 SQL 错误：SQLCODE=-104，SQLSTATE=42601，SQLERRMC=TCCAWZTXD;SELECT*;，DRIVER=3.66.46
How can I fix this error?
我该如何解决这个错误？
回答by Jens
You miss the fromclause
你错过了from条款
SELECT * from TCCAWZTXD.TCC_COIL_DEMODATA WHERE CURRENT_INSERTTIME BETWEEN(CURRENT_TIMESTAMP)-5 minutes AND CURRENT_TIMESTAMP
