The LIBNAME Statement for Relational Databases |
Specifies
which quotation mark character to use when delimiting
identifiers.
Default value: |
none
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
Aster nCluster, Greenplum,
HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Sybase IQ
|
-
character
-
is the quotation mark character to use when
delimiting identifiers, such as the double quotation mark (").
The provider usually specifies the delimiting
character. However, when there is a difference between what the provider allows
for this character and what the DBMS allows, the QUOTE_CHAR= option overrides
the character returned by the provider.
Microsoft SQL Server: QUOTE_CHAR= overrides
the Microsoft SQL Server default.
ODBC: This option is mainly for the ODBC
interface to Sybase, and you should use it with the DBCONINIT and DBLIBINIT
LIBNAME options. QUOTE_CHAR= overrides the ODBC default because some drivers
return a blank for the identifier delimiter even though the DBMS uses a quotation
mark--for example, ODBC to Sybase.
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='"';
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.