Query for Users
Select
a specific file to be queried.
Perform record and field selection, as well as record and field
sequencing. Format
the report using system-defined and user-defined specifications. Create
report breaks based on the value of a field.
Produce detail and summary reports. Create
a simple query that joins two files. Create
and use result fields.| Basic AS/400 File Concepts Query Processing Cycle Formatting Reports Report and Column Headings Field Edit Codes Edit Words Selecting Fields Sequencing the Report Columns Omitting Fields Footers User-Defined Headings |
Data Selection and Sorting Selecting Specific Records Sorting Report Information Computation Fields Defining Computation Fields Add, Subtract, Multiply, and Divide Computation Field Headings Batch Processing Summary Reports Totals and Subtotals Averaging Functions Report Breaks |
Managing and Printing Reports Executing Query Programs Displaying Reports on the Workstation Changing and Deleting Query Programs Displaying the Layout of a Query File Chaining Query Program Maintenance Renaming Query Programs Copying Query Programs Security Merging Query within a Document Direct Merge Help Support |
| Audience Both data processing and non-data processing personnel who require more information from the AS/400. Prerequisites AS/400 Workstation Operations |
Format Self-Instructional Materials Six Audio CDs Student Text Workbook Interactive Media |
Time Required Approximately 10 Hours |