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.
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).
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
- 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
- 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
- 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
- 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