TableCriteria

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 Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
JDB JDBC
ODBC
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g

Syntax

You specify the TableCriteria search conditions on the System page in the Database Profile Setup dialog box.

Default

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 Sybase 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_pb125table stored procedure installed by you or your database administrator.

For information about which version of sp_pb125table to install when connecting to an Adaptive Server Enterprise database, see “Installing PowerBuilder stored procedures in Adaptive Server Enterprise databases” in Connecting to Your Database.

PowerBuilder uses the TableCriteria parameter to supply the arguments to sp_tables or sp_pb125table and build the table list based on your search criteria.

Examples

Example 1

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'