fhg
Volume 6, Number 33 -- September 13, 2006
Sponsored By
WORKSRIGHT SOFTWARE

Do you need area codes?
Do you need ZIP Codes?
Do you need ZIP+4?
Do you need city or county names?
Do you need a dealer locator system?

 

We can HELP!
We have affordable AS/400 software
and data to do all of the above.
Call us for 30 days FREE.

 

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com


Sponsored By
ITERA


HIGH AVAILABILITY CASE STUDY:

 

When the tornados hit,
TheBANK of Edwardsville was prepared.

 

Spring's balmy 70-degree weather brought several tornados to St. Claire County, Illinois. One powerful storm left dozens of businesses and residents without electricity for nearly a week.

 

While thousands of people were caught by surprise, TheBANK of Edwardsville was not.

 


Read the complete story here.


Developers Don't Despair: Virtualize Your PC
by Michael Sansoterra

Today's developers often wear many hats: programmer, operator, help desk, and database administrator. Furthermore, they often support software on many operating systems (various versions of Windows, Linux, Unix, and so forth) with various versions of application software (Microsoft Office 97 or 2003, ERP clients, and so on) using a variety of developer tools (Visual Studio, Visual Studio .NET, Websphere Development Studio Client, Delphi, and others). READ MORE >

Unusual But Logical SQL Sorting
Hey, Ted:

A physical file that I've loaded with data from another system has a department field that I would like to use for sorting. The department field contains a description, rather than a code. I need to sort the data on the description, but not in alphabetical order. That is, I want a certain department to appear first, then a certain department to appear next, and so on. The only way I know to pull this off is to create a little table that lists the departments and the order each one appears in the sort, but I do not like to clutter up the database with little one-use files. Do you have another idea? READ MORE >




Sponsored By
PATRICK TOWNSEND & ASSOCIATES

Alliance AES/400
Database Field Encryption

· Encrypt credit card, social security, pin numbers and
   other sensitive data.
· Easy to use with RPG or COBOL - sample code included.
· Get compliant - SOX, Privacy notification, GLBA, Etc.
· Free 30 day trial. Fully functional software - Not a demo.

Find out more at www.patownsend.com
Visit us for 30-day trial

Deploy. Run. Manage. Succeed.




Admin Alert: One Common Cure for SQL0901 Package Errors
by Joe Hertvik

The SQL0901 error is an incredibly frustrating error that occurs with i5 ODBC, OLE DB, and JDBC connections. Because SQL0901 is a general SQL error, it can be difficult to diagnose and harder to solve. This week I will look at one specific SQL0901 scenario, where the failure occurs inside SQL's extended dynamic package support, and I will show you how to deal with this error in an i5 environment. READ MORE >



Reader Feedback and Insights

We value your feedback and insights.  Feel free to send a letter to the editor.  Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >


 
Senior Technical Editor: Ted Holt
Technical Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, 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.

 

Sponsored Links

MKS:  Application lifecycle management solutions
California Software:  Migrate iSeries apps to Windows, Linux, or Unix
COMMON:  Join us at the Spring 2007 conference, April 29 – May 3, in Anaheim, California

 


 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement