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.
Controls
-
DIR Sybase DirectConnect
Syntax
|
1 |
SQLQualifiers=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Sets the level of qualification for identifiers
|
Default
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.DbParameter="SQLQualifiers=1"