The LIBNAME Statement for Relational Databases

IN= LIBNAME Option

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

Syntax
Syntax Description
Details
See Also

Syntax

IN='database-name.tablespace-name'| 'DATABASE database-name'

Syntax Description

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.

Details

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.