A Table Creation Directive field consists of text indicating where on a DB2 host a table should be created.
The following syntax is supported:
|
Platform |
Syntax |
|
DB2 for z/OS |
IN DATABASE DATABASE_NAME IN DATABASE_NAME . TABLESPACE |
|
DB2 for i |
IN NODEGROUP_NAME A nodegroup name is a qualified or unqualified name that designates a nodegroup. A nodegroup is a group of DB2 for i's across which a table is distributed. For information about distributed tables and nodegroups, see the DB2 Multisystem for OS/400 book, SC41-3705. |
|
DB2/UDB |
IN TABLESPACE_NAME A tablespace name is a long identifier that identifies a distinct table space described in the DB2 catalog. |