DelimitIdentifierToDB database parameter
Description
Specifies whether PowerBuilder should send a “set quoted_identifier
off” instruction to the server when the DelimitIdentifier
parameter is not set.
Controls
-
ODBC (if driver and
back-end DBMS support this feature) -
OLE DB
Syntax
|
1 |
DelimitIdentifierToDB='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether PowerBuilder sends a “set
|
Default
‘No’
Usage
When you set DelimitIdentifier to ‘Yes’,
the “set quoted_identifier on” command
is automatically sent to the database server to adjust your database connection
on the server when you use ODBC or OLE DB. Otherwise, the “set quoted_identifier
off” command is sent to the server.
Sending “set quoted_identifier off” to
the server can cause some SQL commands
to fail if the SQL code contains
quotation marks. To prevent PowerBuilder from sending this instruction
to the server, set the DelimitIdentifierToDB parameter to ‘No’ in
the PBODB initialization file or the connection string.
Examples
To specify that PowerBuilder should not send a set
quoted_identifier instruction to the server, add the following
to the appropriate section of your PBODB initialization file or
your connection string:
|
1 |
"DelimitIdentifierToDB='No'" |