em_SQL

The em_SQL utility 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 em_SQL Utility

This procedure describes how to run the em_SQL utility, 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 the following command:

    em_SQL -U <userName> -P <password>

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

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.