Get Cooking with DB2 Web Query for IBM i
Presenter: Rick Flagler
Explore DB2 Web Query's more advanced functions.
What You Need to Know about DB2 Web Query for IBM i
Presenter: Rick Flagler
DB2 Web Query is IBM's strategic replacement for the Query/400 product that offers a robust and powerful alternative to its predecessor. The latest 1.1.2 version of DB2 Web Query contains many improvements to the product, from function to performance.
Come to this session to learn about these exciting enhancements, including InfoAssist, the sleek new development tool. In addition, the session will cover several tips, techniques, and best practices that you should be aware of when using Web Query to make the overall DB2 Web Query experience more enjoyable for developers and end users alike.
Embedding SQL in RPG Programs - The Basics
Presenter: Susan Gantner
Many RPG programmers have used interactive SQL as a tool to quickly browse data or to create test data scenarios, but have stopped short of embedding it into their RPG programs. Come to this session to learn why, when and how you may want to use SQL in conjunction with RPG.
We will cover the basics of embedding SQL into RPG, including using SQL cursors and a few tips on getting good performance from your SQL applications.
Prerequisite: This session assumes you are familiar with the basics of the SQL language, such as the SQL SELECT and UPDATE statements.
Embedding SQL into RPG - Beyond the Basics
Presenter: Susan Gantner
In this session, we'll move beyond the basics of embedding SQL, using SQL cursors and return codes for condition handling. Here we'll look at topics such as using the SET OPTION statement to control special SQL compile options, multi-row fetch and insert and dealing with Nulls as well as date, time and timestamp fields.
This session assumes attendance at "Embedding SQL into RPG - The Basics" or equivalent knowledge.
DB2 Web Query Integrated Analytical Features
Mobile access to Web Query is a hot topic these days. Now that you have conquered basic reports and graphs, this session will take you through some of the more advanced analytical features of Web Query using InfoAssist.
Turning on Auto Drill takes a very simple report and turns it into an analysis application allowing users to analyze, chart, slice and dice and drill down into their data with ease.
Active Reports are a great solution for users who wish to continue analyzing their data connected or disconnected from their IBM i.
In the session we will use InfoAssist and create an Active Dashboard and then work with it on our mobile device. Mobile access to Web Query is very exciting and when you combine Mobile and Active Technologies you have a leading edge BI solution at your fingertips.
DB2 Web Query Tips, Techniques and Performance
Get expert advice to improve your use of DB2 Web Query for i including tips for using InfoAssist, working with metadata, and keys to performance.
Learn how to create business views for your users, how to have each sales rep or branch manager see only their data.
Have you ever created global filters to make life easier? You will learn how in this session.
Look under the hood of Web Query and find out what is really happening when you run a report as well as how to avoid common pitfalls that cause your reports to run more slowly.
DB2 Web Query Integrated Analytical Features
Presenter: Jackie Jansen
Mobile access to Web Query is a hot topic these days. Now that you have conquered basic reports and graphs, this session will take you through some of the more advanced analytical features of Web Query using InfoAssist.
Turning on Auto Drill takes a very simple report and turns it into an analysis application allowing users to analyze, chart, slice and dice and drill down into their data with ease.
Active Reports are a great solution for users who wish to continue analyzing their data connected or disconnected from their IBM i.
In the session we will use InfoAssist and create an Active Dashboard and then work with it on our mobile device. Mobile access to Web Query is very exciting and when you combine Mobile and Active Technologies you have a leading edge BI solution at your fingertips.
DB2 Web Query Tips, Techniques and Performance
Presenter: Jackie Jansen
Get expert advice to improve your use of DB2 Web Query for i including tips for using InfoAssist, working with metadata, and keys to performance.
Learn how to create business views for your users, how to have each sales rep or branch manager see only their data.
Have you ever created global filters to make life easier? You will learn how in this session.
Look under the hood of Web Query and find out what is really happening when you run a report as well as how to avoid common pitfalls that cause your reports to run more slowly.
Introduction to MySQL for IBM i (Beginner)
Presenter: Mike Pavlak
Zend and IBM have teamed up once to answer the call of the open source community by developing Zend DBi. Zend DBi is the standard distribution of MySQL for IBM i and is available at no charge from the Zend website.
This session explores how to install Zend DBi and the IBM DB2 Storage Engine. MySQL command line functions via PASE will be reviewed as will administering MySQL via the GUI shipped with Zend Server called phpMyAdmin. History and practical examples will round out the presentation with a live demonstration of the DB2 Storage Engine.
Advanced SQL Topics
Presenter: Linda Swan
SQL is a very powerful language for accessing and manipulating data. In this session we will explore some of the more advanced SQL concepts and their uses in "set at a time" processing. The list includes VIEWS, sub queries, common table expressions and more.
DB2 for i and XML with OmniFind Search
Presenter: Linda Swan
DB2 for i 7.1 now supports XML as a column type. This session introduces XML and describes all of the support for storing, accessing and processing XML data stored within DB2 for i. It also describes the use of Omnifind as the text search engine for XML data.
DB2 for i Indexing Strategy
Presenter: Linda Swan
DB2 for i provides a robust set of choices for indexing and allows indexes and statistics to play a key role in several aspects of query optimization.
In this session, you will:
-
Be introduced to the DB2 for i statistics manager and its automatic collection facilities.
-
Understand what indexes are important to the query optimizer for statistics.
-
Be able to determine what columns in a table are the best candidates for new indexes.
-
Understand what types of indexes (binary radix or encoded vector) you should be creating and how they will benefit the queries.
-
Understand how to proactively and reactively leverage database statistics to get the best SQL performance.
-
Understand what tools are available to analyze your indexing strategy.
-
See the new IBM i 7.1 SQL Index capabilities.
DB2 for i Performance - Utilizing DB2 for i More Efficiently
Presenter: Linda Swan
Why should you care about DB2 for i performance? How do you know if it's a problem? What should you do about it?
In this session we'll talk about the common DB performance problems we see on customer systems and discuss why its important to address them. We'll outline a strategy to monitor, analyze and tune your database access. You'll leave armed with some key analysis tasks to get you started.
Introduction to Query Optimization
Presenter: Linda Swan
What is the distinction between Science and Art, and how does it apply to query optimization? This session will define query optimization and will introduce you to the building blocks and the strategies that help to define the science and art of query optimization.
What's New in DB2 for i
Presenter: Linda Swan
Come and find out how the newest DB2 for i features can help your IBM i databases and applications take a giant leap forward. You will learn how these new DB2 for i features such as XML support, Global Variables, and Array Support in Routines can be used.
