Opens a SQL command line shell inside UXTerm, which can be used to connect to and issue queries against any SQL-compliant database for which JDBC support is available. The command utilizes the SQLLine library, and currently supports all features offered by SQLLine 1.1.9.
This command opens a SQL command line shell inside UXTerm, which can be used to connect to and issue queries against any SQL-compliant database.
dbc [-d <driver>]
fully qualified class name of the JDBC driver to be used for connecting to the database (e.g.
All commands starts with
!. Others are treated as SQL statements. Use tab for autocompletion.
!properties command to connect to the database defined in the specified properties file.
A set of sample property values is included in the UXTerm configuration file.
!record <file> to save command output to files.
This is recommended for outputs with more than 5 columns as terminal display isn’t scrollable.
!rehash to fetch data for autocompletion. (Warning: this may take long.)
!set incremental true to stop formatting output through buffering.
!exit or the end-of-input key combination (
Ctrl + D) to exit the shell.
If the program cannot find the JDBC Driver, add the respective JAR file (e.g.
mysql-connector-java.jar for MySQL)
$X_HOME/lib/custom folder and restart UXTerm.
Refer the SQLLine manual for more details.