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.

Controls

ASE, SYC SAP 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 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_pb126table stored procedure
installed by you or your database administrator.

For information about which version of sp_pb126table
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_pb126table 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 12.6

August 14, 2023

Was this article helpful?

TableCriteria – PB Docs 126