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 and reports.
When InfoMaker 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 InfoMaker qualifies identifiers If the name of the table owner is the same as the name of the user logged in to the database, InfoMaker does not qualify identifiers with owner names in the SQL statements it generates. If you set the SQLQualifiers parameter to 1, InfoMaker qualifies identifiers with an owner name in SQL statements.
SQL
To specify that you want InfoMaker to qualify identifiers with owner names in SQL statements, select the Qualify Identifiers With Owner Names check box on the Syntax page in the Database Profile Setup dialog box.
