QualifyPublic
database parameter
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
|
1 |
QualifyPublic=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies that the PUBLIC qualifier should be
|
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:
1SQLCA.DBParm="QualifyPublic=1"