RuggedCom RSG2488, Руководство пользователя

Страница: 50 / 194

Chapter 2
Using ROS
RUGGEDCOM RSG2488
User Guide
38 Finding the Correct Table
NOTE
For a list of parameters available under the sql command, refer to Section 2.6.1, “Available CLI
Commands” .
The following sections describe in more detail how to use SQL commands:
•
Section 2.6.4.1, “Finding the Correct Table”
• Section 2.6.4.2, “Retrieving Information”
• Section 2.6.4.3, “Changing Values in a Table”
• Section 2.6.4.4, “Resetting a Table”
• Section 2.6.4.5, “Using RSH and SQL”
Section 2.6.4.1
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 in the console interface to the desired menu and pressing Ctrl-Z displays 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 type the following in the CLI:
sql
info tables
This command also displays menu names and their corresponding database table names depending upon the
features supported by the device. For example:
Table Description
-------------------------------------------------------------------------------
alarms Alarms
cpuDiags CPU Diagnostics
ethPortCfg Port Parameters
ethPortStats Ethernet Statistics
ethPortStatus Port Status
ipCfg IP Services
Section 2.6.4.2
Retrieving Information
The following describes various methods for retrieving information about tables and parameters.
Retrieving Information from a Table
Use the following command to display a summary of the parameters within a table, as well as their values:
sql
select from table
Where:
•
table is the name of the table
Example:
>sql select from ipAddrtable