PBNoCatalog

Description

Specifies that DataWindow Designer will not check for the existence of catalog tables when creating a DataWindow object at runtime.

When to specify PBNoCatalog You must specify the PBNoCatalog parameter before connecting to the database.

Applies to

O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g

Syntax

PBNoCatalog='value'

Parameter	Description
value	Specifies that DataWindow Designer will not check for the existence of catalog tables when creating a DataWindow object at runtime.

Default

PBNoCatalog=‘NO’

Usage

When a DataWindow object is created dynamically using DataWindowSyntaxFromSql and modified so that it can use stored procedure updates, DataWindow Designer looks for the PowerBuilder catalog tables. If PBCatalogOwner is not set, DataWindow Designer looks for the catalog tables under the owner SYSTEM. The DataWindow created may be different depending on whether PBCatalogOwner was set, and errors may be generated if the tables do not exist under the owner SYSTEM. To prevent DataWindow Designer from using the catalog tables, set the PBNoCatalog parameter to true.

This parameter can also be set in the PBODB initialization file for connection to Oracle through the ODBC and OLE DB drivers.

This parameter cannot be set dynamically. The value set when the connection is made remains in effect until it is disconnected.

Examples

Example 1

To tell DataWindow Designer not to use catalog tables, type the following in code:

SQLCA.DbParameter="PBNoCatalog='Yes'"