PASSTHRU= LIBNAME Statement Option

Invokes SQL implicit pass-through processing for the SPD Server connection.

Valid in:	SPD Server LIBNAME Statement
Interaction:	PASSTHRU= provides the same functionality as IP=YES. Use IP=YES instead of PASSTHRU=. IP=YES is easier to use.
Note:	Option to specify SQL implicit pass-through.

Syntax

Syntax

PASSTHRU='dbq='domain-name' <SPD Server-options>
user='UserID' password='password' ' ;

Required Arguments

dbq='domain-name'

specifies the primary server domain for the SQL pass-through connection. The name that you specify is identical to the server domain name that you used when you made a SAS LIBNAME assignment to SASSPDS. Use single or double quotation marks around the specified value.

USER='user ID'

required on Windows, but not UNIX. Specifies a user ID in order to access the server’s SQL processor. Use single or double quotation marks around the specified value.

PASSWORD='password'

required, or use PROMPT=YES, unless USER='anonymous'. Specifies a user ID password to access the server. This value is case sensitive.

Optional Argument

SPD Server-options

one or more server options.

Details

The PASSTHRU= option is the original way that implicit SQL pass-through was made available for SPD Server. This older specification is still supported for backward compatibility.

Example

The following LIBNAME statement shows how the PASSTHRU= option is used:

libname BOAF sasspds 'BOAF'
   server=kaboom.5400
   user='rcnye'
   password='*******'

   PASSTHRU='
   dbq="BOAF"
   server=kaboom.5400
   user="rcnye"
   password="*******"' ;

Last updated: February 8, 2017