INTRODUCTION TO THE AS/400

  • Overview of Application System/400
  • AS/400 Version & Release
  • High Level Machine – Technology Independence
  • AS/400 Connectivity
  • OS/400 Concepts
  • Single Level Storage
  • AS/400 Objects
  • Library List
  • Menus

DB2/400

  • Introduction To Database Management
  • Types of Database File
  • Program Described File
  • Externally Described File
  • AS/400 RELATIONAL DATABASE
  • Access Path Definition
  • Physical File & Parameters
  • Multiple Members in a File
  • CRTPF, CRTLF Parameters
  • Field Reference File
  • LOGICAL FILES & Parameters
  • Types of Logical files
  • Non-Join LF
  • Join LF
  • DDS Keywords
  • AS/400 DATABASE MAINTENANCE
  • DSPFD, DSPFFD, DSPPGMREF, DSPDBR,
  • FNDSTRPDM, CPYF, CRTDUPOBJ, etc.
  • Journaling
  • Referential Integrity

PROGRAMMING FRAMEWORK

  • Programming Environment
  • Member Concept
  • Source Physical File
  • Getting Started with PDM
  • WRKLIBPDM, WRKOBJPDM, WRKMBRPDM
  • Working with Source Entry Utility (SEU)
  • Editing Functions

DDS FOR SCREEN DESIGN

  • DDS Design for Screens
  • Screen Layout
  • DDS Keywords
  • Creating Display File
  • Manipulating The Database
  • Accessing Data Via Utilities
  • Data File Utility
  • Create DFU Program

COBOL/400 Programming Language

  • Introduction to COBOL and its versions
  • COBOL Program Structure
  • Field Declaration – Data Types
  • COBOL Statements - ACCEPT,
  • DISPLAY, MOVE, INITIALIZE, IF,
  • EVALUATE, STRING, UNSTRING,
  • COPY, COMPUTE, PERFORM,
  • REDEFINES, RENAMES,
  • COMPUTATION USAGES, STOP RUN,
  • EXIT, EXIT PROGRAM, GOBACK,
  • INSPECT
  • COBOL programming using Sequential,
  • Indexed and Relative files
  • COBOL Report generation programming
  • COBOL programming using DISPLAY files
  • COBOL programming using sub files
  • COBOL programming with arrays
  • Using arrays in programs with SEARCH &
  • SEARCH ALL
  • Subscripting & Indexing
  • Sorting & Merging
  • Resolving File Status codes and abends

DDS FOR SCREEN DESIGN

  • DDS Design for Screens
  • Screen Layout
  • DDS Keywords
  • Creating Display File
  • Manipulating The Database
  • Accessing Data Via Utilities
  • Data File Utility
  • Create DFU Program

MORE FACILITIES

  • Application Program Interface
  • Journaling
  • Commitment Control

CONTROL LANGUAGE PROGRAMMING (CL/400)

  • Command Syntax
  • CL Commands
  • CL Program Structure
  • Declaring Variable
  • Relational & Logical Expressions
  • Declaring a Display File in a CL Program
  • Consideration for Declaring a Display File in a
  • CL Program
  • Branching Outside a Program
  • Parameter Passing
  • Calling HLL from CL program
  • Changing the Value of a Variable
  • Concatenation, Substring Operation
  • Creation of CL Program & Debugging
  • Data Area
  • OPNQRYF
  • DATA QUEUE

ILE programming language concepts

  • Procedures
  • Modules
  • Programs
  • Service programs
  • Activation Groups