|   Using Query/400
This course also available online.
Author: Manta TechnologiesAvailability: Ships within 72 hours.
SKU: 3006 | |
Course Description:
If you are like many AS/400 and iSeries users, you frequently need to get information from a DB2 UDB database. This request for information, or query, can be easily described and run using the IBM Query/400 product.
This course begins with an introduction to relational database terminology and Query/400 facilities. You will see how to access the Query/400 displays from which you define and manipulate queries.
You will then see how to define and run queries. Starting with very basic queries, you will proceed to more advanced queries, such as a query that generates summary data and a query that joins two files. The course ends by describing Query/400's report formatting capabilities.
Click here for pricing and order information
After completing this course, you should be able to:
• Use and define relational database terminology
• Display the Work with Queries display
• Define a query
• Run a query
• Use Query/400 report formatting capabilities
• Specify where data returned by a query goes
• Define the printer and report characteristics for a printed report
Audience: This course is intended for anyone interested in using Query/400 to query a DB2 UDB database.
Prerequisites: This course assumes that you have a basic knowledge of OS/400 concepts, terminology, and use. You can satisfy this prerequisite by successfully completing the Manta series, Using an iSeries System.
Course Outline:
Introduction to Query/400
Defining and Running a Basic Query
Advanced Querying Capabilities
Customizing a Query Report
Course Details: | Length: | 2 hours | | Materials: | A Student Reference Guide is available for this course. | | Publisher: | Manta |
Using Query/400
This course also available online.
Author: Manta TechnologiesAvailability: Ships within 72 hours.
SKU: 3006 | |
| |
© 2001-2003 MC Press Online, LP. IBM® and AS/400® are registered trademarks of IBM.
All other product names are trademarked or copyrighted by their respective holders.
MC Press Online Privacy Policy
|
|
|
