SQLQualifiers
database parameter
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
|
1 |
SQLQualifiers=value |
|
Parameter |
Description |
|---|---|
|
value |
Sets the level of qualification for identifiers in
|
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:
1SQLCA.DBParm="SQLQualifiers=1"