iSeries (AS/400) System Facilities

Introduction

This is a foundation course for new programmers to the system or anyone wanting a good understanding of the facilities the system offers. Delegate will create database files and add data to those files. Create basic CL program and create basic menus. Delegates will get to use PDM, SEU,DFU and SDA to carry the out and other tasks. Delegates will also be using tools such as Query, SQL, Navigator, copying files, copying databse files to PC files etc.

Who should attend

Programmers, Analyst/Programmers and Analysts responsible for the development and use of systems on the iSeries. Supervisors, System Integrators, Help Desk Support Staff, Technical Support Personnel and DP Managers will gain a thorough understanding of the iSeries from this course. Senior Operators may also attend this course prior to going on to CL Programming.

Pre-requisites

Whilst there are no pre-requisites for this course, an appreciation of computer concepts is beneficial. A familiarity with an iSeries keyboard would be helpful as this course has a high practical content.

Course content

• Introduction to the system and how it has evolved.
• Introduction to the key architectural features of the system.
• Detail the intergrated features of the operating system.
• Detail how operating system release levels work.
• Introduce the main licensed programs.
• Create and manage objects and libraries.
• How library lists work and how to change them.
• Overview the Intergrated File System (IFS).
• Using Control Language (CL) commands and menus.
• Detail jobs and job descriptions and how to change them.
• Detail the flow of interactive and batch jobs through the system.
• Detail how printing works.
• Introduction to the key areas of Security.
• Create menus using Screen Design Aid (SDA).
• Use Program Development Manager (PDM) and create user defined options.
• Use Source Entry Utility (SEU).
• Detail the DB2 Database concepts and commands.
• Introduce and overview Journaling.
• The role of Source Files.
• The role of Physical and Logical files.
• Create Physical Files using Data Decsription Specifications (DDS).
• Create Logical Files using DDS.
• Use Data File Utility (DFU) to add, update and delete records in DB files.
• Use Navigator to edit files.
• Use the CPYF command and other CL commands to copy files.
• Copy a DB file to a PC file from a command line.
• Copy a DB file to a PC file using Navigator.
• Introduce the Query Licensed Program and Interactive SQL.
• Run a simple Query and use the SQL SELECT statement.
• Use SQL Assist to run the SELECT statement.
• Demonstrate a display file.
• Introduce Program Control Structures.
• How to pass parameters to a program.
• Introduction to CL programming.
• Types of CL programs.
• Detail the structure of a CL program.
• Use and change variables in a CL program.
• Pass parameters into a CL program.
• How to write basic CL programs.
• Using CL commands within a CL program.
• Debugging CL programs.
• Use message queues and message files.
• Create message descriptions.
• Send messages from a command line and within a CL program.
• How to create user defined commands.
• Use Navigator to manipulate objects/spooled files etc..

Materials

A course manual with supporting documentation is provided.

Schedule