Description
Lets you specify search conditions to limit the list of tables and views that displays in the Installed Database Interfaces Tables list in PowerBuilder. Setting this parameter can be useful if you are working with a very large database in the PowerBuilder development environment.
When to specify TableCriteria
You must specify the TableCriteria parameter before connecting to the database.
The TableCriteria parameter has no effect in a PowerBuilder application script.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
DIR SAP DirectConnect
ODBC
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
You specify the TableCriteria search conditions on the System page in the Database Profile Setup dialog box.
Default value
None. If you do not specify any values, the TableCriteria parameter is not used.
Oracle
If you do not specify a value for TableCriteria, all Oracle tables, views, and synonyms that you have permission to access display in the Installed Database Interfaces Tables list by default.
Usage
To specify the TableCriteria search conditions, enter information in the following boxes:
|
Field |
Description |
|---|---|
|
Table Name |
Specifies the names of tables to display in the current database. You can use wildcard characters. Default for DirectConnect interface If you omit this value when connected through the DirectConnect interface, PowerBuilder displays all tables that you have permission to access in the current database, as defined in the DirectConnect server configuration file. Default for Adaptive Server Enterprise interface If you omit this value when connected through the Adaptive Server Enterprise interface, PowerBuilder displays all tables in the current database. |
|
Table Owner |
Displays only those tables belonging to the specified table owner. You can use wildcard characters. If you omit this value, PowerBuilder displays all tables matching the table name that you have permission to access. |
|
Include Tables |
Specifies that tables should be displayed. |
|
Include Views |
Specifies that views should be displayed. |
|
Include System Tables |
Specifies that system tables should be displayed. |
Adaptive Server Enterprise and DirectConnect
These SAP database interfaces use stored procedures to create the table list:
-
DirectConnect interface
Uses the sp_tables stored procedure.
-
Adaptive Server Enterprise interface
Uses the version of the sp_pb190table stored procedure installed by you or your database administrator.
For information about which version of sp_pb190table to install when connecting to an Adaptive Server Enterprise database, see the section called “Installing stored procedures in Adaptive Server databases” in Connecting to Your Database.
PowerBuilder uses the TableCriteria parameter to supply the arguments to sp_tables or sp_pb190table and build the table list based on your search criteria.
Examples
Type QADB% in the Table Name box and DWMC31 in the Table Owner box on the System page in the Database Profile Setup dialog box to set the Table Criteria property to:
TableCriteria='QADB%,DWMC31'
