Is it possible to query Progress meta schema via ODBC? I have a meta schema table called _aud-audit-data that I would like to run a query against. I can query it with the Procedure Editor and DataDigger using a standard query:
I'm used to being able to query default schema tables through ODBC using the 'pub.' syntax, but using pub._aud-audit-data in the above query doesn't work - I'm guessing this is because I'm trying to access meta schema. I've tried using '_db.' and 'databasename.' in its place, but that hasn't worked. Can I run this query via ODBC, and if so, what do I need to do?
Code:
SELECT * from _aud-audit-data where _user-id='something'