Duration
5 days
Audience
This is an intermediate course for application developers and programmers, system analysts, and Information Technology (IT) managers who also develop and maintain System i applications. System operators should not attend this class.
Prerequisites
You should complete:
- Intro to System i for New Users (OE980)
or be able to:
- Navigate System i menus
- Use common System i commands
- Use System i Help and System i Information Center
- Use a Windows-based PC and navigate PC menus and windows
- Explain programming concepts
- Write a simple program in any programming language.
Course Objectives
- Describe what application development tools are available
- Identify platform where tools are used
- Describe 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 System 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 CODE Designer to design, create, and maintain displays and reports
- Use Interactive SQL and System i Navigator to create schema, tables, views, and indexes
Course Content
- System i application development tools
- System i concepts and overview
- System i Access/Navigator
- Managing workflow on the System i
- Commands, profiles, and libraries
- Introduction to System i security
- Control Language programming
- Basic message handling
- Creating reports and displays
- DB2 UDB for System i Accessing the System i database using SQL and System i Navigator
- Defining database files using Data Description Specifications (DDS)
- Using the legacy toolset (Program Development Manager (PDM), SEU, CPYF))
Programme scope, delivery arrangements and suitability are confirmed during enquiry.