SESSIONS= LIBNAME Option

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

Valid in:	SAS/ACCESS LIBNAME statement
Default:	none
Data source:	Teradata
See:	FASTEXPORT= LIBNAME option, SESSIONS= data set option, Using MultiLoad

Syntax

Details

Example

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 you read data with FastExport or load data with FastLoad or 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 five sessions for loading data with FastLoad.

libname x teradata user=prboni pw=prboni SESSIONS=2;
proc datasets library=x;
  delete test;run;
data x.test(FASTLOAD=YES);
i=5;
run;