CODEWITHSUNDEEP
openedgeprogress-4glprogress-db
Abhishek C
Abhishek C

Reputation: 13

What is the query for getting database name in Progress-OpenEdge?

How can we get database name in progress openedge like in SQL we can get database name by using show databases; or SELECT schema_name FROM information_schema.schemata; using SQL query to openedge DB.

Upvotes: 0

Views: 1590

Answers (3)

Tom Bascom
Tom Bascom

Reputation: 14020

Just in case the link to "Progress Communities" goes away:

Valeriy Bashkatov (Progress Technologies LLC)

You should run this with a DBA privileged user.

select * from sysprogress.SYSTABLES;

select * from sysprogress.SYSTABLES_FULL;

select * from sysprogress.SYSCOLUMNS where TBL = 'table_name';

select * from sysprogress.SYSCOLUMNS_FULL where TBL = 'table_name';

Upvotes: 0

Austin
Austin

Reputation: 1255

select db_name() from sysprogress.syscalctable;

Upvotes: 0

Mike Fechner
Mike Fechner

Reputation: 7237

In ABL you can

DEFINE VARIABLE i AS INTEGER     NO-UNDO.

DO i = 1 TO NUM-DBS:
    MESSAGE LDBNAME (i) SKIP 
            PDBNAME (i) SKIP 
            DBPARAM (i)
        VIEW-AS ALERT-BOX INFORMATION BUTTONS OK.
END.

In OpenEdge SQL the SHOW CATALOGS command returns the database/catalog names:

https://docs.progress.com/bundle/openedge-sql-reference/page/SHOW-CATALOGS.html?_ga=2.234385114.558448476.1620632697-128156788.1596090319

SHOW CATALOGS PRO_NAME;

Upvotes: 1

Related Questions