DB2 Web Query is loaded with built-in functions to help you transform your raw DB2 for i data into something more meaningful and useful for use in your reports, graphs, dashboards, and compound documents.
This guide explains how to use Function Assist, a helpful feature in the DB2 Web Query Developer Workbench tool. It shows how to access and use the Synonym Editor to create Define fields with built-in functions like DATEADD. The guide walks through selecting functions, using the Find feature, and accessing help text and examples for correct syntax and parameter values.
Function Assist provides dropdowns for parameter values and detailed help for each function, making it easier to build expressions for reports, dashboards, and compound documents without prior experience with DB2 Web Query functions.
A Define column’s expression is executed for every row in the result set, while a Computed column’s expression is executed only after aggregation has been performed.
It helps you decide what values to specify for each of the function’s parameters. If a parameter is limited to a set of values, Function Assist presents a drop-down list for that parameter.
You must create either a Define field or a Computed field in your synonym.
A Computed column’s expression is executed for each row from the grouped or aggregated result set after aggregation has been performed.