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.
DIR Sybase DirectConnect
SQLQualifiers=value
Parameter |
Description |
|---|---|
value |
Sets the level of qualification for identifiers in SQL statements when you connect to a database. Values are:
|
SQLQualifiers=0
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.
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"
