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.

• 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

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

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

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.
GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process: http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf
Once you enroll in a GTP class, you will receive a confirmation letter that should show:
    The current GTP list price
    The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.