RESULTS= LIBNAME Option

Determines where to store query results.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	MEMORY
Data source:	MySQL

Syntax

Details

Example

Syntax

RESULTS=MEMORY | SERVER | DISK

Syntax Description

MEMORY: stores query results in client memory.

SERVER: stores query results on the server.

DISK: stores query results in a temporary disk file on the client computer.

Details

Multiple concurrent connections to the server are not supported. Therefore, when RESULTS=SERVER, the entire query must be one that you can push to the server. If not, this message appears in the log:

Commands
                     out of sync; you can't run this command now.

RESULTS=DISK lets you run complex queries with result sets that would typically cause an out-of-memory error. Result-set size is limited only to the free space on the drive that is used for temporary files.

Example: Sending Results to a Temporary Disk File

libname spooled mysql…results=disk;