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.
Controls
-
O90 Oracle9i
-
O10 Oracle 10g
-
ORA Oracle 11g
Syntax
|
1 |
QualifyPublic=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies that the PUBLIC qualifier should
|
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
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.DbParameter="QualifyPublic=1"