Description
Sets the level of qualification for identifiers (table and column names) in SQL statements when you connect to a database. This affects behavior in DataWindow objects.
When PowerBuilder qualifies a table or column name, it prefixes it with the name of the owner. For example, if a user named Fran owns a table named Sales, the qualified table name is Fran.Sales.
Applies to
DIR SAP DirectConnect
Syntax
SQLQualifiers=value
|
Parameter |
Description |
|---|---|
|
value |
Sets the level of qualification for identifiers in SQL statements when you connect to a database. Values are:
|
Default value
SQLQualifiers=0
Usage
When PowerBuilder qualifies identifiers
If the name of the table owner is the same as the name of the user logged in to the database, PowerBuilder does not qualify identifiers with owner names in the SQL statements it generates. If you set the SQLQualifiers parameter to 1, PowerBuilder qualifies identifiers with an owner name in SQL statements.
Examples
To specify that you want PowerBuilder to qualify identifiers with owner names in SQL statements:
-
Database profile
Select the Qualify Identifiers With Owner Names check box on the Syntax page in the Database Profile Setup dialog box.
-
Application
Type the following in code:
SQLCA.DBParm="SQLQualifiers=1"
