ODBC Driver Implementation and Configuration › Configure Your ODBC Client › Set the ODBC Client Options › Define Masking for Tables and Views

Define Masking for Tables and Views

You can specify masking to limit the lists of tables and views presented for user selection. CA Datacom Server lets you limit the tables and views the server returns in response to the SQLTables function because when accessing mainframe CA Datacom/DB, these lists can be long. CA Datacom Server has a 300-column limit in a table that it can handle in a single result set, UPDATE, or SELECT request.

Note: When an application issues the SQLTables function to obtain a Table list, the application can specify a table mask. This application mask overrides the mask provided in this dialog except when it is a single wildcard character. Use string search patterns to provide flexibility.

To define table and view masking

1. Select the Masking button on the Options tab of the CA Datacom/DB ODBC Setup window.

   The Table Masking dialog appears.

2. Enter the Authid or table name to limit the tables and views to those associated with a specific SQL AUTHID.

   Note: Listed tables and views are also limited to those associated with a group of AUTHIDs when wildcard characters are used.

3. Enter a specific table or view name to limit the listed tables and views further.

   Note: Use wildcard characters to limit the listed tables and views to a subset of the tables and views associated with the specified AUTHID.

4. Click OK.

   The CA Datacom/DB ODBC Setup window appears.