Starting xdbcquery from the Command Line

Execute the following xdbcquery connect command. (No spaces are allowed between parameters.)

xdbcquery /cacuxdbc04:[user name]/[password]/ xvision: [configuration file name]

where:

/c Is the xdbcquery connect command
acuxdbc04 Is the SQL driver with which to connect
user name ¹ Is the user name
password ¹ Is the user password
xvision Is the driver providing access to the COBOL data files with which to connect
configuration file name     Is the file that specifies the data source and catalog location, which must be in %GENESIS_HOME% on Windows and in $GENESIS_HOME on UNIX.
1

Example

xdbcquery /cacuxdbc04:system/manager/xvision:acuxdbc.cfg  
Note: If you have not set up database security, you can omit the user name and password, but you need to keep the two forward slashes before xvision as place holders.

You are now connected to the system catalog and can execute xdbcquery-specific commands or execute SQL statements on your catalog tables. See Summary of Supported SQL Commands for the complete list of SQL commands and functions supported by AcuXDBC.