em_SQL or SQL

The em_SQL utility (on Windows) or SQL utility (on UNIX) enables you to connect to the database from the command line. This utility is automatically installed on Windows computers during installation of the GUI Server component.

Running the Utility

This procedure describes how to run the em_SQL utility (on Windows) or the SQL utility (on UNIX), which enables you to connect to the database from the command line.

Begin

  1. Do one of the following:

    • UNIX: Log in to a Control-M/EM account.

    • Windows: Open a command prompt window as Administrator where Control-M/EM is installed. You do not need to be in the Control-M/EM database directory.

  2. Type one of the following commands:

    • UNIX: em SQL

    • Windows: em_SQL -U <userName> -P <password>

      SQL, U, and P must be specified in uppercase.

  3. On UNIX, enter a password for the Control-M/EM database owner.

em_SQL utility Parameters

The following table describes the em_SQL utility parameters:

Parameter

Description

-U <userName>

Defines the user name.

The U must be specified in uppercase.

-P <password>

Defines the password.

The P must be specified in uppercase.