Introduction to ACEINT
The ACEINT utility is used to interactively submit or process SQL statements. ACEINT utilizes the CONNX JDBC interface, therefore, users cannot directly access or reference a CDD for a connection. The CDDs that ACEINT will use must first be mapped to a Data Source Name via the CONNX Data Source Name Registry. Instructions on how to use the CONNX Data Source Name Registry can be found in the Adabas SQL Gateway help files.
Starting ACEINT
ACEINT can be started using the following command syntax:
ACEINT {<option> <option> ...}
IBM z/OS customers should refer to the section Mainframe Considerations for information concerning the execution of ACEINT on the mainframe.
Options
Every option begins with a minus (-). The names of the options are not case-sensitive.
The following command line options are available:
Option | Description |
-a | Statements starting with an asterisk (*) are treated as comments. |
-e | Terminates processing on SQL error. |
-f <input_file> | File <input_file> used as input to ACEINT. |
-n<server_name> | Server <server_name> to which the session is to connect. (Used together with option -u.) Note: The server_name string need not be enclosed in quotes. |
-p <password> | Password <password> for user defined with -n and -u. (Used together with options -n and -u.) |
-t | Displays elapsed time required to process each SQL statement. |
-u <user_name> | User <user_name> to be connected to server defined with -n. (Used together with option -n.) |
Note:
All of the options described above are optional. If the -n, -u (and, if required, -p) options are supplied when starting ACEINT, a connection to the requested server will be made immediately. In such an instance, it is not necessary to enter a CONNECT SQL statement at the ACEINT prompt.
ACEINT executes in interactive mode by default. At the ACEINT prompt, the user can enter SQL statements and ACEINT specific statements and commands. For batch mode processing, see the section Batch Processing later in this Chapter.