Description

All Oracle database interfaces in PowerBuilder and InfoMaker now support the PBCatalogOwner DBParm parameter. This support is new in Version 6.0.

The default value for PBCatalogOwner when you are using any of the Oracle database interfaces is 'SYSTEM'.

Purpose

PBCatalogOwner allows you to specify a nondefault owner for the tables in the Powersoft repository, also known as the Powersoft extended catalog or the Powersoft system tables. When you specify a value for PBCatalogOwner that is different from 'SYSTEM' (the default repository owner for the Oracle interfaces), PowerBuilder or InfoMaker creates a new set of repository tables with the owner name you specify.

• For more information, see the description of PBCatalogOwner in Connecting to Your Database.

Usage

As with any other DBParm parameter, you can set PBCatalogOwner in the Database Profile Setup dialog box for your connection or in a PowerBuilder application script.

Examples

To create a new set of Powersoft repository tables with the owner name 'TEST', set PBCatalogOwner in either of the following ways:

• To set PBCatalogOwner in the Database Profile Setup dialog box:

Type the following in the PowerBuilder Catalog Table Owner box on the System tab in the Database Profile Setup dialog box. Specify the owner name without single quotes:

TEST

• To set PBCatalogOwner in a PowerBuilder application script:

Type the following in a PowerBuilder script:

SQLCA.DBParm = "PBCatalogOwner = 'TEST'"

If you specify a value for PowerBuilder Catalog Table Owner in your database profile, this syntax displays on the Preview tab in the Database Profile Setup dialog box. You can then copy the syntax from the Preview tab into your script and modify the default transaction object name (SQLCA) if necessary.