PBCatalogOwner

Description

Specifies a nondefault owner for the extended attribute system tables. These five tables contain default extended attribute information for your database.

When you specify a PBCatalogOwner name that is different from the default owner for your DBMS, PowerBuilder creates a new set of tables with the owner name you specify.

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

Applies to

ADO.NET
DIR Sybase DirectConnect
JDB JDBC
ODBC
OLE DB
O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g
SYC and SYJ Sybase Adaptive Server Enterprise

Syntax

PBCatalogOwner = 'owner_name'

Parameter	Description
owner_name	Specifies the owner of the extended attribute system tables. For DB2 databases If you use the DB2SYSPB.SQL script to create the extended attribute system tables in a DB2 database and replace all instances of PBOwner in the script with the name of a nondefault table owner, owner_name must be the same as the owner specified in the DB2SYSPB.SQL script.

Parameter

Description

owner_name

Specifies the owner of the extended attribute system tables.

For DB2 databases If you use the DB2SYSPB.SQL script to create the extended attribute system tables in a DB2 database and replace all instances of PBOwner in the script with the name of a nondefault table owner, owner_name must be the same as the owner specified in the DB2SYSPB.SQL script.

Default

The default value for PBCatalogOwner depends on the DBMS you are accessing, as follows:

DBMS	PBCatalogOwner default value
ADO.NET	If a value for PBCatalogOwner is not specified in the database profile or in the registry, the default value is the user ID specified in the database profile.
JDBC	If a value for PBCatalogOwner is not specified in the database profile or in the registry, the default value is the user ID specified in the database profile.
ODBC	If a value for PBCatalogOwner is not specified in the database profile or in the PBODBn0 initialization file, the default value is the user ID specified in the database profile.
OLE DB	If a value for PBCatalogOwner is not specified in the database profile or in the registry, the default value is the user ID specified in the database profile.
Oracle	PBCatalogOwner = 'SYSTEM'
Sybase Adaptive Server Enterprise	PBCatalogOwner = 'dbo'
Sybase DirectConnect	PBCatalogOwner = 'sqlca.logid'

Usage

When to set When you specify a nondefault owner for the extended attribute system tables, you are in effect creating alternative tables. This is useful if you want to test new validation rules or display formats without overwriting the extended attributes currently in the default tables.

JDBC databases When you connect to a JDBC database and a value for PBCatalogOwner is set in both the database profile and the registry, the setting in the profile overrides the setting in the registry.

ODBC data sources When you connect to an ODBC data source and a value for PBCatalogOwner is set in both the database profile and the PBODB105 initialization file, the setting in the profile overrides the setting in the PBODB105 initialization file.

DB2 databases When you connect to a DB2 database, you can use the DB2SYSPB.SQL script to create the extended attribute system tables. If you use the DB2SYSPB.SQL script, keep the following in mind:

You can edit the script to change all instances of PBOwner to another name, or leave the table owner as PBOwner in the script (the default).

Specifying SYSIBM is prohibited DB2 prohibits you from specifying SYSIBM as the table owner.
You can set the PBCatalogOwner parameter to the owner you specified in this script or to PBOwner if you did not edit the script.

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

Examples

Example 1

This example shows how to create a new set of extended attribute system tables with the owner TEST. The names of the new tables have the prefix TEST, such as TEST.pbcatcol, TEST.pbcatedt, and so on.

Database profile Type the following in the PB Catalog Table Owner box on the System tab in the Database Profile Setup dialog box:
```
TEST
```
Application Type the following in code:
```
SQLCA.DBParm="PBCatalogOwner='TEST'"
```