|
 |
 |
|
iSeries Query
400 [ASD-Q2]
Duration: 2 days
- Audience:
- IT professionals and end users.
- Description:
- This class, with hands-on labs, introduces end users and
IT professional to Query 400. OS/400's relational database
is also reviewed to familiarize the student with physical
and logical file structures.
- Prerequisites:
- None, although this is a technical course end users will
be taught to run queries using databases for which they are
authorized.
- Topics:
- ü
Describe the structure of physical and logical fields &
how they are defined on the AS/400
ü
List the major features and functions of AS/400 Query
ü
Define a query with multiple break levels and summary calculations
ü
Define a query with result fields that are computed using
arithmetic calculations
ü
Embed a field name in break text
ü
Perform summary calculations on result fields
ü
Select records based on whether or not a field is NULL
ü
Use date-type fields in a query
ü
Use date, time and timestamp expressions in result fields
ü
Compute the date duration between two fields that contain
dates, but which are character or numeric fields, not date-type
fields.
- ü
Use substring and concatenation operations to manipulate character
fields
ü
Join three files in one query
-
If you are interested in something beyond what is listed here, please call us
today! We are always adding new courses!
For more training information, please fill out the Information
Request Form
Call EduCorp at 800-668-0943, or
E-mail us at educorp@educorptraining.com
|
|
