Skip to main content

Course description: System i Application Programming Facilities Workshop

This course is not scheduled. Inquire about Onsite training at your facility.

Overview

List of course details in a data table
Course code OL490 Skill level Intermediate
Duration 5.0 days Delivery type Classroom
(Hands-on labs)
Course type Public or Private on-site    
Public price USD $3,665.00 plus tax  

Gain an introduction to System i features and programming facilities, including:

  • Rational Developer for System i (LPEX Editor, Remote Systems Explorer (RSE) and CODE Designer
  • Programming Development Manager (PDM)
  • Source Entry Utility (SEU)
  • Control Language (CL)
  • System i Access for Windows and System i Navigator
  • Interactive SQL

Also covered, but with less emphasis:

  • Screen Design Aid (SDA)
  • Data File Utility (DFU)
  • Web Query/Query for System i

Hands-on machine exercises give you the opportunity to use and experiment with these facilities.

View this course in other countries


Training Paths that reference this course are:

Back to top

Special note

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - online account

Back to top

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.

Back to top

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

Back to top

Skills taught

  • 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

Back to top

Course outline

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

Back to top

Remarks

This is part of the System i curriculum for programmers. It is a prerequisite to programming classes that teach RPG IV, Control Language and SQL. It is also a prerequisite to the database implementation class, OL620.

Back to top

My IBM

We're here to help

Easy ways to get the answers you need.

or call us at
Call 1-800-426-8322

Open M-F 9AM-7PM ET.

Student center

Find the right course

Offers and more