SQL interactive interface command-line options

You can specify a number of command-line options when you start the SQL interactive interface.

The following table lists the available command-line options.
Table 1. SQL interactive interface command-line options
Command-line option Description
-help Use this option to display help information about the command-line options.

For Linux operating systemFor UNIX operating system-input string

For Windows operating system-i string

 Use this option to specify the location of an SQL input file. The SQL commands in the file are run on the ObjectServer to which the SQL interactive interface connects.
Note: When you connect with the -nosecure option, you must use the -input option to read the file instead of the standard file input syntax < file_name.

For Linux operating systemFor UNIX operating system-networktimeout integer

For Windows operating system-l integer

For Windows operating system-t integer

For Linux operating systemFor UNIX operating systemUse this option to specify a timeout period (in seconds) for login attempts and for the connection to the ObjectServer when a network failure occurs.

After the specified timeout period, the interface attempts to reconnect to the ObjectServer. If the connection is unsuccessful after a second timeout period, the interface attempts to connect to a backup ObjectServer (when available).

Note:

The nco_sql command runs the nco_get_login_token utility to obtain a login token and starts the interface with the token. The specified timeout period is passed to nco_get_login_token and to the interface when they are started.

Login tokens are valid for only 15 seconds. Therefore, the maximum allowed timeout period in the default secure mode is 14 seconds. You can specify a longer timeout period when you use the -nosecure option.

For Windows operating systemThe -l option specifies a login timeout period. The default is 60 seconds.

The -t option specifies a timeout period for commands. If you do not specify a timeout period, commands can run indefinitely.
-nosecure Use this option to specify that login information is not encrypted when it is transmitted between the interface and the ObjectServer.

For Linux operating systemFor UNIX operating system-password string

For Windows operating system-P string

 Use this option to specify the user password.

For Windows operating systemThe -P option is mandatory, even when you use an empty password string (as when you connect to the default NCOMS ObjectServer).
-secure Use this option to specify that login information is encrypted when it is transmitted between the interface and the ObjectServer.

A secure connection is the default.

For Linux operating systemFor UNIX operating system-server string

For Windows operating system-S string

 Use this option to specify the name of the ObjectServer to which to connect.

The default is NCOMS.

For Linux operating systemFor UNIX operating system-user string

For Windows operating system-U string

 Use this option to specify a Tivoli Netcool/OMNIbus user name.

The default is the user that is running the command.

If the user name contains spaces, enclose it in double quotation marks ("). For example:

$NCHOME/omnibus/bin/nco_sql -server NCOMS -user "NCOMS Admin"