Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SELECT without a TABLE (JDBC)

Tags:

sql

jdbc

openedge

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?

like image 720
Mike Cheel Avatar asked Jan 28 '14 16:01

Mike Cheel


1 Answers

Single row/column Dual equivalent; SYSPROGRESS.SYSCALCTABLE

like image 130
Alex K. Avatar answered Sep 25 '22 05:09

Alex K.