Lets you specify the database and tablespace in which you want to create a new table.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Alias: | CREATED_IN= [DB2 under UNIX and PC Hosts] |
| Default: | none |
| Data source: | DB2 under UNIX and PC Hosts, DB2 under z/OS, Greenplum, HAWQ |
| See: | IN= data set option |
Table of Contents
specifies the names of the database and tablespace, which are separated by a period. Enclose the entire specification in single quotation marks.
specifies only the database name. 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.
DB2 under z/OS: If you omit this option, the default is to create the table in the default database, implicitly creating a simple tablespace with a tablespace name that is generated by DB2.