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.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.