Query/400 for End User

Query/400 for End User

Course Code: AEQRY

(40% Lecture, 60% Workshop)

Overview

Learn to use the powerful Query Language definition and access language within interactive and the AS/400 Database to produce the report depends on the user requirements.

Several elemen on your system organize and store information, or data, so that you and other system users can work with it to get the results that you need. The following topics introduct those elements, tell you about them and how they relate to you and Query, and direct you to other publications where you can find more information.

Audience

This course is ideal for Database Programmers or Analysts who are responsible for designing, developing and maintaining applications. Familiarity with AS/400 database administration and AS/400 Programming, or have take the course of AS/400 Database Fundamental (DBF).

Objectives

• What Is Query/400?
• Query Fundamentals (Concepts)
• Files, Fields, and Record Formats
• Data Definition Languages and Utilities
• Query Definitions
• Major Functions of Query
• General Operating Information for Query
• Telling Query What You Want
• Using Prompts and Default Values
• Using Query Function Keys
• Checking the Results before Printing the Query Report.
• Using Query Commands
• Choosing a Single Query Task
• Choosing Multiple Query Tasks
• Displaying Constants Format
• Handling Query Messages and Errors

Schedule

2 days in training

Price

Rp 3,025,000

Related posts:

1. Query/400 for End User Query/400 for End User Course Code: AEQRY (40% Lecture,...
2. AS/400 i Beginner Class AS/400 i Beginner Class Course Code: AIBC (40% Lecture,...

Related posts brought to you by Yet Another Related Posts Plugin.