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. CDDs to be used by ACEINT 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.
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.
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 1:
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.
Note 2:
ACEINT executes by default in interactive mode.
At the ACEINT prompt, the user can enter SQL statements as well as ACEINT specific statements and commands.
For batch mode processing, see the section Batch Processing later in this Chapter.