Filter
Top Products
Upgrading Firmware and Managing Configurations
RS400 257 ROS™ v3.5
results. As an example, suppose that it is desirable to identify all ports on the device operating
in Auto Select mode.
Figure 185 Selecting rows in a table based upon parameter values
It is also possible to select rows based upon multiple parameters by and-ing or or-ing
comparisons in the ‘where’ clause. Ensure that parentheses are used to enclose the full ‘where’
clause.
Figure 186 Selecting rows in a table based upon multiple parameter values
14.3.4 Changing Values in a Table
“Where” clause can be used to select rows in a table and to modify them fields in that row. As
an example, suppose that it is desirable to identify all ports on the device operating in 100 Mbps
full duplex with flow control disabled, and to enable flow control on these ports.
Figure 187 Changing Values In A Table
14.3.5 Setting Default Values in a Table
It is sometimes desirable to restore one table to its factory defaults without modifying the
remainder of the configuration. The sql default command allows an individual table to be
defaulted.
Figure 188 Setting default values into a table
>sql update ethportcfg set flow_control=enabled where ( media_type = Auto_Select
and flow_control = disabled )
1 records updated
>sql select from ethportcfg where Media_Type = Auto_Select
Port Name Status Media Type Flow Control FEFI Link Alarms
5 Port 7 Enabled Auto Select Enabled Disabled Enabled
6 Port 8 Enabled Auto Select Disabled Disabled Enabled
2 records selected
>sql select from ethportcfg where Media_Type = Auto_Select and Flow_control =
Disabled
Port Name Status Media Type Flow Control FEFI Link Alarms
6 Port 8 Enabled Auto Select Disabled Disabled Enabled
1 records selected
>sql default into ethportcfg