RuggedCom Welder RS400 用户手册

Upgrading Firmware and Managing Configurations 

 

 

ROS™  v3.5 

256 

RS400 

 

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. 

 

 

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.  

 

 

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 

>sql select "ip address" from ipcfg 
 
IP Address 
192.168.0.8 
 
1 records selected 
 

>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 

>sql info tables 
 
Table                    Description 
------------------------------------------------------------------------------- 
alarms                   Alarms 
cpuDiags                 CPU Diagnostics 
ethPortCfg               Port Parameters 
ethPortStats             Ethernet Statistics 
ethPortStatus            Port Status 
ipCfg                    IP Services