Showcase Advanced Query | HelpSystems

Showcase Advanced Query

For Showcase 9: This class begins with a discussion of the Showcase environment and the connectivity required for accessing a database on the iSeries (AS/400).  Defining expressions and building complex conditions with SQL are discussed. Extensive time is spent using the Query add-ins with Microsoft Excel. The student will learn how to work with Structured Query Language (SQL) to create Subselects and Unions. The use of dates and data storage of dates is discussed, as well as how to use the various options provided for running queries.  Lab exercises are included to reinforce the learning.

Who Should Attend

This class is intended for experienced users of Query and Report Writer who want to use more advanced functions for creating reports.


The student must have completed the Query for End Users class or the Report Writer for End Users class, or must have equivalent experience with Query or Report Writer.  A thorough understanding of Microsoft Windows is required.  Some experience with Microsoft Excel is recommended.

What to Expect

  • Query and the Showcase Environment
  • Connectivity
  • The Query Application
  • Expressions and SQL Functions
  • Data Wrappers
  • Subselect Statement and Union Operation
  • Working with Other Windows Applications
  • Interactive and Batch Processing


  (Select "Other" if outside U.S. or Canada)
Select "Query Basics" Date:

Please indicate if billing information is different from registrant information. This is not a secure form. Do not enter credit card information. Classes that do not generate sufficient enrollment are subject to cancellation. Wait to receive the confirmation that the class is being held before you make travel arrangements.

Available On Demand
$4,500 plus instructor expenses (up to 12 students, additional cost for more students)
2 Days