DelimitIdentifierToDB – PB Docs 2019

Description

Specifies whether PowerBuilder should send a “set
quoted_identifier off” instruction to the server when the
DelimitIdentifier parameter is not set.

Applies to

ODBC (if driver and back-end DBMS support this feature)

OLE DB

Syntax

Default value

‘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:

See also

DelimitIdentifier