118 QUOTED_IDENTIFIER= LIBNAME Option Chapter 9
Microsoft SQL Server Details: QUOTE_CHAR= overrides the Microsoft SQL Server
default.
Examples
If you would like your quotation character to be a single quotation mark, then specify
the following:
libname x odbc dsn=mydsn pwd=mypassword quote_char="’";
If you would like your quotation character to be a double quotation mark, then
specify the following:
libname x odbc dsn=mydsn pwd=mypassword quote_char=’"’;
QUOTED_IDENTIFIER= LIBNAME Option
Enables you to specify table and column names with embedded spaces and special characters
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: SYBASE
Default value:
NO
Syntax
QUOTED_IDENTIFIER=YES|NO
Details
This option is used in place of the PRESERVE_TAB_NAMES and
PRESERVE_COL_NAMES options, which have no effect on the SYBASE interface, due
to SYBASE’s default to case sensitivity.
READ_ISOLATION_LEVEL= LIBNAME Option
Defines the degree of isolation of the current application process from other concurrently running
application processes
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle,
Microsoft SQL Server, SYBASE, Teradata
Default value: DBMS-specific
Syntax
READ_ISOLATION_LEVEL=DBMS-specific value
