Specifying SPD Server SQL Planner Options

The SPD Server SQL Planner provides reset options that you can use to configure the behavior of the SQL Planner and the SPD Server facilities that function through the SQL Planner, such as the SPD Server Parallel Group-By facility, the SPD Server Parallel Join facility, and the SPD Server STARJOIN facility. You can specify SPD Server SQL reset options using either explicit pass-through or implicit pass-through code.

Specify SQL Options Using Explicit Pass-Through Code

The example below shows how to use an execute(reset <reset-options>) statement in explicit SPD Server pass-through SQL code to invoke an SQL Planner, Parallel Group-By facility, Parallel Join facility, or STARJOIN facility reset option.

Most SQL Planner reset option usage examples in this document use explicit pass-through code. See the implicit pass-through code example below to see how SQL reset options can be declared using an implicit %let spdssqlr= statement instead of an explicit execute(reset <reset-options>) statement.

/* Explicit Pass-Through SQL Example */
/* to invoke an SQL Reset Option */

PROC SQL ;

connect to sasspds (
  dbq=domain-name
  server=<host-name>.<port-number>
  user='username') ;

execute(reset <reset-options>)
  by sasspds ;

execute(SQL statements)
  by sasspds ;

disconnect from sasspds ;
 quit ;

Specify SQL Options Using Implicit Pass-Through Code

The example below shows how to use a %let spdssqlr=<reset-options> statement in implicit SPD Server pass-through SQL code to invoke an SQL Planner, Parallel Group-By facility, Parallel Join facility, or STARJOIN facility reset option.

Most SQL Planner reset option usage examples in this document use explicit pass-through code. The implicit pass-through code example below shows how SQL reset options can be declared using an implicit %let spdssqlr= statement instead of an explicit execute(reset <reset-options>) statement.

/* Implicit Pass-Through SQL Example */
/* to invoke an SQL Reset Option */

%let spdssqlr=<reset-options> ;

PROC SQL ;
SQL statements ;

quit ;