IBM DB2 Web Query Function Assist User Guide

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.


IBM DB2 Web Query Function Assist User Guide - cover page
Brand
IBM
Category
Other
Document type
User Manual
Language
English
Pages
14
File format
PDF
File size
576 KB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
CC1A3989113F20BBA87DF7F7BA40A673

About this manual

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.

What's inside

  • Using Function Assist
  • Creating Define Fields
  • Accessing Function Help
  • Using DATEADD Function
  • Using SUBSTR Function
  • Synonym Editor
  • DB2 Web Query Developer Workbench

Frequently asked questions

What is the difference between a Define and a Computed field?

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.

What does Function Assist help you do when defining a function in the Synonym Editor?

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.

What must you create in a synonym to use DB2 Web Query built-in functions?

You must create either a Define field or a Computed field in your synonym.

How does a Computed column’s expression differ from a Define column’s expression?

A Computed column’s expression is executed for each row from the grouped or aggregated result set after aggregation has been performed.

Download PDF (576 KB)

More IBM Manuals


View all IBM manuals →