SESSIONS= Data Set Option
Specifies how many Teradata sessions to be logged
on when using FastLoad, FastExport, or Multiload.
| Valid in: |
DATA and PROC steps (when creating and appending to DBMS
tables using SAS/ACCESS software)
|
| Default: |
none |
| Data source: |
Teradata |
| See: |
SESSIONS= LIBNAME option |
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: Request Sessions to Load a Table
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 datasets library=x;
delete test;run;
data x.test(FASTLOAD=YES SESSIONS=2);
i=5;
run;