Specifies a nondefault owner for the five extended attribute system tables. These 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, PocketBuilder creates a new set of tables with the owner name you specify.
When to specify PBCatalogOwner
You must specify the PBCatalogOwner DBParm parameter before connecting to
the database in PocketBuilder.
ODBC
PBCatalogOwner = ‘owner_name’
Parameter |
Description |
|---|---|
owner_name |
Specifies the owner of the extended attribute system tables |
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.
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.
When you connect to an ODBC data source and a value for PBCatalogOwner is set in both the database profile and the pkodb25 initialization file, the setting in the profile overrides the setting in the pkodb25 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.
