AS/400

1. AS/400 : Introduction

1. Hostory
2. OS/400 Concepts(CL and Menu Concepts)
3. Security
4. Programming Environment
5. DDS for Database
2. DB2/400

1. DB2 Relational Database Design & Coding Intro
2. Creating Db2/400 Logical Files
3. DB2/400 Referential integrity
3. Control Language(CL)

1. Basic CL Programming
2. Intermediate Cl Programming
6. Structures Query Language(SQL/400)

1. SQL/400 Programming Workshop
2. Program preparation
3. SQLDA Usage
4. SQL Objects and data Definition
5. Dynamic SQL
6. Program Structure
7. Programming Considerations
4. Integrated Program design

1. Program Efficiency
2. Multifunctional Structured Programming
3. HLL Coding Tips
4. Group Job Management
5. Special File handling
6. Open Query Files
7. Capturing Information
8. Exception and Error Handling
9. Architecture
10. QSYS Model
11. Job Characteristics
12. Introduction to Programming
13. Manipulating Database (DFU, Query/400, SQL on AS/400)
14. Introduction to DB2/400 Relational database
15. Database Performance Consideration for Appln. Design
16. DB2/400 Triggers
17. Message Programming 1 & 2
18. Program Testing
19. Job Execution and Process Access Group
20. Subprograms
21. ILE Overview
22. Screen Design
23. Basic Operations and Coding
24. Designing and recovering
25. Program logic
26. Concepts and Programming Facilities
27. Directory Model
28. Sub Systems and Memory management
29. DDS for Print Design
30. Screen Design Aid
31. DB2/400 Physical File Coding
32. Database Maintainanace Considerations
33. Batch Job
33. Commands
34. Structured Programming
35. File Sharing
36. Design techniques
37. DDS Key Words
38. Commitment COntrol Facilities
39. Record Locks
5. Report Program generator(RPG/400)

1. Basic Interactive Programming
2. Soft Files for Enquiry and Updates
3. Subprogram and data Areas
4. Subfiles for Data Entry
5. Data Structures
6. Handling Program Exceptions
7. RPG Special Coding Techniques
7. JAVA/400

1. Introduction
2. Writinhg Java Application on the Server
2. Writing Applets and Servlets with Java
3. Introducing Visual Age for Java
4. Visual age for Java AS/200 Feature
5. AS/400 Java Performance and Work Management
7. Writing Java Application on CLients
8. Introducing VIsual age for Java Dax