Connecting to the SPD Server SQL Engine

You can use an implicit pass-through connection to pass implicit SQL statements to the SPD Server SQL engine. When you use an implicit pass-through connection, the SAS SQL Planner parses SQL statements to determine which, if any, portions can be passed to the SPD Server SQL engine. In order for a submitted SQL statement to take advantage of implicit pass-through SQL, the tables that are referenced in the SQL statement must be SPD Server tables, and the SPD Server SQL engine must be able to successfully parse the submitted SQL statement. If SPD Server cannot successfully parse the statement, an SPD Server parse error is reported in the SAS log, and SAS SQL retries the query.

For an example of an SPD Server implicit pass-through connection, see Specify SQL Options By Using Implicit Pass-Through Code.

You can use an explicit pass-through connection to pass explicit SQL statements to the SPD Server SQL engine. When you use an explicit pass-through connection, you decide explicitly which SQL statements are passed to the SPD Server SQL engine. The explicit pass-through connection passes the entire SQL statement as written to the SPD Server SQL engine, which parses and plans the SQL statement. All tables that are referenced in the SQL statement must be SPD Server tables or an error occurs.

For an example of an SPD Server explicit pass-through connection, see Specify SQL Options By Using Explicit Pass-Through Code.

The following LIBNAME statement associates a libref, the SASSPDS engine, and an SPD Server domain.

LIBNAME libref
SASSPDS <'SAS-data-library'> <SPD Server-options>; 

Use the following arguments: