Start Time: Reg. 8:00am
All Day Education with
Imbedding SQL into other programming languages
SQL is the industry standard way of accessing and manipulating data. However, it is not restricted to a purely SQL environment. One of its original, and still very popular, uses is being imbedding in other languages like RPG, COBOL and C. In this session we investigate SQL's usage within a high level language. Discussion will include syntax and examples. Just as important, the session will also introduce data-centric programming and the proper use of SQL; it is more than just replacing native opens and reads with SQL equivalents.
XML and DB2 for IBM i
XML is a very popular, standardized way to interchange data. Most businesses have to deal with it in one way or another. DB2 for i is a premiere database for storing, accessing and handling data. In V7R1 DB2 for i added built in support for processing, storing, generating and even searching XML. In this session we will discuss this support and how to utilize it in your environments. Topics will include: the XML datatype, importing XML data, XML validation, storage and retrieval, generating XML from existing data and searching XML. Also included will be discussions on practical considerations for managing and using XML data.
SQL Stored Procedures and Functions
Support for SQL Procedural Language (SQL PL) in IBM i has become instrumental in application modernization and porting projects. The procedural language can be brought to bear in many different aspects of database processing. In this session, we provide an overview of the SQL procedural language and describe the major areas in which it can be used: procedures, functions and triggers. This session will also highlight recent advancements in SQL PL as well as performance tips.
Advanced SQL Topics
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 derived tables, Grouping Sets and Recursive Common Table Expressions, OLAP functions and more. Bring your SQL environment into a whole new light.
Rob Bestgen is a lead architect working in the heart of the IBM i development lab in Rochester, MN. As chief architect of the DB2 SQL Query Engine (SQE) for DB2 for i, he has directed the team in providing SQE's numerous industry leading capabilities. Rob is also product manager for DB2 Web Query for i, the popular IBM i product for query reporting and analytics. Previously he was also the systems management architect for IBM i. Rob is a proud member of the DB2 for i Center of Excellence team, helping customers utilize the amazing capabilities of DB2 i and IBM i. He is a frequent presenter at customer briefings and customer conferences both domestically and internationally.