D3l_Gato
D3l_Gato

Reputation: 1329

SELECT @@VERSION in Progress OpenEdge?

I havent been able to find this in the docs so it may not exist - does openedge have a SELECT @@VERSION type of query to return the DB version?

Thanks!

Upvotes: 0

Views: 652

Answers (2)

Tom Bascom
Tom Bascom

Reputation: 14020

You can get the version indirectly by querying _dbstatus._dbStatus-ShmVers

The mapping of _dbStatus-ShmVers to actual version numbers is described in this kbase: https://knowledgebase.progress.com/articles/Article/P39456

Upvotes: 2

Austin
Austin

Reputation: 1255

No, there is no such query that returns the OpenEdge database version. As an alternate, a User Defined Function (UDF) can be written to return the version information. This article describes the ways to get OpenEdge database version. You can use one of these approaches in the UDF to get the database version. UDF examples can be found here.

Upvotes: 1

Related Questions