Integration Server 10.5 | WmDB User’s Guide | Accessing Databases with Services | Creating Database Flow Services | Generating a Database Flow Service from a Table | Restricting the List of Database Tables
 
Restricting the List of Database Tables
You can restrict the list of database tables that the server displays by specifying one or more of the following:
*Catalog. You specify the name of the catalog whose tables you want to use.
*If you are not working with a distributed database, do not restrict by catalog.
*If you are working with a distributed database, you can specify the name of the database with which you want to work. If you are using DB2, use this field to specify the name of a DB2 location.
*Schema pattern. You specify the schemas whose tables you want to work with (if you are using DB2, use this field to specify an AuthID).
*If you want tables for all schemas in the selected database, do not restrict by schema pattern.
*If you want to restrict your search to tables by selected schemas, specify the schema name. You can specify a pattern-matching string if your JDBC supports it. Most drivers support the pattern-matching characters described for Table name pattern below; however, check your driver’s documentation for information about its pattern-matching capabilities.
*Table name pattern. You specify the names of the tables with which you want to work. Specify a table name or a pattern-matching string that specifies the names of the tables. Most drivers support the following pattern-matching characters; however, check your driver’s documentation for information about its pattern-matching capabilities.
Use
To match
For example
%
Any string of characters
HR% matches: HR30all, HR15mgmt, HR01payroll, and so forth.
_
A single character
HR3_mgmt matches: HR30mgmt, HR31mgmt, HR3Amgmt, and so forth.
*Table type. The type of the tables for which you want information. You can choose from the following common JDBC table types: Table, View, System Table, Global Temporary, Local Temporary, Alias, and Synonym.