gfxd Interactive Commands

gfxd implements an interactive command-line tool that is based on the Apache Derby ij tool. Use gfxd to run scripts or interactive queries against a GemFire XD cluster.

Start the interactive gfxd command prompt by using the gfxd or gfxd.bat script without supplying any other options:
The system property gfxd.history specifies a file in which to store all of the commands executed during an interactive gfxd session. For example:
$ export JAVA_ARGS="-Dgfxd.history=/Users/yozie/gfxd-history.sql"
$ gfxd

By default the history file is named .gemfirexd.history, and it is stored in the current user's home directory.

gfxd accepts several commands to control its use of JDBC. It recognizes a semicolon as the end of a gfxd or SQL command. It treats semicolons within SQL comments, strings, and delimited identifiers as part of those constructs and not as the end of the command. Semicolons are required at the end of a gfxd or SQL statement.

All gfxd commands, identifiers, and keywords are case-insensitive.

Commands can span multiple lines without using any special escape character for ends of lines. This means that if a string spans a line, the new line contents show up in the value in the string.

gfxd treats any command that it does not recognize as a SQL command that is passed to the underlying connection. This means that any syntactic errors in gfxd commands are handed to the SQL engine and generally result in SQL parsing errors.