SQL parameters: sqljoinsok

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

Parameter

sqljoinsok

Description

The values for this parameter comprise a comma-delimited list of tables for which outer joins are allowed.

DB2 on OS/390 allows only outer joins on tables if the primary key is a single field, not a composite key. The server references this list to determine validity whenever a join file is used.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

No

Default value

None

Possible values

A comma-delimited list of table names

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqljoinsok:problem, incident, contact, operator

Initialization file: sqljoinsok:problem, incidents, contacts, operator