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
DIR Sybase DirectConnect
Informix 9
JDB JDBC
ODBC (if driver and back-end DBMS support this feature)
OLE DB
O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g
SYC Sybase Adaptive Server Enterprise
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 |
|
Informix |
|
JDBC |
Depends on the DelimitIdentifer setting in the registry |
ODBC |
Depends on the DelimitIdentifer setting in the PBODB105 initialization file |
Oracle |
|
OLE DB |
|
Sybase DirectConnect |
|
Sybase Adaptive Server Enterprise |
|
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 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 OLE DB. Otherwise, the “set quoted_identifier off” command is sent to the server.
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 PBODB105 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 tab in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm = "Delimitidentifier='No'"
