QualifyPublic

Description

Specifies that the PUBLIC qualifier prepended to Oracle synonyms belonging to the public schema or user group is retained in the SQL Select table list.

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

Applies to

O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g

Syntax

QualifyPublic = value

Parameter	Description
value	Specifies that the PUBLIC qualifier should be retained in the SQL Select table list. Values are: 0 (Default) Do not retain the PUBLIC qualifier. 1 Do retain the PUBLIC qualifier.

Parameter

Description

value

Specifies that the PUBLIC qualifier should be retained in the SQL Select table list. Values are:

0 (Default) Do not retain the PUBLIC qualifier.
1 Do retain the PUBLIC qualifier.

Default

QualifyPublic = 0

Usage

PowerBuilder’s default behavior has been to discard the PUBLIC qualifier so that the object reference is generalized in the generated SQL statement, facilitating the deployment of an application from a development database instance to a production database. However, in certain DataWindow objects, the absence of the PUBLIC qualifier breaks the association of the synonym with its extended attributes, preventing these attributes from being used. The QualifyPublic parameter allows you to specify whether the PUBLIC qualifier should be retained.

Examples

Example 1

To specify that you want the PUBLIC qualifier to be retained in the SQL Select table list:

Database profile Select the Qualify Public Synonyms check box on the System tab in the Database Profile Setup dialog box.
Application Type the following in code:
```
SQLCA.DBParm = "QualifyPublic=1"
```