Contact | Privacy Policy
 
 
Sponsors & Special Offers
News Headlines
October 20, 2017
SAVE THE DATE! Join us in Dallas, March 20-22, 2018 for the next Summit!
October 20, 2017
Fun photos from the October 2017 RPG & DB2 Summit
August 30, 2017
CIO Summit Planned For IBM i Executives
June 12, 2017
Next RPG & DB2 Summit highlights DB2 for i, Watson's Web Services & Open Source
February 6, 2017
IBM honors Gantner, Paris & Tuohy as 2017 IBM Champions.
December 5, 2016
Summit attendees see tangible results of their education

DB2-Oriented Sessions

I Didn't Know You Could Do That Using SQL

You have started to master SQL but you have a sneaky suspicion that there might be more to it.

In this session you will learn valuable and time saving techniques with SQL that let you avoid writing code. You will learn how to use SQL Subquery or Subselect in an SQL SELECT, INSERT, UPDATE, DELETE or CREATE TABLE statement to reference multiple tables without having to do a join of the tables involved. You will see how to use CASE and UNION statements, Common Table Expressions (CTEs) and where to use Full Outer Join and Hidden Time Stamp columns.

This session is based on the SQL function available in V5R4, V6R1, and V7R1 of OS/400 or i5/OS, assumes you have a basic understanding of relational database concepts and SQL.

Speaker: Skip Marchesani

What's New in DB2 for i?

In this session come and see what new DB2 for i features and functions can help your business applications move forward. The latest 7.2 and TR announcements included many exciting new features.

You will learn how to enhance data security through access rules and masking techniques, extend legacy application code by modernizing DB2 for i usage, and improve productivity of developers with powerful SQL enhancements.

Speaker: Kent Milligan

DB2 for i XML Integration

In this session we will take a deeper dive into the new DB2 for i integrated support for storing, retrieving and manipulating XML. The session will include scenarios and examples of using the new XML data type to store a document as well as the new functions and procedures to understand and work with the XML information.

Speaker: Kent Milligan

SQL Procedures, Functions and Triggers

While many developers know how to use SQL to query and process data, many are not aware that they can use SQL as a procedural langauge for programming business logic. In this session, we will explore the capabilities of the SQL procedural language and its usage in data-centric programming with SQL procedures, functions, and triggers.

Speaker: Paul Tuohy

DB Modernization Strategies and Methods — Objects

When the System/38 was introduced In 1978 DDS, or Data Description Specifications, was the tool provided for defining the database objects used for storing data within the integrated relational database. The Structured English Query Language or SEQUEL document had just been published 4 years prior and was still in it’s infancy. Ten years later IBM morphed the System/38 into the AS/400 and added SQL/400 as an alternative to defining the database objects based on the increased acceptance of the SQL standard. Today SQL DDL or Data Definition Language is the industry standard for defining and accessing database objects. In this session we will discuss how DDL is used to define the database objects for DB2 for i, the current version of IBM’s integrated relational database product. We will include comparisons between DDL and DDS.

Speaker: Kent Milligan

DB Modernization Strategies and Methods — Programming and Access

DB2 for i , IBM’s Premier relational database product for POWER based systems (just seeing if you’re awake) has the unique capability of allowing both SQL (set at a time) and RLA (traditional record at a time IO) to access database objects. This distinction allows legacy applications using traditional IO methods to coexist with modern applications using data centric development techniques (i.e. SQL DDL and DML). In this session we will compare SQL to RLA and where the strengths of each can be exploited.

Speaker: Kent Milligan

DW and BI Architecture, Design and Implementation

Are you struggling with the concepts of “business intelligence” and “data warehouse”? Confused by the terms “data mart”, “OLAP” and “ETL”? Don’t know where to start with query and reporting? In this session, we will layout the BI landscape and explore the steps and methodology to designing and building an information system to support analytical queries.

Speaker: Robert Bestgen

Modernize RPG & Query/400 Reports with DB2 Web Query

IBM DB2 Web Query for i is IBM's strategic replacement for the Query/400 product. But it is much more than just a replacement. It is a robust, extensible, and productive reporting solution which leverages the latest reporting and graphing development tools. Plus it takes advantage of the latest performance capabilities available in DB2 for i.

  • Would you like your report output sent to a PDF file or Microsoft Excel?
  • Would you like to see your existing reports formatted as graphs and charts?
  • How about sending interactive reports to your smartphone?

And with the just released version 2.1, there's even more exciting capabilities to talk about.

This session will include examples of various DB2 Web Query reports, graphs and dashboards.

Speaker: Robert Bestgen

Take Your SQL to the Next Level

SQL is a very powerful language for accessing and manipulating data. Embedding SELECTs within an SQL request not only allows your statement to perform more powerful data transformations, but also can significantly improve performance and scalability.

In this session, you will learn how to leverage Views, Subqueries, Common Table Expressions, and Derived Tables to boost your productivity and performance. If these SQL terms confuse you, attend this session to get things cleared up!

Speaker: Kent Milligan

Database Modeling Concepts and Best Practices

A data model is a conceptual representation of data structures required for a database and is used to express and communicate business elements and their relationships. In this session we will explore the science and art of data modeling, including logical models, physical models, and special models such as stars and snowflakes. Good SQL performance is based in part on a good database design. A good database design is based on good data modeling.

Speaker: Robert Bestgen

Exploring the IBM OmniFind Text Search Server

In this session, we explore the newest indexing technology for DB2 for i — the IBM OmniFind Text Search Server. Come and learn how your applications can perform advanced, linguistic text and “fuzzy” searches on plain text fields as well as searches against rich text documents in formats such as Microsoft Word and Adobe PDF.

By the end of the session, attendees will be able to:

  1. Understand the differences between a traditional DB2 index and a Text Search Index
  2. Be able create a text search index and perform searches utilizing SQL

Speaker: Robert Bestgen

Introduction to SQL Query Optimization

The integrated, self learning and adaptive DB2 for i Query optimizer is second to none when producing SQL query plans. Moving at the speed of light this statistical processing powerhouse quickly transforms the most complex of queries into the most efficient set of database engine instructions. Understanding how the DB2 for i SQL Query Optimizer decides to implement your query can go a long way when proactively and/or reactively tuning queries. In this session we will cover the environmental and database statistical data gathered by the Optimizer and how this information guides the optimizer when producing a query plan.

Speaker: Robert Bestgen

SQL Monitoring, Analysis and Tuning Tools

If you are running applications that use SQL to access DB2 for i, the ability to identify and resolve performance issues is a critical skill. In this session, we will review the technology and tools for monitoring, analyzing and tuning DB2 for I SQL requests. We will also walk through scenarios to illuminate the methods and strategies for analyzing common SQL performance problems.

Speaker: Robert Bestgen

Indexing Strategy and Advice

On any platform, good SQL performance depends on good design. And good design includes a solid understanding of indexes: how many to build, their structure and complexity, and their maintenance requirements. This is also true for DB2 for i, which provides a robust set of choices for indexing and accessing tables. In this session, you will:

  1. Understand why indexes are important to the query optimizer.
  2. Be able to determine what columns in a table are the best candidates for new indexes.
  3. Understand what types of indexes (binary radix or encoded vector) should be created and how they will benefit queries.
  4. Understand what new tools are available to analyze your indexing strategy.

Speaker: Robert Bestgen

SQL Performance Basics

If you are thinking about using or have used SQL, this session will provide important information on DB2 behavior and sound advice on best practices for performance. This session covers concepts that apply to any SQL interface (embedded SQL in high level languages, JDBC, ODBC, .NET). Major areas include:

  1. The relationship between query plans, open data paths (ODPs), and reusable ODPs
  2. Achieving optimal DB performance and throughput
  3. Tips on how to code high-performing SQL applications.

Speaker: Kent Milligan

DB2 for i Update - 6.1

With all of the focus on the latest DB2 for i 7.1 release, it's easy to overlook all of the great features that are available in the 6.1 release to speed up database performance and application development. Programmers can simplify their development tasks with the Cube & Rollup additions to SQL for analytical processing along with new syntax for Hidden and Row Change Timestamp columns. Both database and application performance will benefit from the new SQL Derived Indexes capability and the enhanced DB2 performance tooling in System i Navigator as well as the Client Register support.

Speaker: Kent Milligan

Embedding SQL in RPG Programs: The Basics

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

Speaker: Paul Tuohy

Embedded SQL in RPG - Beyond the Basics

You have been using embedded SQL in RPG. You have mastered the syntax, tried a few selects, declared a cursor, performed an update - you may even have tried some dynamic SQL!

Time to take it to the next stage and see what you can do with embedded SQL - beyond the basics

Topics covered in this session include:-

  • Discussion of the key points in writing powerful embedded SQL
  • What tools should you use to write and test SQL prior to embedding it?
  • Controlling CRTSQLRPGI
  • SQLCA and SQLCODE considerations
  • Getting data without SELECT - GET DIAGNOSTICS and VALUES INTO
  • Talking to Watson with Embedded SQL SQL
  • Mastering Multi Row Fetch
  • Handling NULL
  • Dates, Times and Timestamps

Prerequisite: This session assumes you are familiar with the topics covered in Embedded SQL - the Basics

Speaker: Paul Tuohy

Home | Conferences | About Us | System i Community | Privacy Policy | Legal Notices | Email Webmaster | Contact
System i Developer,LLC © 2014