Contact Us: +62 21 750 2345 - gasi.csr@ptgasi.co.id

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

Back to Top