- What is being requested:
Ability to filter System Schemas and System Views within results from getSchemas and getTables when using the Progress JDBC drivers
- Reason for request:
In our application we have functionality that provides an option to the user to import the metadata after connecting to a datasource. Customer is trying to import metadata from the SQL Server and the DB2 data sources and we are getting the information for the System Schemas and the System Views along with the user-created schemas and views. There is no option to filter out these from the output returned by the API.
- Possible workarounds:
Users would need to code their own SQL or other DB calls to determine which Schemas and Views are System and which are User.