fhg
Volume 9, Number 20 -- June 17, 2009
Sponsored By
PRODATA COMPUTER SERVICES

Simplify your iT!

 

DBU - super easy to use. The leading data access tool on the market.

 

DBU RDB - does the work for you. Analyze data on all your servers. MySQL, Microsoft SQL Server, Oracle, DB2 databases and others.

 

RDB Connect - programmatic access to remote data! Full SQL access to remote databases from all System i high-level languages.

 

Download your free trials NOW.
Order today and SAVE $$$!
www.prodatacomputer.com
800.228.6318


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


V6R1 Run SQL Scripts: Saving Scripts to a System i Source File
by Skip Marchesani

V6R1 brings some nice enhancements to Run SQL Scripts—which is part of the Database function in System i Navigator--that provide more function and make it easier to use. One of these V6R1 enhancements is the ability to save, and retrieve or open an SQL script to/from a System i source file, in addition to saving it to a PC or a stream file. READ MORE >

A Testing Tip
by Ted Holt

One of the annoyances of maintenance programming is that testing a program change often takes longer--even several times longer--than the process of making the change. One impediment to testing is the inordinate amount of time required to load a test database with the data appropriate for a good test. In the following paragraphs, I share a simple tip that in some situations reduces the effort to establish a good test environment. READ MORE >



Sponsored By
CNX

Don't settle for screen scraping
your way to the web. . .

 

Give your RPG programs
a true Web 2.0 Interface!

 

Valence offers RPG Programmers
a genuine Web 2.0 solution for the System i,
combining simple ILE RPG procedures
with a robust JavaScript framework
to create dazzling applications for your users.

 

See video demos of Valence
and download a free 90-day trial




Admin Alert: A Simple Save While Active Backup Program
by Joe Hertvik

The problem with 24x7 environments is that it's difficult to make time to run complete system backups. Modern processing needs dictate that you can rarely, if ever, take down your machine to back up the entire system. This week, I'll look at a hybrid backup scheme that lets you achieve the dual goal of performing occasional full system backups while still saving all your critical system and user data. 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: Erwin 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

New Generation Software:  FREE Query Migration Planning Webinar, June 25, 2 p.m. EST
Fujitsu PROGRESSION:  RPG to .NET. . . Smart move made simple
CNX:  Valence is bringing Web 2.0 to System i. Download a FREE 90-day trial

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.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 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
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95


 
The Four Hundred
Infrastructure Business Monopoly

Power6+ Blade Performance: IBM's Competitive Analysis

PowerVM Hypervisor Gets Active Memory Sharing

Mad Dog 21/21: Playing For Keeps in Peoria

CIOs Cut IT Spending 5 Percent in Q1, Gartner Says

Four Hundred Stuff
Crossroads Pushing VTL Solution to System i Customers

IBI Updates WebFOCUS BI Platform

Micro Focus Consolidates Legacy Code Modernization Solutions

xTuple Opens an Online Store for ERP Extensions

QlikTech Continues BI Industry Leadership with QlikView 9

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

System i PTF Guide
June 13, 2009: Volume 11, Number 24

June 6, 2009: Volume 11, Number 23

May 30, 2009: Volume 11, Number 22

May 23, 2009: Volume 11, Number 21

May 16, 2009: Volume 11, Number 20

May 9, 2009: Volume 11, Number 19

TPM at The Register
EMC pushes services for virtual servers

HP servers still half-cold to Ubuntu

IBM churns up CloudBurst clouds

Cisco California pricing revealed

Sun's top brass get golden parachutes...

Voltaire punts monster 10 GE switch

Web servers get 'leccy bill

AMD cooking up low-power, twin server

OpenSolaris ported to ARM chips

AMD claws cash back from Intel

HP serves up cookie sheet servers

Germans fire up 200 teraflop Juropa2 super

Apple tight-leashes 'Snow Leopard' Server

Red Hat goes one louder with Fedora 11

THIS ISSUE SPONSORED BY:

ProData Computer Services
WorksRight Software
CNX



TABLE OF CONTENTS
V6R1 Run SQL Scripts: Saving Scripts to a System i Source File

A Testing Tip

Admin Alert: A Simple Save While Active Backup Program

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
PHP CLI Call

Perl, PHP, and/or ZendCore

batch printing PDF files from RPG program

Using db2_connect in PHP on iSeries

How to return value from CL program?

ADO.NET/IBM.Data.DB2.iSeries/ iDB2Connection

Order by alias names




 
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-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement