6. Firmware Upgrade and Configuration Management
ROS® v3.11User Guide
111
RMC30
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:
Table Description
-------------------------------------------------------------------------------
alarms Alarms
cpuDiags CPU Diagnostics
ethPortCfg Port Parameters
ethPortStats Ethernet Statistics
ethPortStatus Port Status
ipCfg IP Services
6.7.3. Retrieving Information
Retrieving a Table
The SQL select subcommand is used to retrieve table information. The command, “sql select
from ‘tablename’”, provides a summary of the parameters within the table, as well as their
values:
>sql select from ipcfg
IP Address Type IP Address Subnet Gateway Management VLAN
Inactivity Timeout Telnet Sessions Allowed Web Server Users Allowed TFTP Server
ModBus Address SSH Sessions Allowed
Static 10.90.0.2 255.0.0.0 1
Disabled 8 16 Get Only
Disabled 8
1 records selected
Retrieving a Parameter from a Table
SQL select command may be used to retrieve a particular parameter from a table. SQL
command “sql select parameter_name from tablename” is used for this purpose. The
parameter name is always the same as those displayed in the menu system. If the parameter
name has spaces in it (e.g. “IP Address”) the spaces must be replaced with underscores or
the name must be quoted:
>sql select "ip address" from ipcfg
IP Address
192.168.0.8
1 records selected
Retrieving a Table with the ‘Where’ Clause
It is useful to be able to display specific rows of a table predicated upon the row having
parameters of a specific value. Addition of "where" clause to the "select" statement will limit
the results returned. For example, suppose that it is desirable to identify all ports on the device
operating in Auto Select mode:
