RuggedCom RS400 manual Changing Values in a Table, Setting Default Values in a Table

Upgrading Firmware and Managing Configurations

results. As an example, suppose that it is desirable to identify all ports on the device operating in Auto Select mode.

>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

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.

>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

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.

>sql update ethportcfg set flow_control=enabled where ( media_type = Auto_Select and flow_control = disabled )

1 records updated

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.

>sql default into ethportcfg

Figure 188 Setting default values into a table

RS400 257 ROS™ v3.5