DBLINK=

DBLINK=

Specifies an object in the local database that allows access to objects in a remote database.

Default value: Defaults to the value of the LIBNAME option.

Syntax
Details
Example: Referencing a Remote ORACLE Table By Using DBLINK=

Syntax

DBLINK=database-link

database-link: specifies a link to a remote object, such as a table or view in another database.

Details

If you specify a link, SAS uses the link to access remote objects. If you omit DBLINK=, SAS accesses objects in the local database.

A link is a database object that identifies an object that is stored in a remote database. A link contains stored path information and may also contain user name and password information for connecting to the remote database.

Example: Referencing a Remote ORACLE Table By Using DBLINK=

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;

Chapter Contents
Previous
Next
Top of Page