Options to Specify Implicit SQL Pass-Through

IP=YES

Summary

Syntax

IP=YES

Summary

This is an abbreviated specification which replaces the more verbose PASSTHRU= option. The IP=YES option draws on information specified in the LIBNAME declaration. The IP=YES option specifies an implicit SQL pass-through connection for a single user to a specified domain and server during a given SPD Server session.

Syntax

LIBNAME BOAF sasspds 'BOAF'
   server=kaboom.5200
   user='rcnye'
   password='*******'
   IP=YES ;

PASSTHRU=

Summary

This older and more verbose specification for IP=YES is still supported. It specifies an implicit SQL pass-through connection for a single user to a specified domain and server during a given SPD Server session.

Syntax

PASSTHRU=<'dbq=<SAS-data-library>
  <SPD Server-options>
  user=<'UserID'>
  password=<'password'> ;

Arguments

DBQ=libname-domain (required)

Specifies the primary SPD Server LIBNAME domain for the SQL pass-through connection. The name that you specify is identical to the LIBNAME domain name that you used when making a SAS LIBNAME assignment to sasspds. Use single or double quotes around the specified value.

SPD Server-options

one or more SPD Server options.

USER=SPD Server user ID (required on Windows, but not UNIX)

Specifies an SPD Server user ID in order to access an SPD Server SQL Server. Use single or double quotes around the specified value.

PASSWORD=password (required, or use PROMPT=YES, unless USER='anonymous')

Specifies an SPD Server user ID password to access an SPD Server. (This value is case sensitive.)

Example:

The following is a LIBNAME statement that specifies the implicit SQL pass-through option for user rcnye, using a libref to connect to the domain named 'BOAF' on the server named 'Kaboom' on port 5200:

LIBNAME BOAF sasspds 'BOAF'
   server=kaboom.5200
   user='rcnye'
   password='*******'

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

Options

SPD Server 5.1 supports SAS PROC PWENCODE. This permits scripts to be generated that do not explicitly contain secure passwords that could easily be used without authorization. You must run PROC PWENCODE in Base SAS to enable the usage of script password encoding within SPD Server 5.1. See the Base SAS documentation for detailed instruction on running PROC PWENCODE with SPD Server 5.1.

The example below shows an SPD Server LIBNAME statement that uses the password encoding option:

LIBNAME mylib sasspds 'spdsdata'
   server=kaboom.5200
   user='spdsuser'
   password='{sas001}c3BkczEyMw=='

   PASSTHRU='
   dbq="spdsdata"
   server=kaboom.5200
   user="spdsuser"
   password="{sas001}c3BkczEyMw=="';