![]() |
SQL-J Language Reference
|
Reference Manual |
PROPERTIES clauseA PROPERTIES clause, or list of properties, is an optional part of an SQL-J CREATE TABLE statement, CREATE INDEX statement, CONSTRAINT clause, FROM clause, TableExpression, or INSERT statement. Properties specified in a PROPERTIES clause fall into one of the following categories: SyntaxThe basic syntax of a PROPERTIES clause is as follows: PROPERTIES propertyName = value [, propertyName = value]* NOTE: If you specify the same property multiple times within a PROPERTIES clause, an exception is thrown. Storage-Related PropertiesFor CREATE TABLE, CREATE INDEX, and CONSTRAINT, a PROPERTIES clause allows you to specify storage properties for the table or index being created and overrides the properties currently set on a database-wide or system-wide basis. These properties include:
For indexes, you can set only cloudscape.storage.initialPages and cloudscape.storage.pageSize. For tables, you can set cloudscape.storage.initialPages, cloudscape.storage.minimumRecordSize, cloudscape.storage.pageSize, or cloudscape.storage.pageReservedSpace. NOTE: Any mistyped or unused properties are ignored; Cloudscape does not provide any error checking. For more information, see Conglomerate-Specific Properties in Tuning Cloudscape.
-- set the page size to 262144 and the reserved space to 0%
-- set the page size for the index to 2048 To verify properties used for a specific table or index, use the static methods of COM.cloudscape.database.PropertyInfo (aliased as PropertyInfo). For more information, see Verifying Conglomerate-Specific Properties in the Cloudscape Developer's Guide. Optimizer Override PropertiesFor a PROPERTIES clause in a FROM clause, you can specify: For a PROPERTIES clause in a TableExpression, you can specify for a specific table:
For more information, see Chapter 6, "Optimizer Overrides", in Tuning Cloudscape. Bulk Insert PropertiesYou can use a PROPERTIES clause to set the insertMode to bulkInsert or replace in an INSERT statement.
For more information on importing external data, see the Cloudscape Tools and Utilities Guide. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |