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.

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

Applies to

Syntax

QualifyPublic=value

Parameter

Description

value

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

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: