PBNoCatalog – PB Docs 126

PBNoCatalog database parameter

Description

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

note.png When to specify PBNoCatalog

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

Controls

  • O90 Oracle9i

  • O10 Oracle 10g

  • ORA Oracle 11g

Syntax

Parameter

Description

value

Specifies that PowerBuilder 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, PowerBuilder looks for
the PowerBuilder catalog tables. If PBCatalogOwner is not set, PowerBuilder 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 PowerBuilder 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

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

See Also

PBCatalogOwner


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x