AS/Credentials System i Query Class

Query is a decision support utility which can be used to select, sequence and layout file data using one or more database files. The System i Query course is designed to show users, programmers and managers how to generate reports and manage file data on the System i.

Class Details:

• Prerequisites: None
• Duration: One Day
• Cost: $450/day
• Associated Roadmap
• Downloadable flyer

Course Content:

• Explanation of fields, record formats, and database files.
• The use of single or multiple database files.
• Selection and sequencing of fields.
• The use of sort fields.
• The method for setting up multiple report break levels.
• Section and omission of specific records.
• Editing of numeric fields.
• Formatting and summarizing of columns.
• Creation of result fields.
• Definition of output type and output form.
• Use of report summary functions.