The LIBNAME Statement for Relational Databases |
Allows specification of the database and tablespace in which
you
want to create a new table.
Alias: |
TABLESPACE=
|
Default value: |
none
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
DB2 under UNIX and PC Hosts, DB2 under z/OS
|
IN='database-name.tablespace-name'|
'DATABASE database-name'
|
-
database-name.tablespace-name
-
specifies the names of the database and
tablespace, which are separated by a period. Enclose the entire specification
in single quotation marks.
-
DATABASE database-name
-
specifies only the database name. Specify
the word DATABASE, then a space, then the database name. Enclose the entire
specification in single quotation marks.
The IN= option is relevant only when you
are creating a new table. If you omit this option, the default is to create
the table in the default database, implicitly creating a simple tablespace.
To apply this option to an individual data
set, see
the IN= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.