Build Query Column

Use this Window to build or modify an individual Query Column. You open this window by clicking on NEW or MOD in the GUI Columns tab.

Summary Query

If you are building a Summary Query, the Function list will just be the aggregate functions (sum, avg, min, max).

Specifying a Query Columns as a Literal or System Variable

You can specify a literal, expression or system variable, by checking the Query Column is a literal box.

You can also use this method for specifying a sub-select or case statement. For large expressions such as these,click on the >>> for a larger box.

AQT provides no assistance for building a sub-select or case, though this may be done in a later release.