Direct SQL Statements
SQL statements are described in detail in the SQL Statements section of this help file. Each statement must be terminated by a semicolon. A statement can extend beyond one line if the Return/Enter key is pressed before entering the semicolon.
ACEINT parses the statement for syntactical errors and then sends the statement via the CONNX JDBC Server to the Adabas SQL Gateway for execution.
The CONNECT statement requires a minimum of 2 parameters - server_name and user_name. The third parameter 'password' is optional. However, this must be supplied if the user being connected requires a password.
The server_name parameter requires, at the very minimum, a value for the DSN to be used for the connection. If no other values are supplied, the default values for GATEWAY (LOCALHOST) and PORT (7500) are used.
If the DSN is the first or only value in the server parameter, the prefix 'DD=' can be ignored. Examples:
CONNECT TO 'DD=MYDSN,PORT=7777' USER MYUSER;
CONNECT TO MYDSN USER MYUSER PASSWORD 'password';
If more than one parameter is supplied for the Server Name, the whole Server Name string must be enclosed in single quotes.
The 'server_name' parameter on the CONNECT statement can be split over multiple lines. This is especially useful when executing in a Mainframe environment due to line length restrictions. The maximum length of the 'server_name' parameter is 255 bytes. Each portion of the 'server_name' parameter must be enclosed in quotes ('). If the parameter is to be continued on the next line, this should be indicated by a plus (+) character. Here is an example:
CONNECT TO
'DD=MYDSN,' +
'GATEWAY=MYGATEWAY,' +
'PORT=7777'
USER MYUSER;