The LIBNAME Statement for Relational Databases QUOTE_CHAR= LIBNAME Option 117
DBMS support: DB2 UNIX/PC, ODBC, Microsoft SQL Server
Default value:
0
Syntax
QUERY_TIMEOUT=number-of-seconds
Details
The default value of 0 indicates that there is no time limit for a query. This option is
useful when you are testing a query or if you suspect that a query might contain an
endless loop.
See Also
To apply this option to an individual data set, see the data set option
“QUERY_TIMEOUT= Data Set Option” on page 203.
QUOTE_CHAR= LIBNAME Option
Specifies which quotation mark character to use when delimiting identifiers
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: ODBC, OLE DB, Microsoft SQL Server
Default value:
none
Syntax
QUOTE_CHAR=character
Syntax Description
character
is the quotation mark character to use when delimiting identifiers, such as the
double quotation mark (").
Details
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.
ODBC Details: This option is mainly for the ODBC Interface to Sybase and should be
used in conjunction 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).
