ibm db2 web query for system i. db2 web query for system i open windows internet explorer, type in...
TRANSCRIPT
IBM DB2 IBM DB2 Web Query Web Query for System for System
ii
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
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
DB2 Web Query for System i Examples of web queries
A G V A N T A G E
Summary
DB2 Web Query for System i Change output
A G V A N T A G E
DB2 Web Query for System i On-demand paging
A G V A N T A G E
DB2 Web Query for System i Add Conditional Styling
A G V A N T A G E
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
DB2 Web Query for System i Prompt byenteringa value
A G V A N T A G E
DB2 Web Query for System i
A G V A N T A G E
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
DB2 Web Query for System i Active Reports options
A G V A N T A G E
DB2 Web Query for System i Graph Assistant
A G V A N T A G E
DB2 Web Query for System i
A G V A N T A G E
DB2 Web Query for System i
A G V A N T A G E
DB2 Web Query for System i Online analytical processing - OLAP
A G V A N T A G E
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
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
Let’s get startedRight click on Sales & select Report Assistant
A G V A N T A G E
Select the largest or primary file
A G V A N T A G E
Join Department file
A G V A N T A G E
Create field to turn amount sign
A G V A N T A G E
DB2 Web Query for System i Formula for turning amount sign
A G V A N T A G E
DB2 Web Query for System i Select Records
A G V A N T A G E
DB2 Web Query for System i Report headings and footings
A G V A N T A G E
DB2 Web Query for System i Select Report output
A G V A N T A G E
Questions
Let’sTalk!
A G V A N T A G E
Check our On-lineTraining at www.agvantage.com
IBM DB2 Web Query
ThanksforAttending
A G V A N T A G E