Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL » Interactive SQL options

bell option [Interactive SQL] Next Page

command_delimiter option [Interactive SQL]


Sets the string that indicates the end of a statement in Interactive SQL.

Allowed values



Semicolon (;)


In general, there is no need to change the command delimiter. You should leave it as a semicolon.

An alternative to using a semicolon or another string as a statement delimiter is to enter the separator go on a line by itself, at the beginning of the line. See Introduction to batches.

Specifying go on its own line is always recognized as a command delimiter, even if you set the command_delimiter option to a different value.

The command_delimiter value can be any string of characters with the following restrictions:

See also

The following example sets the command delimiter to a tilde:

SET OPTION command_delimiter='~';
MESSAGE 'hello'~

You can also use the Interactive SQL -d option to set the command delimiter without including a SET OPTION command_delimiter statement in a .sql file. For example, if you have a script file named test.sql that uses tildes (~) as the command delimiter, you could run:

dbisql -d "~" test.sql