Check our upcoming TUG Events …and     

Wednesday, 19th September, 2018 Meeting of Members.

LOCATION:   Sandman Signature Mississauga Hotel
5400 Dixie Road

ADMISSION:   Free to all TUG members  ($60 non-members) 


Ted Holt (Profound Logic)

Ted Holt
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


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.

    Topics include:
    1. The necessity of UNION ALL
    2. Extensions to GROUP BY
    3. How to "roll" totals by hand and when you should do so
    4. 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

    Wednesday, November 21 / 28, 2018 Meeting of Members.
    LOCATION:     SAVOY Conference Centre (Monte Carlo Inn) 7255 Warden Avenue in Markham  
    ADMISSION:   Free to all TUG members  ($60 non-members) 
    Wednesday, January 23, 2019 Meeting of Members.
    LOCATION:     Sandman Signature Mississauga Hotel, 5400 Dixie Road, Mississauga   
    ADMISSION:   Free to all TUG members  ($60 non-members)