Online Documentation for SQL Manager for DB2

Fields

Using the Fields tab you can set font options, border and fill options and aggregate functions for all the fields you want to export.

The Font tab allows you to specify properties of the font that will be used in the output Excel file cells.

Use the Font and Size drop-down lists to select the font and size to be applied to the output text.

Use the buttons below to set font color, make text bold, italicized, strikethrough text, set underline effects, specify text horizontal and vertical align.

The Borders tab allows you to specify properties of the borders of the output Excel file cells.

Click the buttons on the left to show/hide the borders they indicate.

Use the drop-down list for each border to select the line type and the button on the right to select the line color for each border.

The Fill tab allows you to specify the fill pattern for the output Excel file cells.

Use the drop-down list to select the preferable fill pattern type.

Click the button on the left to set the background color for the fill pattern.

Click the button on the right to set the foreground color for the fill pattern.

The Aggregate tab allows you to specify an aggregate function for the field in the output Excel file.

Select a function that will be applied to the field:

None

AVG

MAX

SUM

MIN

You can reset the changes any time using the Reset Item and the Reset All buttons.