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
-
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.
-
-
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.
-
-
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. |