IBM  AS/400 Course Contents



     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 	     
o	Single Level Storage 
o	Virtual Storage 
o	Licensed Products & Programming Languages    
o	AS/400 Object 
o	Describe Library/Object concepts 
o	Library List 
o	Menus.    
     SECURITY CONCEPTS    
     AS/400 WORK MANAGEMENT
•	Introduction to Work Management  	
•	Job Definition	
•	Job Types 
•	Submitting Batch Job
•	Spool Files & Output Queues 
•	Subsystem & Subsystem Description 
•	Storage Pools
•	Basic Message Handling
     PROGRAMMING FRAMEWORK
•	Programming Environment 
•	Member Concept 
•	Source Physical File 
•	Standard Naming Conventions 		
•	Getting Started with PDM 
•	WRKLIBPDM 
•	WRKOBJPDM 
•	WRKMBRPDM
•	Source Entry Utility 
•	Entering SEU 
•	SEU Work Screen 
•	Editing Functions 
•	SEU Command  Line  
DDS FOR PRINT DESIGN
•	Structure of DDS , Device File
 
  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
  AS/400 MENUS
•	Design Menu 
•	Creation of Menu
  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

   RELATIONAL DATABASE MANAGEMENT  - DB2/400
   INTRODUCTION TO DATABASE MANAGEMENT
•	AS/400 Integrated Database 
•	Types of Database File   
•	Program Described File
•	Externally Described File
  AS/400 RELATIONAL DATABASE 
•	Access Path Definition
•	Physical File 
•	Multiple Members in a File
•	CRTPF Parameters 
•	Filed Reference File
  LOGICAL FILE
•	DDS Keywords 
•	Join Logical File 
•	CPYF
  AS/400 DATABASE MAINTENANCE
•	DSPFFD 
•	DSPPGMREF 
•	DSPDBR 
•	FNDSTRPDM
  JOURNALLING
  REFERENTIAL INTEGRITY & TRIGGERS
 COBOL/400 PROGRAMMING LANGUAGE   
 COBOL/400 PROGRAMMING LANGUAGE
 
•	Overview Of COBOL / 400 Programming
•	Features of COBOL/400 Complier
•	Entering COBOL/400 source program
•	Compiling COBL/400 program
•	Debugging COBOL/400 program
•	Running COBOL/400 complied program

 COBOL/400 LANGUAGE STRUCTURE

•	Structure of the COBOL/400 program 
•	Character Set
•	COBOL/400 Words 
•	Arithmetic Expressions
•	Figurative Constants 
•	User Defined 
•	Literals or Constants 
•	Numeric & Non-Numeric literals 
•	Data Type  
•	Program Layout 
•	Continuation Lines

 COBOL/400 PROGRAM STRUCTURE
•	IDENTIFICATION DIVISION
•	ENVIRONMENT DIVISION
•	DATA DIVISION 
•	PROCEDURE DIVISION

INPUT/OUTPUT STATEMENTS IN COBOL/400

•	ACCEPT Statement 
•	DISPLAY Statement

DATA MANIPULATED STATEMENTS
 
•	COPY Statement 
•	PERFORM VARYING Statement 
•	SET Statement 
•	SEARCH Statement
PROGRAM CONTROL STATEMENTS
•	STOP  RUN Statement 
•	EXIT Statement  
•	GO TO Statement 
•	PERFORM Statement
ARITHMETIC VERBS & STATEMENTS       
•	ADD Verb 
•	SUBTRACT Verb 
•	MULTIPLY Verb 
•	DIVIDE Verb 
•	MOVE Statement
        COMPUTE Statement 
•	ON SIZE ERROR Statement 
•	ROUNDED Statement
 FILE HANDLING STATEMENTS

•	OPEN Statement 
•	READ Statement 
•	WRITE Statement 
•	CLOSE Statement 
•	START Statement 
•	REWRITE Statement 
•	DLETE Statement
 FILE ORGANIZATION       
•	 Sequential
•	Relative 
•	Indexed 
•	File Updating 
•	Indexed Files

 TRANSFERRING CONTROL TO ANOTHER PROGRAM        
•	Main Program and Sub Program  
•	Initialization of  Storage  
•	Passing  Data Using by Reference or by Content 
•	Describing Arguments in the Calling Program 
•	Describing Parameters in the Called Program 
•	Program Termination Statement 
•	Cancel Statement  
•	Call Statement 
•	Usage of Linkage Section 
•	Call Statement Considerations 
INTRODUCTION TO SUB FILE
•	Introduction to Sub files 
•	To Access Records 
•	Read Sub file 
•	Write Sub file 
•	Read Sub file Next Modified 
•	Rewrite Sub file 
•	Random Access of Sub file Records 
•	Sequential Access of Sub file Records

SORTING & MERGING 

TABLE HANDLING

RPG /400 Programming languages:

•	Introduction to RPG/400
•	Structured programming 
•	Structured operations
•	RPG/400 specifications 
•	Development of RPG Program 
•	Operation Codes ( op codes) 
•	RPG/400 indicators, Figurative Constants
•	File Processing
•	Handling Display Files in RPG/400 program
•	Creating RPG Program
•	Debugging RPG/400 program
•	subprogram and parameter processing
•	DATA AREA
•	DATA STRUCTURE
•	ARRAYS
•	Sub files
•	11. Exception and Error handling
•	12. DATA QUEUE
•	13. ILE Programming Language concepts