Chapter 15 DBMS-Specific Features
In IBM databases for OS/390, the physical options for a table can specify the tablespace in which a table resides as well as the database name.
To support this feature, the Options entry in the Table category contains the item enabledbprefix.
By default, this item is set to yes which means that the tablespace name will be systematically prefixed by the database name. You declare a tablespace in a database from the Options tab of the tablespace property sheet.
In the following example, tablespace TBSP1 is declared in database MyBase:
If you select TBSP1 in the table physical options, you can view that the tablespace name is prefixed by the name of the database.
If the tablespace is not declared in any database, then the tablespace is not prefixed by any database name.
When you preview the table creation code, you can verify that the tablespace is prefixed by the name of the database.
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |