Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Power Systems Curriculum » IBM i Query Series

Creating a Simple Query

Duration
6 hours

Overview

Description

The Creating a Simple Query course begins by describing how database files are joined, enabling IBM Query for i to more easily reference data. This is followed by the identification of data that will be required by IBM Query for i and the subsequent coding required to extract that information. Details on options used to save the query and print, or display, the resulting report are also covered.

Audience

Personnel requiring knowledge about creating reports with the IBM Query for i facility.

Prerequisites

Completion of the Datatrain Database Basics and the Need for Query course, or equivalent knowledge.

Objectives

After completing this course the student should be able to:

  • Describe the importance of joining files when creating a query
  • Identify the steps used to create a simple query
  • Define output options for print and spool queries
  • Display query reports that reside on spool

Course Content

Joining Files

Handling Multiple Database Files

Linking Related Information

Join Operation Process

Primary and Secondary Files

Query Creation Basics

Signing On and Accessing IBM Query for i

Query Utilities Menu

Creating a New Query

Specifying Database Files to be Used

Specifying Report Column Formatting

Output Options and Saving Your Query

Query Output Options

Detailed and Summary Formats

Line Wrapping

Formatting Reports for the Printer and Spool

Cover Page, Headers, and Footers

Saving and Running your Query

Viewing a Query from a Spool File

Invoking the WRKSPLF Command

Work With All Spool Files Screen

Displaying Spool File Content

Creating a Simple Query Mastery Test

Course Catalog » Power Systems Curriculum » IBM i Query Series
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM