GASI EDUCATION CENTER

SYLLABUS

“iSeries (AS/400) QUERY”

Course Code : GSQRY

♦      COURSE OBJECTIVE

After completing this course, participants should be able to create, display and to run AS/400 Query, to select, arrange, and analyze information (data) stored in one or more database files to produce reports and other data files.

♦      COURSE PREREQUISITES

AS/400 System Operation ( Optional )

AS/400 Database Fundamental ( Optional )

♦      COURSE PROGRAM CONTENTS

⇒    Query Menus

*   Files

*   Office Task

⇒     Work with Queries Display

*   Create, change, Display (define the query display)

*    Query definition

• Specify file selections
• Define result fields
• Select and sequence fields
• Select records
• Select sort fields
• Select collating sequence
• Specify processing options

*   Report Definition and Output

• Report format characteristics
  • Format report columns
  • Specify report summary functions
  • Define report breaks and forma

• Report Output characteristics
  • Displayed output
  • Printed output
  • Database file output

*   End the definition

• Run the query
• Save the query

*   Delete a query

*   Run a query

*   Print a query definition

*   Merge query data into word processing documents

♦     COURSE METHODS

*   Associate learning ; using familiar concepts to help participants grasp unfamiliar terms or technical concepts.

*   Task based objective ; learning individual tasks that taken together, result in overall proficiency.

*   Practise sessions ; allow participants to monitor and reinforce progress.

♦     COURSE DURATION       

2 Days