Stuff
OS/400 Edition
Volume 2, Number 4 -- February 13, 2003
   In This Issue

Less Theory. More Hands-On Programming, Advice, and Code.

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 http://www.RPGAlive.com
to find out more.

Sponsored By
TEAMSTUDIO

FREE Web-to-Host Tool Evaluation!

Take Teamstudio Screensurfer for a FREE test drive! Discover firsthand how this host integration tool enables Web developers to quickly and easily integrate host systems with robust Web applications. Screensurfer is easy to install and activate, and works with all popular application servers.


To sign up for your free test drive,
click here:
www.teamstudio.com/screensurferms

iSeries Web Services Revolve on Free Axis
by David Morris

The number of companies exchanging data through Web services is growing, and XML-based Simple Object Access Protocol (SOAP) has emerged as the standard that enables those exchanges. You can write code to build and send SOAP messages yourself, but a better option is Apache Software Foundation's Axis, which is part of the Jakarta project. Axis is an open-source Java package that uses SOAP and provides client and server support that makes it easier to build applications that exchange data through Web services. READ MORE >

Implementing Referential Constraints in Referential Integrity
by Jim Coker

In my last article, "Referential Integrity: Ensuring Your Database Contains Only Valid Data," I discussed the different concepts involved in Referential Integrity. In that article, I reviewed the two types of constraints available in RI: a "referential" constraint, in which a column in a table is verified to be consistent with a column in another table, and a "check" constraint, in which a column in a table is verified to be consistent with a hard-coded value or the value of another column within that same table. READ MORE >

Sponsored By
ESKER SOFTWARE

How much IBM® host access security and performance can you get for $50? All the power of SmarTerm® by Esker.

SmarTerm 3270/5250 gives you a proven, full-featured solution designed for secure host access in AS/400® iSeries™ and IBM mainframe environments. This is the same emulation solution trusted around the world for two decades-only $50 USD for new licenses! See why so many organizations choose SmarTerm for IBM host access.

Click http://www.esker.com/howmuch now to request a FREE SmarTerm 3270/5250 info kit and evaluation CD.

Sponsored By
WORKSRIGHT SOFTWARE

Need to verify Cappahayden Newfoundland Canada has a postal code of A0A 1S0? Need to retrieve the city and province for Canadian postal code A0A 1X0?

WorksRight Software, Inc. can help. Our CPC System contains all 775,000+ Canadian postal codes and matching city and province names. We provide area codes, lat/lon and time zone. Yearly subscription has monthly updates and unlimited phone support.

Visit www.worksright.com to learn about CPC and order a 30-day, no hassle, free trial. Or call 601-856-8337.

We'll be glad to answer all your questions.

Printing from Qshell
by Ted Holt

If you have used Qshell much at all, you have probably stumbled upon one of its limitations: that it cannot write to a printer file. I like Qshell, but I don't like that limitation, so I decided to do something about it. I wrote an RPG program to read the standard input file and write to printer file QSYSPRT. I named my program report. READ MORE >

Prompting iSeries Commands: A Closer Look
by Kevin Vandever

In "Prompting iSeries Commands in Java," I provided a technique for prompting and running iSeries commands from Java using the iSeries Toobox for Java. If you had a chance to check out the code you may have noticed that it was rather simple and pretty high-level. You also may have noticed that, "out of the box," the help text didn't work. In this article, I'll not only show you how to add the help function to your application but also explain a little of what's going on behind the scenes. READ MORE >



ASNApalooza Contest Winner Announced!

OS/400 programmer Richard Brown is about to find out what it's like to program in the Microsoft .NET environment. Next month, in San Antonio, Brown will attend ASNApalooza, the best place for OS/400 programmers to learn about Microsoft's .NET, Visual Studio environment, and database connectivity.
During the month of January, Guild Companies and ASNA cosponsored the educational gateway leading up to the conference, scheduled for March 5 through 7. Brown, of Reno, Nevada, was randomly chosen from a list of Guild Companies newsletter subscribers who expressed an interest in the free educational opportunity. He has attended ASNA's annual users conference in the past but had not planned to attend this year because of budgetary cutbacks.
Much of the 2003 ASNApalooza will focus on the underpinnings of .NET, and what it offers OS/400 programmers, through using ASNA Visual RPG. ASNA Visual RPG for .NET is an RPG development environment for the .NET platform. ASNApalooza session topics include XML, DLL, SQL, .NET coding exercises for Windows and the Web, and browser-based user interfaces. Click here for more information on ASNApalooza.


Reader Feedback and Insights

Readers respond to "Back To Basics: The Date Data Type" . . . READ MORE >



Editors: Shannon O'Donnell, Kevin Vandever
Managing Editor: Shannon Pastore
Contributing Editors: Howard Arner, Raymond Everhart,
Joe Hertvik, Ted Holt, David Morris
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Subscription Information: To unsubscribe, change your email address, or sign up for any of Guild Companies' free e-newsletters, visit www.itjungle.com/sub/subscribe.html

THIS ISSUE
SPONSORED BY:

Profound Logic Software
Teamstudio
Esker Software
WorksRight Software


BACK ISSUES

TABLE OF
CONTENTS
iSeries Web Services Revolve on Free Axis

Implementing Referential Constraints in Referential Integrity

Printing from Qshell

Prompting iSeries Commands: A Closer Look







Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.