Setting Up SQL Access

The following suggestions are useful when setting up SQL access to CA IDMS databases:

To access a non-SQL-defined database using SQL, define an SQL schema that identifies the network schema and the segment where the data is stored. The network schema must conform to the rules described throughout this chapter.
If the application does not qualify table references with schema names, define one or more CA IDMS/DC profiles that set a default schema name. You may need to ask your Database Administrator (DBA) for assistance.
To limit the size of the list of tables returned by the driver metadata functions, create an Accessible Tables View that returns a subset of the default view, and set it as an option for a specific data source. Using such a view of accessible tables can generate a more meaningful list of tables for each user and improve performance.
Define views in the catalog to provide easy access to non-SQL-defined databases or application-specific data. For example, consider using a view when joining tables using the set-name condition. However, if you choose to do so, remember that views created by joining two or more tables cannot be updated.
Implement table procedures to provide easy access to non-SQL-defined databases or application-specific data. For example, consider using a table procedure to navigate a complicated network database. Table procedures can also be used to update databases.