Parameter: system_createupperindex

Startup parameters change the behavior of the Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

system_createupperindex

Description

This parameter enables the Service Manager server to convert specified tables in an Oracle database to use UPPER indexes. Use this parameter in conjunction with the sqlupper parameter. For more information, see Parameter: sqlupper.

Note When running this command, error messages that resemble the following may occur, which can be safely ignored:

3952( 4916) 09/18/2014 11:48:15 RTE E could not find key addl.parents in ocml

In this example, the key field (addl.parents) is an array, and mapped to a separate table on SQL. The error message occurs because the index cannot be generated on the main table (OCMLM1). The index will be generated later on the new table (OCMLA1).

Valid if set from

Server's operating system command prompt

Requires restart of the Service Manager server?

Yes

Default value

None

Possible values

all (Convert all tables in the Oracle database)

list of table names separated by a comma (Convert specified tables in the Oracle database)

Example usage

sm -system_createupperindex:all

sm -system_createupperindex:cm3r,cm3t

Related topics

Oracle case-sensitivity
Enter a parameter in the sm.ini file
Parameter: sqlupper