Previous Page | Next Page

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.


See Also

To apply this option to an individual data set, see the IN= Data Set Option.

Previous Page | Next Page | Top of Page