Zoom Outline PDF View  or  Email  


iSeries 400 Query




AUDIENCE:   All iSeries/i5 users needing to extract information from the database for enquiries, report production, mailshots etc.

DURATION:   1 day. Hands on.

OBJECTIVES:   Upon completion, delegates will be able to:

  • Understand all stages in the definition of a query.
  • Define simple queries.
  • Work out complex queries of the delegates own design using their data,
    giving examples relevant to their work environment.
  • Appreciate the uses and full potential of Query.

COURSE CONTENT:  

Getting Started
Definitions
Function keys
Specify File selections
Select and Sequence fields
Select Records
Select report summary functions
Select output type and output form
Exit this query
Exercise

Getting Clever
Selecting the options
Define result fields
Select records
Select sort fields
Specify report column formatting
Define report breaks

Getting Technical
Query so far
Joining files
Define result fields
Select records
Select collating sequence
Specify report column formatting
Select output type and output form
Specify processing options
Exercise

Managing Queries
Libraries
Deleting a query definition
Copying a query definition
Printing a query definition
Running a query
Queries behind menus
Queries without definitions
Other query options
Queries behind menus
Where has my query gone?
Technical information

Exercises  

© 2007 Verhoef Training

Schedule Dates

Course offered as
Inhouse or Public


There are no classes scheduled for this subject at this time.

Send us a request for this class

or

contact your account manager for scheduling information.

Contact Us


Copyright © 2007 - Verhoef Group of Companies - All Rights Reserved