Ted Holt is a Senior Software Developer with Profound Logic Software, a provider of modernization solutions for the IBM i world.
He has worked within the information technology industry since 1981, primarily with IBM midrange computers. His industry experience includes the fields of manufacturing, healthcare, education, retail, and wholesale.
He holds a master's degree in computer science from the University of Southern Mississippi and has taught in community colleges, universities, and vocational/technical schools.
Ted is the author of several books on programming topics, including OpenQuery File Magic!, Complete CL, Power CL, Qshell for iSeries and the MC Press Encyclopedia of Tips, Techniques, and Programming Practices for iSeries and AS/400.
He is a regular speaker for the RPG and DB2 Summit and serves as technical editor and writer for The Four Hundred, a newsletter published by itjungle.com.
4:00 Sign up & Greeting
5:00 Session 1: SQL Aggregation without Aggravation
Abstract: SQL Aggregation without Aggravation
SQL provides powerful ways to retrieve detailed data and format it the way users need to see it.
SQL can summarize data, giving users the information they need to make informed decisions. But what do you do if the user asks for both detailed and summary information in the same query?
You attend this session. Ted Holt has successfully dealt with this struggle.
In this presentation, he shares techniques you can use to combine details and summaries to satisfy the needs of those whose jobs depend on your system.
- The necessity of UNION ALL
- Extensions to GROUP BY
- How to "roll" totals by hand and when you should do so
- How to count. (Yes, you read that correctly.)
6:00 Intermission (Buffet Dinner & Networking)
7:00 Session 2: The SQL Procedures Language in a Nutshell
It seems a new programming language sprouts up every week, and each one has its share of evangelists, telling you to learn their language next. Maybe your next language should be one that was designed for databases and is already on your system.
The SQL Procedures Language is a database-oriented programming language that offers several benefits to IBM i professionals.
● SQL PL is an easy and powerful interface to the database.
● SQL PL is ideal for data-centric information systems.
● SQL PL builds functions, triggers, stored procedures, and dynamic compound statements.
● SQL PL runs on all DB2 platforms, not just DB2 for i.
In this session, Ted Holt presents an overview of SQL PL. You will get a tour of the syntax of the language and learn how to put it to work on your system.
8:45 Wrap Up and Door Prize draw