Custom Search
Home > Computer > Interskill Learning > iSeries Curriculum > 5.2 iSeries Query400 Construction and Management
Provided by: Interskill Learning

5.2 iSeries Query400 Construction and Management

IBM Systems

 Interskill Learning
Training Provided by Interskill Learning This is course 1 of 2 in the iSeries Query Series. The course is delivered via e-Learning. It can be accessed online, at any time, place or location with internet access, or delivered through your own internal LMS (if applicable). The course is available as part of the iSeries Query Series, or in a Mainframe Bundle, comprising of the 100 most popular mainframe e-Learning titles.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Interskill Learning for more information
Course Level:introductory
Duration:5 hours
Training Presented in:English
Click here for more information or to take this course
5.2 iSeries Query400 Construction and Management

Duration

3 to 5 hours

Overview

Audience

Personnel requiring an intermediate knowledge to create reports with the Query facility.

Prerequisites

Completion of the iSeries Query/ 400 Introduction and Fundamentals course and knowledge of iSeries concepts.

Objectives

After completing this course, the student will be able to identify how to:
• Create queries using most of the Query features
• Display Query reports from a Spool File
• Change, copy, delete, display, and print existing Queries
• Use Data File Utility (DFU) with Query/ 400
• Use some tips and techniques with Query/ 400

Course Content

iSeries Query/ 400: Construction and Management Pretest

Creating Advanced Queries

Construction of a Query to Produce a List of Company Products
Define the Query
Define Result Fields
Select and Sequence Fields
Select Sort Fields
Specify Report Column Heading
Select Report Summary Functions
Define Report Breaks
Format Report Breaks
Select Output Type and Output Form

Viewing a Query from a Spool File

Work with Query Spooled Files

Managing Queries

Work with Queries Screens
Creating a Query
Changing an Existing Query
Copying an Existing Query
Deleting a Query
Displaying a Query
Printing a Query Definition
Five Methods of Running a Query
Working with Multiple Queries at the Same Time

Using the Data File Utility with Queries

Data File Utility
Add, Change, Delete Records in a Database
Data Description Source

Tips on Using Queries

iSeries Query/ 400: Construction and Management Mastery Test

About The Training Provider: Interskill Learning
Interskill Learning - Interskill Learning is a worldwide leader in the provision of e-learning, delivering reliable, quality learning solutions since 1991 to over 1500 organisations. With 1000s of titles to chose from in mainframe, desktop, IT and business subject areas, Interskill offers a comprehensive training solution for your entire workforce, regardless of their department, location or language. With three...
Click here for more information or to take this course
Home > Computer > Interskill Learning > iSeries Curriculum > 5.2 iSeries Query400 Construction and Management
Advertise With Us
Sell iseries training?
tcw11-gfc-v396M-10/25/09-11:18:43-()[A]-[A]-[A] -04:37:16