Data Set Options for Relational Databases

SESSIONS= Data Set Option

Specifies how many Teradata sessions to be logged on when using FastLoad, FastExport, or Multiload.

Default value:	none
Valid in:	DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
DBMS support:	Teradata

Syntax
Syntax Description
Details
Example
See Also

Syntax

SESSIONS=number-of-sessions

Syntax Description

number-of-sessions: specifies a numeric value that indicates the number of sessions to be logged on.

Details

When reading data with FastExport or loading data with FastLoad and MultiLoad, you can request multiple sessions to increase throughput. Using large values might not necessarily increase throughput due to the overhead associated with session management. Check whether your site has any recommended value for the number of sessions to use. See your Teradata documentation for details about using multiple sessions.

Example

This example uses SESSIONS= in a LIBNAME statement to request that five sessions be used to load data with FastLoad.

libname x teradata user=prboni pw=prboni;

proc delete data=x.test;run;
data x.test(FASTLOAD=YES SESSIONS=2);
i=5;
run;