ASA Database Administration Guide
  Database Options
    Alphabetical list of options

COMMAND_DELIMITER option [ISQL]

Function 

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

Allowed values 

String

Default 

Semi-colon (;)

See also 

The Interactive SQL utility

Description 

You can specify a command delimiter to indicate the end of a SQL statement. This command delimiter can be any sequence of characters (including numbers, letters, and punctuation), but it cannot contain embedded blanks. As well, it can contain a semicolon, but only as the first character.

If the command delimiter is set to a string beginning with a character that is valid in identifiers, the command delimiter must be preceded by a space. This command delimiter is case sensitive. You must enclose the new command delimiter in single quotation marks.

Note that if the command delimiter is a semicolon (the default), no space is required before the semicolon.

Example 1 

SET OPTION COMMAND_DELIMITER='~'

Example 2 

set temporary option command_delimiter = ' select';
message 'hello' select

Example 3 

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

dbisql -d "~" test.sql