skip to main content
Configuring the JDBC Client : Using Interactive SQL for JDBC : Redirecting Output from JDBCISQL
 

Redirecting Output from JDBCISQL

JDBCISQL can be easily used from other processes to execute SQL commands to retrieve results. Having JDBCISQL output its results and errors to stdout and stderr, respectively, facilitates this. An error in executing a query is sent to stderr. All results including the column names and the output values are sent to stdout.
You can use redirection to execute. For example, the following command executes queries from the test.sql file and sends the output to output.txt and errors to errors.txt:

jdbcisql -c test.sql > output.txt 2> errors.txt