The LIBNAME Statement for Relational Databases |
Default value: | none |
Valid in: | SAS/ACCESS LIBNAME statement |
DBMS support: | Teradata |
Syntax | |
Syntax Description | |
Details | |
Example | |
See Also |
Syntax |
SESSIONS=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 SESSIONS=2; proc delete data=x.test;run; data x.test(FASTLOAD=YES); i=5; run;
See Also |
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.