This section describes the commands available when using JDBCISQL.
autocommit [on | off]
Turns auto commit mode on or off.
commit
Writes pending changes to the database.
cmdfile file_name
Reads the commands from the given command file. The file is assumed to contain UTF-8 encoded data.
connect [[userID*password@]connection_properties]
Connects to the data source specified by the JDBC connection properties. The userID and password are required when connecting to a server which requires userID and password. For example, the Memory sample data source requires userID and password.
The program supports only one connection at any instance. If you are connected to another server, that connection will be closed before establishing the new connection. For example:
If -p jdbc:openaccess://localhost:19986;ServerDataSource= was specified when running JDBCISQL, then in the connect command, you only need to provide the data source name and any additional connection properties you want to specify:
ISQL> connect pooh*bear@memory
If -u is used to specify all connection properties except UID and PWD properties, then you use the following command:
ISQL> CONNECT pooh*bear@
If -u is used to specify all connection properties, including UID and PWD, then you use the following command:
ISQL> CONNECT
disconnect
Disconnects from the data source.
echo information
Echoes the given information.
errfile file_name
Errors are written to the file_name file.
# [comment]
Ignores the text following the pound sign (#). This is useful when JDBCISQL is set up to run automated test scripts that can be documented with comment lines. Note that if the -e option is enabled, the comment will be echoed to the standard out.
sql_smt;
Executes only the supported set of SQL statements. This command supports the following DML statements (SELECT, INSERT, UPDATE, DELETE, CALL) and DDL statements (CREATE TABLE, DROP TABLE). The SQL statement can be entered on multiple lines and must be terminated by a semicolon.
exit
Quits the Interactive SQL session after closing any active connection.
help
Provides online help for the supported commands.
quit
Quits the Interactive SQL session after closing any active connection.
repeat number command end
Repeats the given command specified number of times. Any supported command can be repeated, except another repeat command.
reshuffle filename
Logs the results to the given file. If the file name is not specified, it logs the results to standard output.
