Online Documentation for SQL Query for DB2

Grid


Colors

Options of this group allow you to set colors for basic grid elements. Use the ellipsis EllipsisButton button to open the Color dialog allowing you to select the required color from the palette.

 

Grid

Defines the background color of the data grid.

 

Row

Defines the color of the selected row in the data grid.

 

Stripy

Defines the color of the odd rows (applied if the Stripy grids option is set).

 

 

Display formats

Integer fields

Defines the format for displaying SMALLINT, INTEGER and BIGINT fields.

 

Float fields

Defines the format for displaying DOUBLE and DECIMAL fields.

 

DateTime fields

Defines the format for displaying DATETIME fields.

 

Date fields

Defines the format for displaying DATE fields.

 

Time fields

Defines the format for displaying TIME and TIMESTAMP fields.

 

hs4117 - Environment Options - Grid

 

 

NULL values

Text

Defines the text that stands for NULL values in grid.

 

Font color

Defines the font color for displaying NULL values in the grid. Use the ellipsis EllipsisButton button to open the Color dialog allowing you to select the required color from the palette.

 

 

Options

CheckBox Stripy grids

Displays the odd grid rows in the colors specified by the Stripy option.

 

CheckBox Use Ctrl+Up to increase spin values

Allows you to use the Ctrl+Up and the Ctrl+Down key combinations for editing the spin values (numeric field values).

 

CheckBox Show editor immediately

Checking this option allows you to edit the cell value immediately after you click the cell.

 

CheckBox Enable auto-search in grid

If this option is checked, the cursor is automatically forwarded to the closest match when you start typing.

 

CheckBox Row multi-selection

With this option set, multiple rows can be selected in grid.

 

CheckBox Show text fields as string

If this option is checked, the text fields are viewed as ordinary strings. Otherwise they are displayed as BLOB fields.

 

Max fields width (chars)

Defines the maximum width of CHAR and VARCHAR fields displayed in the grid.

 

Min fields width (chars)

Defines the minimum width of CHAR and VARCHAR fields displayed in the grid.

 

 

Grid layout preferences

RadioButton Save and restore layout

Select the option to keep the original grid width.

 

RadioButton Autofit column width
Select option to shrink the grid columns so that the longest visible value fits the column width.