fhg
Volume 8, Number 36 -- October 22, 2008
Sponsored By
HELP/SYSTEMS

SEQUEL™ -- IBM® System i™
Business Intelligence Made Easy

 

  · Easy to use by IT and end users
  · Automated data access and display
  · Complete BI package: reports, tables, key
     performance indicators, and dashboards
  · System i-centric for real-time data analysis
  · Multiple interface options: graphical,
     green-screen, browser
  · Expert support and training

 

SEQUEL meets your System i data access and analysis needs.

 

http://www.helpsystems.com/400g


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


Visual Explain for Run SQL Scripts
by Skip Marchesani

The Run SQL Scripts function, a.k.a. the SQL Script Center or Script Center, allows the user to execute all or a subset of a script that contains one or more SQL statements and/or batch CL commands. It is part of the Navigator Database function and is an extremely powerful and flexible tool with lots of function that can have a very positive impact on application developer productivity. READ MORE >

SQL Quickly and Dirtily Extracts a Field from a CSV File
by Ted Holt

A colleague and I were recently tracking the way data progresses through a poorly documented information system. We were trying to determine at which point in the process a certain field's decimal positions were being discarded. We began at the beginning, which happened to be a CSV file from a PC-based system. How could we quickly determine whether or not the CSV file had values in the decimal positions of the seventh field? READ MORE >



Sponsored By
ALDON


Modernize Don't Replace IBM i Applications.

 

Billions of lines of code have been written for crucial business operations from finance to customer relations – all on the IBM i platform.

 

Find out how to modernize them with new graphical user interfaces, high availability, web enablement and more by downloading a free whitepaper from Aldon – Modernizing IBM i Applications for Multi-platform development.

 

Download Here





Healing Failed Windows-i5/OS FTP Transfers
Hey, Joe:

I tried running the attached FTP script to automatically transfer AS/400 Integrated File System (AS/400 IFS) files to a Windows server, but I can't get it to work. I can run my transfer commands manually but not automatically. Can you tell me what I'm doing wrong? 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 Editor: Joe Hertvik
Contributing Technical Editors: Edwin Earley, Brian Kelly, Michael Sansoterra
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:  FREE white paper: From WDSC to RDi. Making Software Change Easier with MKS Integrity for IBM i
Vibrant Technologies:  The leading source for IBM Power Systems and Upgrades
COMMON:  Join us at the annual 2009 conference, April 26 - 30, in Reno, Nevada

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95


 
The Four Hundred
Some Servers Take a Dive in IBM's Third Quarter

Gartner, Forrester Cut 2009 IT Spending Growth Estimates

Infor CEO Preaches Business Darwinism, Prepares for Hyper Business Future

Mad Dog 21/21: Home Deep Owe

IBM Cuts Disk Prices, Rejiggers Memory and CPU Conversion Prices

The Linux Beacon
Why Blade Servers Still Don't Cut It, and How They Might

Intel Keeps Both Arms Swinging with Xeons, Jabs with Itanium

Microsoft Ponies Up Another $100 Million for Novell Linux

Mad Dog 21/21: Newtonian Economics

Two More Xeon-Based Galaxy Servers from Sun

Four Hundred Stuff
Is Java the AS/400's Final Lifeline?

AquaFold Adds DB2/400 Support to Database Tool

Infor ERP LX Adds Compliance and Language Features, SOA Enablement

Shield Gets Closer to Full HA with RAP 3.1

IT Chiefs Don't Care About Software Quality, Survey Says

Big Iron
For Some Customers, the Mainframe Is Green

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
October 18, 2008: Volume 10, Number 42

October 11, 2008: Volume 10, Number 41

October 4, 2008: Volume 10, Number 40

September 27, 2008: Volume 10, Number 39

September 20, 2008: Volume 10, Number 38

September 14, 2008: Volume 10, Number 37

The Windows Observer
Citrix Addresses Performance with XenApp 5

Server Buyers Shop Like It's 1999 in the Second Quarter

Intel Keeps Both Arms Swinging with Xeons, Jabs with Itanium

Mad Dog 21/21: Newtonian Economics

Microsoft Does Something About Those SQL Injection Attacks

The Unix Guardian
What the Heck Is the Midrange, Anyway?

Overseas and Notebook Sales Offset Printer Declines for HP in Q3

Two More Xeon-Based Galaxy Servers from Sun

Mad Dog 21/21: Newtonian Economics

Intel's Nehalems to Star at IDF, AMD Pitches Shanghai

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
Aldon



TABLE OF CONTENTS
Visual Explain for Run SQL Scripts

SQL Quickly and Dirtily Extracts a Field from a CSV File

Healing Failed Windows-i5/OS FTP Transfers

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Data Queues vs. MQ Series: Performance

Removing blanks from a CL Variable

XML

SQL "Hidden" Field

Java Messages

MQ Help Desired





 
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