COURSE : Query/400 - (M080)

 

OBJECTIVE :

  • Designed for Operations Managers and Supervisors to be proficient in the use of AS/400 Query

 

COURSE DESCRIPTION :

  • Designed for users to be proficient in the use of AS/400 Query

  • Define how to create an AS/400 Query

  • Define options to select, sort, format, perform calculations, specify output and modify

  • Understand the basics of AS/400 database, including logical files and keyed access paths

  • Decrease the impact Queries have on other users (via Batch or Logical Files)

  • Gain a more detailed understanding of some of the advanced functions of Query/400 such as substrings.

 

PREREQUISITE : 

  • Having basic knowledge of computing fundamentals, concepts and environment.

 

AUDIENCE :

  • Operations Managers and Supervisors

 

WHAT YOU WILL LEARN :

  • Define how to create an AS/400 Query

  • Define options to select, sort, format, perform calculations, specify output and modify

  • Work with an AS/400 Query