RuggedCom RSG2488 User Manual

Chapter 2
Using ROS
RUGGEDCOM RSG2488
User Guide
40 Changing Values in a Table
sql select from table where parameter = value [ { and | or } | parameter | = |
value ...]
Where:
• table is the name of the table
• parameter is the name of the parameter
• value is the value of the parameter
Example:
>sql select from ethportcfg where media = 1000T and State = enabled
Port Name ifName Media State AutoN Speed Dupx FlowCtrl LFI
Alarm
1/1 Port 1 1/1 1000T Enabled On Auto Auto Off Off on
1/2 Port 2 1/2 1000T Enabled On Auto Auto Off Off On
1/3 Port 3 1/3 1000T Enabled On Auto Auto Off Off On
1/4 Port 4 1/4 1000T Enabled On Auto Auto Off Off On
4 records selected
Section 2.6.4.3
Changing Values in a Table
Use the following command to change the value of parameters in a table:
sql update table set parameter = value
Where:
• table is the name of the table
• parameter is the name of the parameter
• value is the value of the parameter
Example:
>sql update vlanportcfg set pvid = 2
8 records updated
Conditions can also be included in the command to apply changes only to parameters that meet specific criteria.
In the following example, flow control is enabled on ports that are operating in 100 Mbps full-duplex mode with
flow control disabled:
Conditions can also be included in the command to apply changes only to parameters that meet specific criteria.
In the following example, the PVID is changed to 2 on port 1/2.
>sql update vlanportcfg set pvid = 2 where port = 1/2
1 records updated
Section 2.6.4.4
Resetting a Table
Use the following command to reset a table back to its factory defaults:

RuggedCom RSG2488 Specifications

General

Brand	RuggedCom
Model	RSG2488
Category	Switch
Language	English