Establishes a connection with a DBMS that is supported by SAS/ACCESS software.
TO dbms-name <AS alias> <(<connect-statement-arguments>
- specifies an alias that has 1 to 32 characters. The keyword
AS must precede alias. Some DBMSs allow more than one connection.
The optional AS clause enables you to name the connections so that you can
refer to them later.
- specifies arguments that indicate whether you can make multiple
connections, shared or unique connections, and so on to the database. These
arguments are optional, but if they are included, they must be enclosed in
- specifies the DBMS-specific arguments that are needed by
PROC SQL to connect to the DBMS. These arguments are optional for most databases,
but if they are included, they must be enclosed in parentheses.
- identifies the DBMS that you want to connect to (for example,
ORACLE or DB2).
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.