Hi,
The .p files can be exposed through the AppServer or a WebService, I know.
But, is there any way i call them through the odbc driver ?
"exec getSomeData.p" ?
I need to access information in QAD (ERP system that runs on Progress/OpenEdge) in a program that can fetch data (only) through a odbc driver.
I would like to call the .p file (or something similar) instead of knowing too much about tablenames etc inside the ERP system.
Any chances this will work for me ?
/Troels
Sorry, but our ODBC interface accepts SQL database access commands and sends them directly to a OpenEdge SQL processor which then sends back data from the database. There is nothing in that path that knows anything about the 4GL, only data in the database.
Not sure, if that's feasible, but here's JDBC driver that executes ABL .p files: http://www.ganimede.ro/cms/products/abl-jdbc/
And then with a ODBC to JDBC bridge like http://uda.openlinksw.com/odbc-jdbc-st/
I was not aware of the jdbc driver that executes 4GL. Interesting.
Probably worth asking somebody at QAD if they have a way to get whatever data you need before doing anything else.
thx , both of you
gus wrote:
I was not aware of the jdbc driver that executes 4GL. Interesting.
it does require appserver though but the engine used is the 4GL one instead of SQL