[Stackoverflow] [Progress OpenEdge ABL] Select Column Names for OpenEdge-SQL

Status
Not open for further replies.
C

Cornelis

Guest
I'm using DBeaver to connect to Open-Edge 11 database which supports SQL functions. The functions used HERE don't work. Here is a single example and the result:

Function:

Code:
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'TxMSAGrading'

Error:

Code:
SQL Error [42S02]: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/view/synonynm "INFORMATION_SCHEMA.COLUMNS" cannot be found. (15814)

How can I get column names?

Continue reading...
 
Status
Not open for further replies.
Top