RuggedCom RS400 manual Using SQL Commands, Getting Started, Finding the Correct Table

Upgrading Firmware and Managing Configurations

14.3 Using SQL Commands

The ROS™ provides an “SQL-like” command facility that allows expert users to perform several operations not possible under the user interface, namely:

•Restoring the contents of a specific table, but not the whole configuration, to their factory defaults

•Search tables in the database for specific configurations

•Make changes to tables predicated upon existing configurations

When combined with RSH, SQL commands provide a means to query and configure large numbers of devices from a central location.

14.3.1 Getting Started

SQL information is obtainable via the CLI shell “SQL” command:

>sql

The SQL command provides an 'sql like' interface for manipulating all system configuration and status parameters. Entering 'SQL HELP command-name' displays detailed help for a specific command. Commands, clauses, table, and column names are all case insensitive.

DEFAULT	Sets all records in a			table(s) to	factory defaults.
DELETE	Allows for	records	to	be deleted from a table.
HELP	Provides help for any			SQL command or clause.
INFO	Displays a	variety	of	information about the tables in the database
INSERT	Allows for	new records to be inserted into a table.
SAVE	Saves the database		to non-volatile memory storage.
SELECT	Queries the database and displays selected records.
UPDATE	Allows for	existing records in a table to be updated.

Figure 181 The SQL command and SQL help

14.3.2 Finding the Correct Table

Many SQL commands operate upon specific tables in the database, and require the table name to be specified. Navigating the menu system to the desired menu and pressing <CTRL Z> will show the name of the table. The menu name and the corresponding database table name will be cited.

Another way to find a table name is to run the “sql info tables” command. This command also displays menu names and their corresponding database table names depending upon the features supported by the device.

RS400 255 ROS™ v3.5