SQL parameters: sqldictkey

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

sqldictkey

Description

This parameter defines the primary key of the RDBMS column where the Service Manager database dictionary resides. You only need to specify this parameter if you are using the sqldictionary parameter and you are also using a primary key other than the name field.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

Yes

Default value

name

Possible values

Primary key of the RDBMS column containing the name field of the database dictionary

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqldictionary:dbserver -sqldictkey:id

Initialization file: sqldictkey:id

Related topics

System parameters
Enter a parameter in the sm.ini file
Database parameters