Specifies whether you want PowerBuilder to enclose the names of tables, columns, indexes, and constraints in double quotes when it generates SQL statements. This affects the behavior of any PowerBuilder painter that generates SQL syntax.
ADO.NET
ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
I10 Informix
IN9 Informix
JDB JDBC
ODBC (if driver and back-end DBMS support this feature)
OLE DB
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
SNC SQL Native Client for Microsoft SQL Server
DelimitIdentifier='value'
Parameter |
Description |
|---|---|
value |
Specifies whether you want PowerBuilder to enclose table and column names in double quotes. Values are:
|
The default value for the DelimitIdentifier parameter depends on the DBMS you are accessing, as follows:
DBMS |
DelimitIdentifer default value |
|---|---|
ADO.NET |
DelimitIdentifier='Yes' for SQL Anywhere, Oracle, and DB2, 'No' for all other DBMSs. |
Informix |
DelimitIdentifier='No' |
JDBC |
Depends on the DelimitIdentifer setting in the registry |
ODBC |
Depends on the DelimitIdentifer setting in the PBODB125 initialization file |
Oracle |
DelimitIdentifier='Yes' |
OLE DB |
Depends on the DelimitIdentifer setting in the PBODB125 initialization file |
SNC |
DelimitIdentifier='No' |
Sybase DirectConnect |
DelimitIdentifier='No' |
Sybase Adaptive Server Enterprise |
DelimitIdentifier='No' |
Informix Informix database servers can create a log of database transactions in either ASCII or non-ASCII format. If the database is creating a non-ASCII log, the setting of the DelimitIdentifier is optional. If the database is creating an ASCII log, you must set DelimitIdentifier='Yes' to make the SQL syntax generated by PowerBuilder behave as expected.
Sybase Adaptive Server Enterprise When you set DelimitIdentifier to 'Yes', the “set quoted_identifier on” command is automatically sent to Adaptive Server to adjust your database connection on the server. Otherwise, the “set quoted_identifier off” command is sent to the server. This feature occurs with ASE, SYC, JDBC, ODBC, and OLE DB interfaces.
Microsoft SQL Server When you set DelimitIdentifier to 'Yes', the “set quoted_identifier on” command is automatically sent to Microsoft SQL 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.
JDBC and ODBC The DelimitIdentifier parameter setting overrides the DelimitIdentifier setting specified for your JDBC driver in the registry and for your ODBC driver in the PBODB125 initialization file.
DirectConnect If you want to use mixed-case identifier names, you must set DelimitIdentifier=‘Yes’. Also, you must set LowerCaseIdent=‘No’ to preserve case sensitivity of identifiers stored in the DB2 system catalog.
To specify that PowerBuilder should not enclose table and column names in double quotes when it generates SQL statements:
Database profile Clear the Enclose Table And Column Names In Quotes check box on the Syntax page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="Delimitidentifier='No'"
