Accessing system tables - ODBC

[UKStratfordMike]

Hi

Can anyone provide e.g sql code to access Progress Systems tables (via ODBC)

 

[egiblock]

as long as you have the odbc connection set up on your machine, you can link to it with microsoft access.

from there you can see all of the tables.


if you are using the sql explroer tool, you could run the following command to display the database administrators that are listed in the table sysprogress.sysdbauth



select * from sysprogress.sysdbauth