Parameter file field descriptions


table/module specification
Description	This field consists of a list of comma-separated table names or a module name to which the entry applies. An asterisk (*) indicates all tables.
Example	ttadv000,ttadv999	two specific tables
	ttadv	all tables in module tt and package adv
	tt	all tables in module tt
	*	all tables


company number
Description	This field consists of a list of company numbers to which the entry applies. An asterisk (*) indicates all company numbers.
Example	000,999	companies 000 and 999
Example	*	all companies


object type
Description	This field consists of a list of object (table or index) identifications to which the entry applies. You can specify these options:
	T	table only
	I	all indexes
	I <index number>	only specified index
	*	both table and indexes
Example	I1,I2	only index 1 and 2
Example	T	only for table


Compress specification
Description	When this field is present the table or index is compressed.
Example	COMPRESS=1;	Compression is used for the selected table(s) (DATA_COMPRESSION = PAGE)


group (only for msql_storage file, not for msql_storage_param file)
Description	This field identifies the owner of the table. The value group must be specified.


query optimization
Description	Specific flags related to indexes and tables can be specified. When specified on a “T” object entry, it defines the default for all indexes. These octal values can be used to set the flags for a specific index or table:
	0000	no optimization
	00200	nested
	00400	iterative
	01000	filter
	Default values can be defined for each table entry. Optimizations are explained in more detail in Query Tuning.
Example	00400


refresh time
Description	This is an obsolete parameter which is ignored by the driver.
Example	-


storage parameters
Description	These are defined by the specific database driver implementation and often map to table and index creation options available in the host RDBMS. The storage parameters for the MSQL database driver can be specified in either all upper case or all lower case letters. The following MSQL storage parameters are defined: FILL FACTOR <n>Includes the fill factor <n> clause in the create index statement during index creation. FILEGROUP <file group name>Includes the “on <file group name>” clause in the create table or create index statement during object creation.
Example	FILEGROUP primary


driver parameters
Description	This is an obsolete parameter which is ignored by the driver.
Example