The LIBNAME Statement for Relational Databases

REMOTE_DBTYPE= LIBNAME Option

Specifies whether the libref points to a database server on z/OS or to one on Linux, UNIX, or Windows (LUW).

Default value:	ZOS
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	DB2 under z/OS

Syntax
Syntax Description
Details
Example
See Also

Syntax

REMOTE_DBTYPE=LUW | ZOS

Syntax Description

LUW: specifies that the database server that is accessed through the libref resides on Linux, UNIX, or Windows.
ZOS: specifies that the database server that is accessed through the libref runs on z/OS (default).

Details

Specifying REMOTE_DBTYPE= in the LIBNAME statement ensures that the SQL that is used by some SAS procedures to access the DB2 catalog tables is generated properly, and that it is based on the database server type.

This option also enables special catalog calls (such as DBMS::Indexes) to function properly when the target database does not reside on a mainframe computer.

Use REMOTE_DBTYPE= with the SERVER= CONNECT statement option or the LOCATION= LIBNAME option. If you use neither option, REMOTE_DBTYPE= is ignored.

Example

This example uses REMOTE_DBTYPE= with the SERVER= option.

libname mylib db2 ssid=db2a server=db2_udb remote_dbtype=luw;  
proc datasets lib=mylib; 

quit;

By specifying REMOTE_DBTYPE=LUW, this SAS code lets the catalog call work properly for this remote connection.

proc sql;
	connect to db2 (ssid=db2a server=db2_udb remote_dbtype=luw);

	select * from connection to db2
	select * from connection to db2
      (DBMS::PrimaryKeys ("", "JOSMITH", ""));
quit;