Composite Physical Option Syntax

A composite physical option is a physical option that includes other dependent options. These options are selected together in the right pane of the physical options tab.

The standard syntax for composite physical options is as follows:

with : composite=yes, separator=yes, parenthesis=no
{
fillfactor=%d : default=0
max_rows_per_page=%d : default=0
}

The With physical option includes the other options between curly brackets { }, separated by a comma. To define a composite option, a composite keyword is necessary.

Keyword	Value and result
composite	The following settings are available: yes - brackets can be used to define a composite physical option no – brackets cannot be used
separator	The following settings are available: yes - options are separated by a comma no [default] - options have no separator character
parenthesis	The following settings are available: yes - the composite option is delimited by parenthesis, including all the other options, for example: with (max_row_per_page=0, ignore_dup_key) no [default] - nothing delimits the composite option
nextmand	The following settings are available: yes - the next line in the physical option is mandatory. no - you will not be able to generate/reverse the entire composite physical option
prevmand	The following settings are available: yes - the previous line in the physical option is mandatory no - you will not be able to generate/reverse the entire composite physical option
chldmand	The following settings are available: yes - at least one child line is mandatory no – children are not mandatory
category	The following settings are available: tablespace - the item is linked to a tablespace storage - the item is linked to a storage storage : category=storage, composite=yes, separator=no, parenthesis=yes { Note: In Oracle, the `storage` composite physical option is used as a template to define all the storage values in a storage entry. This is to avoid having to set values independently each time you need to use the same values in a storage clause. Thus, the Oracle physical option does not include the storage name (%s):
list	List in which values are separated by a pipe (\|)
dquoted	The following settings are available: yes - the value is enclosed in double quotes ("" "") no - the value is not enclosed in double quotes ("" "")
squoted	The following settings are available: yes - the value is enclosed in single quotes (' ') no - the value is not enclosed in single quotes (' ')
enabledbprefix	The following settings are available: yes - the database name is used as prefix (see tablespace options in DB2 OS/390) no - the database name is not used as prefix

Default= and/or List= can also be used with the composite=, separator= and parenthesis= keywords. Category= can be used with the three keywords of a composite option.

Example

The IBM DB2 index options contain the following composite option:

<using_block> : composite=yes
{
 using vcat %s
 using stogroup %s : category=storage, composite=yes
 {
  priqty %d : default=12
  secqty %d
  erase %s : default=no, list=yes | no
 }