![Page 1: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/1.jpg)
IBM DB2 IBM DB2 Web Query Web Query for System for System
ii
![Page 2: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/2.jpg)
DB2 Web Query for System i
• Open Windows Internet Explorer, type in the address bar the following with your system name and domain
• http://mysystemname.iseries.domain.com:11331/webquery/i5-login
• Save as a favorite or icon on your desktop
A G V A N T A G E
![Page 3: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/3.jpg)
DB2 Web Query for System i • Enter your System I User ID and password.
• Organize queries with folders similar to Windows folders
A G V A N T A G E
![Page 4: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/4.jpg)
DB2 Web Query for System i Examples of web queries
A G V A N T A G E
Summary
![Page 5: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/5.jpg)
DB2 Web Query for System i Change output
A G V A N T A G E
![Page 6: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/6.jpg)
DB2 Web Query for System i On-demand paging
A G V A N T A G E
![Page 7: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/7.jpg)
DB2 Web Query for System i Add Conditional Styling
A G V A N T A G E
![Page 8: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/8.jpg)
DB2 Web Query for System i Create a dropdown selection box
A G V A N T A G E
Hold control key to select multiples
![Page 9: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/9.jpg)
DB2 Web Query for System i Prompt byenteringa value
A G V A N T A G E
![Page 10: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/10.jpg)
DB2 Web Query for System i
A G V A N T A G E
![Page 11: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/11.jpg)
DB2 Web Query for System i Active Reports lets user change the view without
the author changing the query
A G V A N T A G E
![Page 12: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/12.jpg)
DB2 Web Query for System i Active Reports options
A G V A N T A G E
![Page 13: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/13.jpg)
DB2 Web Query for System i Graph Assistant
A G V A N T A G E
![Page 14: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/14.jpg)
DB2 Web Query for System i
A G V A N T A G E
![Page 15: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/15.jpg)
DB2 Web Query for System i
A G V A N T A G E
![Page 16: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/16.jpg)
DB2 Web Query for System i Online analytical processing - OLAP
A G V A N T A G E
![Page 17: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/17.jpg)
DB2 Web Query for System i Allows slicing and dicing of data in an almost unlimited number of ways
A G V A N T A G E
![Page 18: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/18.jpg)
DB2 Web Query for System i
and . . . more . . . More . . . More . . . A G V A N T A G E
• Change fonts and colors• Send query to MS Excel• Send query to MS Excel with formulas included• Query within a query• Developer Workbench• Power Painter
![Page 19: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/19.jpg)
Let’s get startedRight click on Sales & select Report Assistant
A G V A N T A G E
![Page 20: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/20.jpg)
Select the largest or primary file
A G V A N T A G E
![Page 21: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/21.jpg)
Join Department file
A G V A N T A G E
![Page 22: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/22.jpg)
Create field to turn amount sign
A G V A N T A G E
![Page 23: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/23.jpg)
DB2 Web Query for System i Formula for turning amount sign
A G V A N T A G E
![Page 24: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/24.jpg)
DB2 Web Query for System i Select Records
A G V A N T A G E
![Page 25: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/25.jpg)
DB2 Web Query for System i Report headings and footings
A G V A N T A G E
![Page 26: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/26.jpg)
DB2 Web Query for System i Select Report output
A G V A N T A G E
![Page 27: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/27.jpg)
Questions
Let’sTalk!
A G V A N T A G E
Check our On-lineTraining at www.agvantage.com
![Page 28: IBM DB2 Web Query for System i. DB2 Web Query for System i Open Windows Internet Explorer, type in the address bar the following with your system name](https://reader036.vdocuments.us/reader036/viewer/2022081506/5697bf851a28abf838c876f8/html5/thumbnails/28.jpg)
IBM DB2 Web Query
ThanksforAttending
A G V A N T A G E