Reputation: 141
Is there any way to execute a Progress query (4GL) using JDBC or ODBC in a Java project?
I've connected to the database and have to query the database using Progress (4GL). But the JDBC / ODBC only supports SQL queries, so it gives a syntax error.
Open Edge Database Version: 11.3.2
Upvotes: 0
Views: 1067
Reputation: 3251
JDBC/ODBC is SQL-only.
If you want a Progress style query, you need to make a Webspeed, WSA or REST connection and pass the query string to the server-side software to execute the query.
For a WSA / REST call, this'll require an appserver, with an attendant license. You may be able to get away with using Ganimede or Blue Diamond as a webspeed client if you're doing local dev work.
Upvotes: 1