SQL: SELECT * FROM TABLE-NAME WITH UR
Error: java.sql.SQLException: [IBM][CLI
Driver][DB2/LINUX] SQL0104N An unexpected token
"select * from TABLE_NAME wit" was found following
"BEGIN-OF-STATEMENT". Expected tokens may include:
"<query_expr_body>". SQLSTATE=42601, SQL State: 42601,
Error Code: -104
Driver: IBM DB2 JDBC Drivers
DB2 allows an isolation clause on its SQL. The clause
"WITH UR" prevents table locks from occurring on
The SQL will fail in Squirrel, but succeeds in other
applications using the same driver.
I'm not sure what more I can tell you. The UR
highlights Red in the SQL tab, while the WITH
I think Squirrel is thinking that the WITH should begin
the statement (creating a temporary table).
However, it is strange, because the error that is
generated is a CLI error.