
|
| 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
|
|
|
|
Copyright © 2007 - Verhoef Group of Companies - All Rights Reserved
|