System i (AS/400, iSeries, i5) Basic Query

Course Details:

Course code: ISQRY View/Download data sheet (PDF)
Duration: 1 Day Book Course
Price: £385 Return to Courses

Course Outline:

This course is intended for end users and support staff who need to create, modify and run query reports. The course covers the basics of creating new query definitions and modifying existing queries. It takes users step by step through the options to create and run a query in easy to understand terms. The course is very much hands on and delegates have plenty of opportunity to get to grips with the fundamentals of writing queries

Pre-requisites:

There are no prerequisites for this course but delegates should have basic keyboard skills.

Course content:

• Introduction to query
• Explain Query and database file terminology
• How Queries process in batch and interactive environments
• Use of function keys within Query
• Starting Query
• Exit, Save and Run a Query definition
• Examples of storing Queries in libraries
• How to select the file and library that you wish to report on
• How to select and sequence the fields required in the report
• How to select which records you require in the report
• Detail the different record tests
• Examples of the different record tests
• Using the And and Or options when selecting records
• How to sort the list of records into a logical sequence
• How to define report breaks
• Defining sub totals and final totals
• How to hide sub totals or final totals
• Output a Query to print
• Format the printed output
• Selecting detail and summary output
• Selecting report column formatting
• Formatting numeric and date fields
• How to reduce column heading lengths
• How to change existing Queries
• Query design checklist
• Manipulate printed output using the WRKSPLF command

Follow on Courses:

We recommend that after a suitable period of time of attending this course (e.g. 3 to 6 months hands on experience) then delegates may want to enhance the knowledge they have gained by attending the Advanced Query course (ISQRA).

Schedule:       

  2017       2018              
Public schedule Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Northampton       7    23         5  
We can run this course at our location or on your site – Please contact us for details

 

Schedule:

2017/2018  
Sep  
Oct  
Nov  
Dec 7
Jan  
Feb 23
Mar  
Apr  
May  
Jun  
Jul 5
Aug  
We can run this course at our location or on your site – Please contact us for details

Book course:

ISQRY Basic Query booking form
Please double check this!
Press 'Submit' below to send your reservation to Sierra. We will confirm the booking in due course. Thank you.
Sending