The LIBNAME Statement for Relational Databases |
Specifies how many Teradata sessions to be logged on when
using
FastLoad, FastExport, or Multiload.
Default value: |
none
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
Teradata
|
SESSIONS=number-of-sessions
|
- number-of-sessions
-
specifies a numeric value that indicates the number of sessions
to be logged on.
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.
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 SESSIONS=2;
proc delete data=x.test;run;
data x.test(FASTLOAD=YES);
i=5;
run;
To apply this option to an individual data set, see the
SESSIONS= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.