Data Set Options for Relational Databases |
Specifies a link from your local database to database objects
on another server [Oracle]. Specifies a link from your default database to
another database on the server to which you are connected [Sybase].
Default value: |
LIBNAME setting
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Oracle, Sybase
|
This option operates differently in each
DBMS.
Oracle: A link is a database object that
identifies an object that is stored in a remote database. A link contains
stored path information and can also contain user name and password information
for connecting to the remote database. If you specify a link, SAS uses the
link to access remote objects. If you omit DBLINK=, SAS accesses objects in
the local database.
Sybase: You can use this option to link
to another database within the same server to which you are connected. If
you omit DBLINK=, SAS can access objects only in your default database.
In this example, SAS sends MYORADB.EMPLOYEES to Oracle
as EMPLOYEES@SALES.HQ.ACME.COM.
proc print data=myoradb.employees(dblink='sales.hq.acme.com');
run;
To assign this option to a group of relational
DBMS tables or views, see the DBLINK= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.