Getting Started with SAND CDBMS: Using SAND CDBMS
Using the SAND CDBMS Interactive SQL Utility

 

Previous Topic: Running the nisqlm Utility

Chapter Index

Next Topic: Useful nisqlm System Commands

Nisqlm Command Modes

nisqlm has two command modes: SQL and SESS (session). The current mode is indicated by the nisqlm prompt. SQL mode allows the execution of SQL commands. SESS mode involves commands related to user sessions, for example CONNECT and DISCONNECT. To change from one mode to another, type the mode name prefixed by a period, for example:

SQL:1> .SESS
SESS:1> .SQL
SQL:2>

All SQL and SESS mode commands must end with a semicolon ( ; ).

The nisqlm system commands (see below) can be executed from any command mode. They must be prefixed with a period, but do not require a terminal semicolon.