Guild Companies, Inc.  
 
Midrange Programmer - How-To Advice & Free Code
OS/400 Edition
Volume 1, Number 9 - May 9, 2002
In This Issue
Less Theory. More Hands-On Programming, Advice, and Code.
Sponsored By
SOFTLANDING SYSTEMS

Download FREE WebSphere Toolkit!

Automate WebSphere tasks on the iSeries with our free toolkit. Stop/start a WAS instance, copy configs for editing & backup, pre-compile JSPs, & more.

Learn how to plug CM into the WebSphere IDE, manage WebSphere and iSeries objects together, deploy them to any server at the same time, and reduce downtime.

Get your free WebSphere tools and more info online, or call SoftLanding at 603-924-8818 x1.

Sponsored By
LANSA

J.D. EDWARDS CUSTOMERS DEPLOY FAST, SECURE TRANSACTIONAL
E-BUSINESS WITH LANSA COMMERCE EDITION

Extend your J.D. Edwards system to a B2B site in just 4 to 5 weeks! JDE customers Trek Bicycle Corporation, O'Sullivan, and Echo Design have all deployed e-business solutions with LANSA.


More at www.lansa.com/solutions/jde.htm

Creating a VARPG Appointment Calendar
by Shannon O'Donnell


If you've been faithfully reading my series of articles on using VisualAge for RPG, you're probably becoming pretty proficient at creating simple VARPG apps. Creating simple VARPG applications is fun, and, in fact, it's critical that you learn the basics before you move on to more complex topics. But at some point, you have to move on. You'll do that today as you learn how to use VARPG to create a basic VARPG appointment calendar application.
READ MORE >
Dynamic Selection with Embedded SQL
by Kevin Vandever


In "Empower Users with Embedded SQL," I showed you how to dynamically sort subfiles on any column in a subfile by embedding SQL into your RPG code and then allowing the user to select the column, or columns, by which to sort. In this article I am going to build on that application by showing you a couple of ways to dynamically filter or select the data that you want to display in your subfile.
READ MORE >
Sponsored By
ACOM SOLUTIONS

Besides representing a significant expense, pre-printed paper forms used for invoices and other documents may be costing you time and money.

So why use paper when you don't have to? ACOM's EZeDocs gives you the option: print documents from stored electronic templates when you must. Otherwise, send them electronically, faster, bypassing the paper stage. The information is what counts.

Learn how to juice up your procedures, including your collections. Click here for details.

Sponsored By
ASNA

ASNA Visual RPG (AVR) Won the Editors' Choice Apex Award for Application Development & the Readers' Choice Apex Award for eCommerce! Magazine editors & readers alike voted AVR as the best solution for developing Web & Windows applications. See why AVR continues to win all of the industry awards.

Download your FREE trial of ASNA Visual RPG (AVR) and get started with the included "Smarties" tutorial.

Visit the ASNA Web site today: www.asna.com/downloads.asp

Validating XML with a Document Type Definition
by David Morris


In "Getting Started with XML," I introduced you to the Extensible Markup Language and described a few of the rules that XML documents should follow. If you had a chance to read that article, you know XML documents must be "well-formed," meaning they must conform to XML's basic syntax and structure. Optionally, an XML document may be "valid," which means the document conforms to the rules of a document type definition (DTD) or an XML schema that defines the allowed structure and content.
READ MORE>
The Ins and Outs of Qshell
by Ted Holt


Hello, Qshell fans! In the last lesson, you learned about stream I/O. If you have not read that article, it would be good for you to do so now, because some of the concepts mentioned in this article were explained there. In today's lesson, you're going to learn about some basic input and output commands you can use in Qshell scripts. Soon you'll be quite the authority on using stream files in Qshell scripts.
READ MORE>
Sponsored By
PROFOUND LOGIC SOFTWARE


Do you work with complex RPG programs?

Did you know you could add graphical features right into the Source Edit Utility to help you Analyze and Edit RPG source?

You can download and install these features in approximately 1 Minute.


Visit www.RPGAlive.com/now
to find out more.

Sponsored By
WORKSRIGHT SOFTWARE

On June 30, 2002
$$$$  Postal Rates will go UP!  $$$$

On Monday, July 1, your
$$$$  postage bill can go down.  $$$$

CASS certify your mailing names and addresses and presort your outgoing mail with our CASS certification and presort software and save. WorksRight Software is the number-one source for iSeries and AS/400 CASS, presort, ZIP Code, and area code software and data. Visit www.worksright.com , call (601) 856-8337, or e-mail software@worksright.com .

The iSeries Toolbox for Java: GUI-izing Program Calls
by Kevin Vandever


In "Learning Java by Example," Shannon O'Donnell provided some simple Java applications that allowed you to execute PC commands and access spool files from the iSeries. He did this to arm you with new tools, but he also afforded you working code from which you could learn Java. Using the same premise, in this article I will provide you with a Java application to call an iSeries program and display the results on a GUI form. Download it and use it as is, or mold it to fit your needs.
READ MORE>
Exploring iSeries Navigator Application Administration
by Shannon O'Donnell


Now that OS/400 V5R2 has been announced, we can begin calling Client Access Express Operations Navigator by its new name, "iSeries Navigator." For many of us, the majority of the iSeries Navigator GUI is still unexplored territory. And that's a shame, because iSeries Navigator is really a great tool. To help remedy the somewhat universal ignorance of this great tool, we'll continue on with our series of articles that explore some of the great, lesser-known functions of iSeries Navigator.
READ MORE>
Corrections

  • The article "Learning Java by Example" has been edited since its original publication. The article incorrectly stated that the command java DisplayAS400SpooledFiles should be used to display spool files from the AS/400 on a user's PC, from within a Java application. The command is, in fact, java AS400SpooledFilesDemo. [Correction made 4/25/02]
  • The article "Simplify JSP Applications with JavaBeans, Part 1" has been edited since its original publication. The file CustomerLastNameInstallNotes.txt, contained in the download package, has been edited to include a step in the installation instructions. The first step listed under the "Installation" section in the file now reads as follows:
    1. Update your CLASSPATH environment variable on your PC by adding a path to the servlet.jar package (i.e., c:\Apache Tomcat 4.0\common\lib\servlet.jar). [Correction made 5/1/02]
  • Guild Companies Corrections Policy

    Guild Companies strives to publish accurate information at all times. Minor errors of spelling, punctuation, and the like will be corrected on our Web site without notice. When we correct significant errors of fact or substance, we will note the correction on the page containing the corrected version of the original article, as well as in the next issue of the newsletter.

    If you think Guild Companies has published something in error, please e-mail us at editors@itjungle.com.

    Subscription Information To unsubscribe, change your email address, or sign up for any of Guild Companies's free e-newsletters, visit www.itjungle.com/sub/subscribe.html
    This page is best viewed at 800x600 with Netscape or IE browsers 4 or higher.
     
    Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
    THIS ISSUE
    SPONSORED BY:
    SoftLanding Systems
    LANSA
    ACOM Solutions
    ASNA
    Profound Logic Software
    WorksRight Software
    BACK ISSUES
    TABLE OF CONTENTS
    Creating a VARPG Appointment Calendar
    Dynamic Selection with Embedded SQL
    Validating XML with a Document Type Definition
    The Ins and Outs of Qshell
    The iSeries Toolbox for Java: GUI-izing Program Calls
    Exploring iSeries Navigator Application Administration

    Editors
    Shannon O'Donnell
    Kevin Vandever

    Managing Editor
    Shannon Pastore

    Conributing Editors
    Howard Arner
    Joe Hertvik
    Ted Holt
    David Morris
    Richard Shaler

    Contact the Editors
    Do you have a gripe, inside dope or an opinion?
    Email the editors: editors@itjungle.com