IBM i Technical Introduction OL4AG

Duration: 
3 days
Codes: 
OL4AG

Overview

This course is critical to your building a solid foundation of knowledge of the application development tools that you will be using on a day to day basis in your job as a programmer. We do not cover all aspects of each and every tool. To do so would require two weeks. For those areas where you want additional training, there are other courses that teach Control Language Programming and the RDi product.

This course is a prerequisite for all programming courses that follow. You should plan to learn as much as you can in class. Ask questions to clarify any misunderstandings. This is your class and the instructor is dedicated to maximizing your learning experience.

The exercises provide the student an opportunity to use and experiment with of the facilities taught in this course.

NOTE: This is the course that replaces 'OL49G - IBM i Programming Facilities Workshop' which was retired in 2015.

Audience

This intermediate class is intended for Programmers and Systems Analysts or anyone with a need to understand the IBM i (formerly AS/400) from a programming point of view. The overall objective of this class is to provide basic IBM i concepts and an overview of the programming facilities available on the server as well as the client.

This class provides the necessary foundation for the rest of the programming curriculum and the database classes, including DB2 for i: DB Coding and Implementation Using DDS and CL Commands (OL62G).

Skills Gained

  • Describe what application development tools are available
  • Identify platforms where tools are used
  • Describe the purpose and use of each tool
  • Create a user profile, library, output queue, and job description
  • Describe the key elements of Work Management, security, and device files
  • Write a basic control language (CL) program to run application programs
  • Define physical and logical files on the IBM i
  • Create physical and logical files
  • Use the basic features of the LPEX Editor to enter and maintain file definitions
  • Use the basic features of the Screen Designer and Report Designer to design, create, and maintain displays and reports
  • Use Interactive SQL and IBM i Navigator to create schema, tables, views, and indexes

Prerequisites

You must be able to:

  • Navigate IBM i menus
  • Use common IBM i commands
  • Use IBM i Help and IBM i Knowledge Center
  • Use a Windows-based PC and navigate PC menus and windows
  • Explain programming concepts
  • Write a simple program in any programming language

Course Outline

Day 1

  • Unit 1 - Class administration and introduction
  • Unit 2 - IBM i application development tools
  • Unit 3 - IBM i concepts and overview
  • Unit 4 - IBM i Access and IBM i Navigator
  • Exercise 1 - Navigating IBM i Navigator
  • Unit 5 - Managing work flow on the IBM i
  • Unit 6 - Commands, profiles, and libraries

Day 2

  • Exercise 2 - Create library and work with library list
  • Exercise 3 - Modify profile, work with job description and alternate job
  • Unit 7 - Introduction to IBM i security
  • Unit 8 - Control language programming
  • Exercise 4 - Write a basic CL program
  • Unit 9 - Basic message handling
  • Exercise 5 - Using messages

Day 3

  • Unit 10 - Creating reports and displays
  • Exercise 6 - Editing display file source
  • Exercise 7 - Designing and creating display files
  • Exercise 8 - Using Screen Designer to create reports
  • Unit 11 - IBM DB2 for i
  • Unit 12 - Accessing the IBM i database using SQL and IBM i Navigator
  • Exercise 9 - Working with the database using IBM i Navigator

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Live Virtual Live Virtual3 2250 £2250 2019-09-23
Live Virtual Live Virtual3 2250 £2250 2019-10-28
Live Virtual Live Virtual3 2250 £2250 2019-11-25
Live Virtual Live Virtual3 2250 £2250 2019-12-10
Somerset Bath3 2250 £2250 2019-12-16
Live Virtual Live Virtual3 2250 £2250 2020-01-22
Live Virtual Live Virtual3 2250 £2250 2020-01-28