SELECT without a TABLE (JDBC)

[Mike Cheel]

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?

Continue reading...