TableCriteria

database parameter

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

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

For information about which version of sp_pb180table 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_pb180table 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'

1	TableCriteria='QADB%,DWMC31'

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2018

August 20, 2023

Was this article helpful?