During this presentation, we explain and demonstrate:

• when and how to use the PREV (previous), *COUNT, *COUNTN, and *SKIP functions to calculate running totals, count rows, and reset row counts at different report breaks
• how to skip rows when specific conditions are met
• how to develop a query to return accurate values when the rows in two Db2 on i tables have a "one-to-many" relationship

The sample queries used to illustrate these functions are shown in both the graphical IQ Client and 5250 host interfaces. Approximately 60 minutes.

Returning Customers

If you have already registered for a previous Webcast, enter your e-mail address and click the "Returning" button to submit the form below. You will receive an e-mail with a link to the requested Webcast.

Otherwise, continue to the next section to request login instructions.

First Time Request

To request access to the Webcast recording, please fill out the form below and click the "New" button to submit the form. You will receive an e-mail with a link to the requested Webcast.