Mike Faust. The iSeries and AS/400 Programmer's Guide to Cool Things

Mc Press, 2002. — 320 p. — ISBN: 1-58347-017-4.This book reveals how to give a new face to iSeries and AS/400 applications by offering a suite of techniques to use with green-screen programs: Query Manager/400, advanced display DDS functions, user-defined ILE functions, and Advanced Function Printing. Tools are provided that give PC client applications and interfaces more function and usability with ADO, OLE DB, and FTP. Possibilities are explored for using iSeries or AS/400 to develop web pages, implement e-mail, and use ActiveX Data Objects to develop applications in Visual Basic.Dedication
Title Page
Copyright Page
Table of Contents
Section I - Green Screen Cool Things
1 - Creating Reports with Query Manager/400
Query Manager Queries
Query Manager Report Forms
Query Manager Tables
Query Manager Profiles
Query Manager Procedures
2 - Creating Green Screen GUI Applications
Display File Windows
Building Menus
Additional GUI Objects
3 - ILE RPG User-Defined Functions
Creating the Modules
Useable Samples
Pop-Up Calendar
Message Box
Pop-Up Calculator
List Box
4 - Advanced Function Printing
The Set Up
The Keywords
Invoice Creation
Section II - PC Client Cool Things
5 - ADO, OLE DB, and Other Acronyms
File Viewer Application
Report Writing
File Update Application
6 - FTP, File Transfer, and More
FTP Basics
FTP Scripting
The iSeries 400 as an FTP Client
Error Handling with FTP Scripts
Section III - Cool Things and the Internet
7 - DB2/400 Web Pages on IIS
DB2/400 Web Reports
Updating Data from a Web Page
8 - Internet E-Mail from the iSeries
The Set Up
SMTP Report Distribution
Extending SNDRPTEML Functionality
9 - Web to 400
Web-to-Host Concepts
iSeries Web Client
10 - Looking Back and Forward
Combining Techniques
ILE Convert Date Function
DB2/400 And SQL Server
Time Flies