Options - Display Options

These are a number of miscellaneous options controlling how data is displayed.

Show Row Numbers

Specifies whether Row Numbers are shown. This gives the default behaviour; when displaying a query result you can switch Row Numbers on and off by View > Row Numbers, clicking the icon, or F4.

Show Group-by Box

Specifies whether the group-by box will be shown on the data display. This gives the default behaviour; when displaying a query result you can switch the Group-by box on and off by View > Group-by Box, clicking the icon, or Ctrl+G.

Variable Row Height

Specifies whether the data display will show the data using variable height for the rows. This is useful if your data contains multi-line text columns.

This option is set to the default behaviour. When you display a query result you can switch the variable-height display on and off by View > Variable Row Height, clicking the icon, or Ctrl+H.

This option is CPU-intensive and can significantly slow down the data display. For this reason, the setting of this option (unlike most of the others) is not saved between AQT sessions.

Maximum Column Width

Gives the maximum width (in pixels) of a column in the data display. The default value is 500; you may wish to increase this if you often deal with large columns.

When you change this value, the grids in your existing Data Display windows will not be changed to reflect this new value. You must do a Refresh of the data for the new value of Maximum Column Width to come into effect.

Minimum Row Height

This gives the height of rows in the display grid. The default value (20) is normally adequate. However if you change the font to a larger or taller font, you may need to increase this.

Maximum Row Height

Gives the maximum height (in pixels) for a row, when the Variable Row Height option is in effect. The default value is 1000.

Use Correct Data Types for Grid Columns

This is a technical option concerning the way AQT uses the grid.

When this option is selected, the columns in the grid will be defined as per the data type of the data being displayed:

• numeric columns will be displayed in a numeric grid column.
• date and time columns will be displayed in a date grid column.
• boolean columns will be displayed in a boolean grid column. They will appear as a checkbox.
• all other data types will be displayed in a character grid column.

In most cases, this will display the data correctly. However there are some possible problems:

• the data will not display as it was retrieved from the database. Instead, the grid will format the data using it's own formatting process. In some circumstances, you may wish to see the data exactly as retrieved from the database. This is discussed more at How Numeric Values are Displayed.
• if there is any "invalid" data, the values will not display; instead a flashing error-box will be shown. This can sometimes happen with date values:
  • any date less than 0001-01-02 or greater than 9999-12-31 will not display. This is a limitation of the .Net environment.; dates outside of this range are not valid dates.
  • DB2 displays midnight as 24:00:00. The grid will display this as an invalid time.

When this option is not selected, all grid-columns will be defined as character. The data will display more accurately, however:

• numeric and date columns will not sort correctly. They will sort in character order, rather than numeric or date order.
• the Totals and Sub-totals functions of the Data Display window will not be available.
• Pivot will not recognize any columns as being numeric; consequently it will think that there are no columns which are candidates for the Analysis column.

By default this option is selected. If you have a problem with the display of numeric columns, you should switch this option off.

Display Date columns as character

This is similar to the previous option, but this is only done for Date columns.

This allows you display Date columns as character, but display columns of other types normally. You would do this by de-selecting Use Correct Data Types for Grid Columns and selecting this option.

Show ROWID

This option is useful for databases that have an internal table row identifier that can be displayed with the contents of the table.

• for Oracle, Informix and SQLBase this is called the ROWID
• for SAP DB and MAXDB this is called the SYSKEY
• for PostgreSQL this is called the OID
• for DB2 for LUW, this is called the RID

When this option is selected, this rowid is displayed when a table is displayed. AQT does this by changing the table-display SQL to include the rowid column.

You may notice that this option doesn't come into effect right away - only on the next table you display.

Displaying the rowid is often useful when you wish to edit the data in a table. AQT will recognise the rowid column as a valid table key, and will use this to identify the rows you are updating or deleting.

Show Length of Varchar Columns?

This is a potentially useful option for database developers. When a value is inserted into a Varchar column the length of the column has to be set (in C and Java this is generally done with the null byte, in other languages a length field is set). When you display the table you can verify that the data has been loaded correctly, however the column length cannot be seen.

When you select this option the length of the column is displayed, along with the data. For instance FRED will be displayed as (4)FRED. This can be useful for verifying that the column lengths have been set correctly - if instead you see (20)FRED then you know that you are filling your database up with a lot of unnecessary blanks! This has happened on some projects we have been involved in.

Remove trailing spaces from string values

When this option is selected (which is the default), AQT removes spaces from the end of string values. De-select this option if you wish to retain these spaces.

This option is used when displaying data, plus the following AQT features:

• Data Export. This option governs whether trailing spaces are included when data is export
• Data Loader. This option governs whether trailing spaces are included when data is loaded from one table to another
• Data Compare. This option governs whether trailing spaces are included in the compare of values between tables.

For DB2/400 use Column Headers

When this option is selected and you are displaying a DB2/400 physical / logical, AQT will use the Column Headers (rather than the Column Name) when displaying the table contents.

For Oracle, use TO_CHAR with Timestamp and Interval columns

Most versions of the Oracle ODBC Driver do not handle Timestamp or Interval columns. When you try to display these, the ODBC Driver, and AQT, will crash. AQT has a work-around for this problem; when you display a table with columns of these types, and you have this option selected, AQT will enclose the timestamp/interval columns in a TO_CHAR function.

By default, this option is selected. De-select this option if you have a recent version of the Oracle ODBC Driver that can display these data types without problem/