Ssasql SQL mode commands are prefixed with a period (

.

) in order to distinguish them from the command set for the current mode. Any command that is not prefixed by a period is executed within the context of the current mode; ssasql issues an error message if the command does not belong to the current mode's command set. Ssasql commands are not case-sensitive.

In order to execute a command belonging to the current operating mode, the command must not be prefixed by a period, and must be terminated by a semicolon (

;

).

To execute a command in another mode without leaving the current mode, precede the command with the system command normally used to change to the desired mode, as in the following example:

Here, the DISCONNECT statement is executed from SQL mode by prefixing it with the system command normally used to change to SESS mode, that is,

.SESS

. Note that the statement is terminated with a semicolon ( ; ) — in this case, however, it is not necessary to include the semicolon, since the command is executed with the mode prefix.