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, DataWindow Designer 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.
ADO.NET
ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
ODBC
OLE DB
O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g
SNC SQL Native Client for Microsoft SQL Server
PBCatalogOwner='owner_name'
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. |
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'
|
SNC |
PBCatalogOwner = 'dbo'
|
Sybase Adaptive Server Enterprise |
PBCatalogOwner = 'dbo'
|
Sybase DirectConnect |
PBCatalogOwner = 'sqlca.logid'
|
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.
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 PBODB110 initialization file, the setting in the profile overrides the setting in the PBODB110 initialization file.
This parameter cannot be set dynamically. The value set when the connection is made remains in effect until it is disconnected.
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 page in the Database Profile Setup dialog box:
TEST
Application Type the following in code:
SQLCA.DbParameter="PBCatalogOwner='TEST'"