Lets you specify the database or tablespace in which you want to create a new table.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Alias: | CREATED_IN= [DB2 under UNIX and PC Hosts] |
| Default: | LIBNAME option value |
| Data source: | DB2 under UNIX and PC Hosts, DB2 under z/OS |
| See: | IN= LIBNAME option |
Table of Contents
specifies the names of the database and tablespace, which are separated by a period.
specifies only the database name. In this case, you specify the word DATABASE, a space, and 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 or tablespace.