RuggedCom RS400 manual Retrieving Parameter from a Table, Retrieving a Table with Where Clause

Upgrading Firmware and Managing Configurations

>sql info tables
Table	Description

-------------------------------------------------------------------------------

alarms	Alarms
cpuDiags	CPU Diagnostics
ethPortCfg	Port Parameters
ethPortStats	Ethernet Statistics
ethPortStatus	Port Status
ipCfg	IP Services

Figure 182 Brief snippet of SQL command for finding the correct table name

14.3.3Retrieving 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

Figure 183 Selecting a table

Retrieving 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

Figure 184 Select a parameter within a table

Retrieving A Table with 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 will limit the returned

ROS™ v3.5 256 RS400