Query for iSeries Workshop

IBM Singapore Pte Ltd
Singapore, Singapore

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course will teach the student the basic structure of database files on the AS/400 and how to define, run and change queries of those files, using the IBM Query for AS/400 program product (5679-QU1 for V4 or 5722-QU1 for V5).


Objective
After completing this course, you should be able to:

Describe the structure of physical and logical files and how they are defined on the AS/400
List the major features and functions of AS/400 QueryDefine 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 data-type fields in a query
Use date, time and timestamp expressions in result fields
Compute a date duration between two fields that contain dates, but which are character or numeric fields, not date-type fields
Use the DIGITS function to return the character representation of a number
Use substring and concatenation operations to manipulate character fields
Define queries for all three types of joins allowed by query
= Matched records
= Matched records with primary file
= Unmatched records with primary file
Join three files in one query
Define a query with fields of length zero so it will not show in the detail lines of a report, but will be available in break text
Write a query in which fields in detail lines are compared to break level summary values

...''

Phone:(65) 6418-1688 Fax: (65) 6544-2589

School Address:

IBM Learning Services, Level 04
IBM Singapore Pte Ltd
THE IBM PLACE II
9 Changi Business Park Central 1
Singapore 486048
Tel:(65) 6418-1688 Fax: (65) 6544-2589

Jobs & Resumes: Singapore
Houses & Roommates: Singapore

Object-Oriented Analysis and Design Using UML
OS/390 JCL and Utilities
OS/400 V5.1 TCP/IP Implementation & Server Configuration
Perl Programming for Open Systems and World Wide Web
Principles of Project Management
Principles of Software Testing for Testers
Programming XML & Related Technologies for Java
Project Leadership & Team Building
Project Management Concepts
pSeries Logical Partitioning (LPAR) for AIX 5L
Rational TeamTest Fundamentals for Performance Testing
Rational Test RealTime Component Testing for C++
Rational Test RealTime Runtime Analysis

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!