SELECT without a TABLE (JDBC)
jdbc, openedge, sql
Solution
Single row/column Dual equivalent; `SYSPROGRESS.SYSCALCTABLE`
Problem
In most sql databases I have seen you can do something like: ``` SELECT ABS(-2.4) ``` and I get back 2.4. Notice there is no FROM clause. When I try to do this in OpenEdge via Squirrel and the JDBC driver I get a syntax error. Is there a way to run SELECT statements like this (sans FROM clause) via JDBC?