For your convenience, a script file named asql.bat (asql.sh on UNIX/Linux) is included with AcuXDBC. You can use this file to start xdbcquery and connect to a database and system catalog, either locally or on a remote machine. The xdbcquery script has the following usage:
asql [-c config] [-u user] [-p password] [-r script]
[-s server] [-n port]
| Option | Parameter | Default | Description |
|---|---|---|---|
| -c | configuration filename | acuxdbc.cfg | Specifies the configuration file that identifies the database and catalog location, which is %GENESIS_HOME% on Windows and $GENESIS_HOME on UNIX |
| -u | user name | system | Specifies the user name to connect to the database as |
| -p | password | manager | Specifies the password for the user |
| -r | script name | none | Runs the specified script |
| -s | server | none | Specifies a name or IP address |
| -n | port | 20222 | Specifies the port to connect to |
asql -u mary -p 123
Because no configuration file was specified in this example, this command connects the user Mary to the database and catalog specified in the acuxdbc.cfg configuration file.