Course Description
This 2-day course is designed to introduce participants to the powerful querying capabilities of the IBM iSeries (AS/400) platform. The course focuses on using Query/400, a tool that allows users to extract and analyze data stored in the iSeries database. Participants will learn how to create, modify, and run queries to generate reports, extract meaningful insights, and support decision-making processes. The course is ideal for users who need to retrieve and manipulate data directly from the iSeries database.
Duration
2 Days
Course Objectives
- Understand the basic structure of databases and files on the iSeries.
- Create and execute queries using Query/400 to retrieve data.
- Modify existing queries to meet specific reporting needs.
- Filter, sort, and summarize data using various query options.
- Generate formatted reports from query results.
- Save, schedule, and manage queries for regular use.
Course Audience
- Business analysts and report developers who work with data stored on iSeries.
- IT professionals and system administrators who need to generate reports from iSeries data.
- End users who need to access and manipulate iSeries data.
- Anyone interested in learning how to effectively query databases on the iSeries platform.