HomePowerBuilderAppeon Documentation Center

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

O90 Oracle9i

O10 Oracle 10g

ORA Oracle (for 11g and later)

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.

Default value

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

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 page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="QualifyPublic=1"
Prev  Up  Next
PWExpDialog  Home  RecheckRows