Starting xdbcquery from mfsql

For your convenience, a script file named mfsql.sh is included with Micro Focus XDBC. 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:

 mfsql [-c config] [-u user] [-p password] [-r script]
             [-s server] [-n port]

Option	Parameter	Default	Description
-c	configuration filename	mfdbc.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

Example

mfsql -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 mfdbc.cfg configuration file.

Note: You can modify the defaults used by all of the script files by editing the mfxset file located in your installation's bin directory. This allows you a convenient way to set your site-specific defaults without having to place them in the directory. Each script file provides command-line options to override each default.