EIEIOTECHNOVATION
← Training programmes

EIEIO / AUTOMATION & EMERGING TECHNOLOGY

AS400CMY- Fast-track to IBM System i (previously AS400) for New Employees

Course outline

15 days
Discuss this programme →

Duration

15 days

Audience

This is a basic crash course for individuals who are fresh out of University and/or new to IBM System I (or previously known as AS400).

Pre-requisites

Students should have relevant technical degree/diploma with knowledge and experience in writing a simple program in another high-level language (for example, BASIC ).

Course Objective

The purpose of the class is to train newly hired employees who has no exposure in IBM System I to quickly ramp up in basic skills, ie OS/400, DB2, RPG and Control Language.

Students will exit the course with sufficient skills to be put into subsequent On the Job Training arranged by the employer with the appropriate Mentor pairing.

Part I : Introduction to OS/400 operating system and DB2

Total number of days = 1 day

Topics covered in OS/400

  • Sign on, Library list, Object commands, Job log, Messages;
  • Working with objects, commands, WRKMBRPDM, managing members;
  • System libraries, SYS, QGPL, QTEMP etc. Submission of Job
  • Introduction to Interactive and Batch jobs.

Topics covered in DB2

  • Physical file: DDS, DSPFD, DSPFFD, DSPDBR, DSPOBJD,
  • Levels in the DDS of Physical file; Multi member physical files, record level identified, CHGPF, CPYF, CRTDUPOBJ
  • Logical file - single, join logical file.
  • Select / omit Level as the fifth level in the DDS of Logical file

Part II : Working with ILE RPG

Total number of days = 9 days

Topics covered

  • AS/400 programming model.
  • Role of SDA, RLU, SEU, RPG and CL in this model, OPM Environment characteristics
  • Forms, delcaration of various types of files, options for declarations such as UC
  • Data Types and Data Formats, Specifications, methods of declarations, arrays and their types, tables
  • Expressions, Indicators - such as internal, external, special purpose, Logic cycle indicators.
  • File processing opcodes for different types of files. Handling record locks for PF. SETLL, CHAIN, READGT etc
  • Sequential and Keyed access to Physical and logical files. Need of keyed access.
  • RPG Error Handling. Special subroutines : *PSSR, *INZSR.
  • Investigation Techniques : Analysis of Dump, DUMP opcode, H spec options to help in debugging
  • Subfiles. Data area programming. Data Queue programming
  • ILE Environment characteristics, Procedures and sub-procedures
  • Passing arguments, Modules - keyword for different specs,
  • ILE Concepts/Call to Procedures; Built in functions modules; Service programs
  • Embedded SQL; Activation group; ODP

Part III : IBM Control Language Programming skills

Total number of days = 5 days

Topics covered

  • Features, Main strenght of this language, Variables, data types, Control Statements
  • Send/Receive messages, Message delivery options, Message Queues
  • Operators and Functions,Exception handling, Monmsg at both levels
  • Using Files; Working with Objects, Manage objects and authorities
  • IF, GOTO etc constructs, Displaying Workstation files, reading database files (Physical and logical files). Searching for data in PF, LF
  • Retrieve object descriptions, Retrieve job description
  • Send and receive messages, Types of messages
  • SBMJOB, WRKSBMJOB, WRKACTJOB
  • Debug CL program,TFRCTL. Calling other programs Passing Parameters
  • Calling API programs, QCMDEXEC

Remarks

Practical Work

This course is structured in a lecture/lab format. The hands-on sessions form a vital and integral part of the course.

Revised : Feb 2012. V1.1

Programme scope, delivery arrangements and suitability are confirmed during enquiry.