| |
| |
| Preface | |
| |
| |
| |
| System | |
| |
| |
| |
| AS/400 System Overview | |
| |
| |
| |
| Major Characteristics of AS/400 | |
| |
| |
| |
| Operating System/400 | |
| |
| |
| |
| AS/400 Advanced Series | |
| |
| |
| |
| AS/400e Series and e-business Solutions | |
| |
| |
| Review Questions | |
| |
| |
| |
| Menus and User Interface - A Tutorial | |
| |
| |
| |
| Sign On and Sign Off | |
| |
| |
| |
| Types of Displays | |
| |
| |
| |
| Operating the System by Built-in Menus - Lab Exercise | |
| |
| |
| |
| Function Keys and Prompting - Lab Exercise | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| AS/400 Control Language (CL) - A Tutorial | |
| |
| |
| |
| CL Command Syntax and Command Names | |
| |
| |
| |
| CL Command Parameters | |
| |
| |
| |
| Required and Optional Parameters | |
| |
| |
| |
| Sample CL Commands with the Required and Optional Parameters | |
| |
| |
| |
| Predefined and User-supplied Parameters Values | |
| |
| |
| |
| Command Entry and Command Prompting - Lab Exercise | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Work Management and Job Processing | |
| |
| |
| |
| Work Management Concept and Structure | |
| |
| |
| |
| Jobs and Subsystems | |
| |
| |
| |
| Major System and Job Commands | |
| |
| |
| |
| Job Description | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Object-oriented Architecture | |
| |
| |
| |
| Concept of Object | |
| |
| |
| |
| Object Types | |
| |
| |
| |
| Object Management | |
| |
| |
| Review Questions | |
| |
| |
| |
| Using Libraries and Library List - A Tutorial | |
| |
| |
| |
| Concept of Library | |
| |
| |
| |
| Library Types | |
| |
| |
| |
| Library List | |
| |
| |
| |
| Commands for Manipulating the Library List | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Storage Management | |
| |
| |
| |
| Virtual Storage and Single-level Storage | |
| |
| |
| |
| Storage Pools | |
| |
| |
| |
| RAID-1 and RAID-5 Technologies | |
| |
| |
| |
| Managing DASD | |
| |
| |
| Review Questions | |
| |
| |
| |
| System Security | |
| |
| |
| |
| Security Levels | |
| |
| |
| |
| User Profile and Group Profile | |
| |
| |
| |
| User Classes | |
| |
| |
| |
| Authorization List | |
| |
| |
| Review Questions | |
| |
| |
| |
| Backup and Recovery | |
| |
| |
| |
| Overview of Backup and Recovery | |
| |
| |
| |
| Backup Methods and Commands | |
| |
| |
| |
| Recovery Methods and Commands | |
| |
| |
| Review Questions | |
| |
| |
| |
| Utilities (Application Development Tools) | |
| |
| |
| |
| Programmer Menu and Application Development Tools | |
| |
| |
| |
| Programming Support | |
| |
| |
| |
| Programmer Menu | |
| |
| |
| |
| Overview of Application Development Tools | |
| |
| |
| Review Questions | |
| |
| |
| |
| Source Entry Utility (SEU) - A Tutorial | |
| |
| |
| |
| Features of SEU | |
| |
| |
| |
| Starting SEU | |
| |
| |
| |
| Start SEU Command Parameters | |
| |
| |
| |
| Editing Source Member | |
| |
| |
| |
| Using Prompts and Format Lines | |
| |
| |
| |
| Exiting from SEU | |
| |
| |
| |
| Lab Exercise | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Data File Utility (DFU) - A Tutorial | |
| |
| |
| |
| Data File Utility (DFU) Overview | |
| |
| |
| |
| Creating a DFU Program - Lab Exercise | |
| |
| |
| |
| Changing a DFU Program - Lab Exercise | |
| |
| |
| |
| Running a DFU Program - Lab Exercise | |
| |
| |
| |
| Deleting a DFU Program | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Screen Design Aid (SDA) - A Tutorial | |
| |
| |
| |
| Screen Design Aid (SDA) Overview | |
| |
| |
| |
| Designing and Creating Menus - Lab Exercise | |
| |
| |
| |
| Designing and Creating Displays - Lab Exercise | |
| |
| |
| |
| Testing Displays | |
| |
| |
| |
| Work Screen Functions | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Programming Development Manager (PDM) - A Tutorial | |
| |
| |
| |
| Programming Development Manager (PDM) Overview | |
| |
| |
| |
| Starting PDM | |
| |
| |
| |
| Working with Libraries Using PDM - Lab Exercise | |
| |
| |
| |
| Working with Objects Using PDM - Lab Exercise | |
| |
| |
| |
| Working with Members Using PDM - Lab Exercise | |
| |
| |
| |
| PDM Options and Corresponding Commands | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Database | |
| |
| |
| |
| Relational Database Concept | |
| |
| |
| |
| Database Management System and Database Models | |
| |
| |
| |
| Concept and Structure of the Relational Database | |
| |
| |
| |
| Sample Tables and Views | |
| |
| |
| Review Questions | |
| |
| |
| |
| AS/400 Database: DB2/400 | |
| |
| |
| |
| The Model and Terms of DB2/400 | |
| |
| |
| |
| DB2/400 Database Files: Physical Files and Logical Files | |
| |
| |
| |
| Externally Described Files and Program Described Files | |
| |
| |
| Review Questions | |
| |
| |
| |
| Using Data Description Specifications (DDS) to Define Database Files - A Tutorial | |
| |
| |
| |
| DDS Concepts and Procedures | |
| |
| |
| |
| DDS Entries and Specifications | |
| |
| |
| |
| Using DDS to Define a Physical File | |
| |
| |
| |
| Using DDS to Define a Logical File | |
| |
| |
| |
| Using DDS to Define a Join Logical File | |
| |
| |
| |
| Entering and Compiling DDS - Lab Exercise | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Programming | |
| |
| |
| |
| AS/400 Programming Languages | |
| |
| |
| |
| AS/400 Application Programming Support | |
| |
| |
| |
| Overview of AS/400 Programming Languages | |
| |
| |
| Review Questions | |
| |
| |
| |
| Control Language Programming (CLP) | |
| |
| |
| |
| Control Language Programming Overview | |
| |
| |
| |
| Major Functions of CL Programs | |
| |
| |
| |
| CL Program Structure | |
| |
| |
| |
| A Sample CL Program | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| RPG/400 | |
| |
| |
| |
| Structured RPG | |
| |
| |
| |
| RPG Logic Cycle | |
| |
| |
| |
| RPG Indicators | |
| |
| |
| |
| RPG Specifications and Op Codes | |
| |
| |
| |
| A Sample RPG/400 Program | |
| |
| |
| Review Questions | |
| |
| |
| |
| RPG/400 Versus RPG II | |
| |
| |
| |
| The Evolution of RPG | |
| |
| |
| |
| Externally Described Files | |
| |
| |
| |
| Structured Programming | |
| |
| |
| |
| Data Structure, Data Area, and Subfile | |
| |
| |
| |
| Indicators and Composite Key | |
| |
| |
| Review Questions | |
| |
| |
| |
| COBOL/400 | |
| |
| |
| |
| COBOL/400 Overview | |
| |
| |
| |
| Identification Division | |
| |
| |
| |
| Environment Division | |
| |
| |
| |
| Data Division | |
| |
| |
| |
| Procedure Division | |
| |
| |
| |
| A Sample COBOL/400 Program | |
| |
| |
| Review Questions | |
| |
| |
| |
| SQL/400 - A Tutorial | |
| |
| |
| |
| SQL/400 Overview | |
| |
| |
| |
| SQL Statements - Lab Exercise | |
| |
| |
| |
| Embedded SQL and Interactive SQL | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| Query/400 - A Tutorial | |
| |
| |
| |
| Query/400 Overview | |
| |
| |
| |
| Major Options of Query/400 | |
| |
| |
| |
| Using Query/400 - Lab Exercise | |
| |
| |
| Review Questions | |
| |
| |
| Lab Assignment | |
| |
| |
| |
| AS/400 Integrated Language Environment (ILE), Modular Programming, and Object-oriented Programming (OOP) | |
| |
| |
| |
| ILE Concepts and Key Elements | |
| |
| |
| |
| ILE Advantages | |
| |
| |
| |
| ILE Structure | |
| |
| |
| |
| ILE Versus Conventional Program Development | |
| |
| |
| Review Questions | |
| |
| |
| |
| Java on the AS/400 | |
| |
| |
| |
| Java Overview | |
| |
| |
| |
| Programming in Java - A Tutorial | |
| |
| |
| |
| Java's Integration into the AS/400 | |
| |
| |
| |
| Setting Up the AS/400 Toolbox for Java | |
| |
| |
| |
| Client/Server, Networking, and Internet | |
| |
| |
| |
| Client/Server with the AS/400 | |
| |
| |
| |
| Client/Server Concept | |
| |
| |
| |
| Client/Server Pros and Cons | |
| |
| |
| |
| Client/Server Computing with the AS/400 | |
| |
| |
| Review Questions | |
| |
| |
| |
| TCP/IP Network - A Tutorial | |
| |
| |
| |
| TCP/IP Overview | |
| |
| |
| |
| TCP/IP Network and Protocols | |
| |
| |
| |
| TCP/IP Configuration: Step-by-Step | |
| |
| |
| |
| Internet and Web Enabling | |
| |
| |
| |
| Internet Terminology | |
| |
| |
| |
| Internet Connection for AS/400 | |
| |
| |
| |
| World Wide Web HTTP Server | |
| |
| |
| |
| AS/400 Internet Security and Firewall for AS/400 | |
| |
| |
| |
| Groupware, Lotus Notes, and Domino for AS/400 | |
| |
| |
| |
| Overview of Groupware, Lotus Notes, and Domino | |
| |
| |
| |
| Features of Domino for AS/400 | |
| |
| |
| |
| Enterprise Integration with Domino for AS/400 | |
| |
| |
| |
| Web Serving with Domino for AS/400 | |
| |
| |
| |
| SAP on the AS/400 | |
| |
| |
| |
| SAP Overview | |
| |
| |
| |
| Open System Architecture | |
| |
| |
| |
| SAP R/3 Multi-layer Client/Server Architecture | |
| |
| |
| |
| Combining the Strengths of SAP R/3 and AS/400 | |
| |
| |
| |
| Porting SAP R/3 to AS/400 | |
| |
| |
| |
| AS/400 Functionality Integrated into SAP R/3 | |
| |
| |
| |
| Using Client Access - A Tutorial | |
| |
| |
| |
| Client Access Overview | |
| |
| |
| |
| Data Transfer from AS/400 - Lab Exercise | |
| |
| |
| |
| Data Transfer to AS/400 - Lab Exercise | |
| |
| |
| |
| Project | |
| |
| |
| |
| Developing an Application Project Using DB2/400, DDS, SEU, PDM, DFU, SDA, Query/400, RPG/400, and CL Commands | |
| |
| |
| |
| Asset Master Application Project Specifications | |
| |
| |
| |
| Creating a Library and Source Files | |
| |
| |
| |
| Database Layouts of Physical and Logical Files | |
| |
| |
| |
| Using Data Description Specifications (DDS) to Define Database Files | |
| |
| |
| |
| Using Source Entry Utility (SEU) and Programming Development Manager (PDM) to Enter and Compile DDS | |
| |
| |
| |
| Using Data File Utility (DFU) to Enter Data into Database Files | |
| |
| |
| |
| Using Query/400 to Retrieve Data from the Database Files and Produce Reports | |
| |
| |
| |
| Using Screen Design Aid (SDA) to Create an Asset Master Online Inquiry Screen | |
| |
| |
| |
| Coding, Entering, and Compiling an Interactive RPG/400 Program | |
| |
| |
| |
| Using Screen Design Aid (SDA) to Create a User-defined Menu | |
| |
| |
| |
| Running the User-defined Menu | |
| |
| |
| Answers to Even-numbered Questions | |
| |
| |
| Index | |