SPD Server Supported SQL :: SAS® Scalable Performance Data Server 5.3: User's Guide

The SPD Server SQL processor supports all of the SQL statements that the SAS SQL procedure supports (except CREATE VIEW) when no SQL pass-through is used or when implicit SQL pass-through is used. For information about these statements, see SAS SQL Procedure User’s Guide.

For explicit SQL pass-through, the server SQL processor supports the SAS SQL statements, with some modifications. In addition, the SQL processor supports the following additional SQL statements:

BEGIN ASYNC OPERATION and END ASYNC OPERATION

enable you to send blocks of SQL statements to the server asynchronously, so that they can be processed in parallel.

CREATE [MATERIALIZED] VIEW

creates a regular or materialized view of SPD Server tables.

COPY TABLE

copies an SPD Server table, with or without indexes.

LIBREF

defines server domains from within an EXECUTE statement without your needing to reissue PROC SQL.

LOAD TABLE

creates a new SPD Server table from an existing SPD Server table, with or without indexes

RESET

enables you to customize SPD Server SQL Planner settings.

The SPD Server SQL Planner provides the following SQL processing:

parallel WHERE clause processing
parallel GROUP BY processing
BY data grouping with ORDER BY
parallel index creation.

For both implicit and explicit pass-through, there are some differences in SPD Server SQL versus SAS SQL.

For more information about the additional SQL statements for explicit pass-through, see SPD Server SQL Statement Additions.