Starting xdbcquery from asql

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

Example

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.

Note: You can modify the default parameters directly within asql.bat or asq.sh to match your settings and then simply run the asql file from the same directory where xdbcquery is installed.