fhg
Volume 9, Number 19 -- June 10, 2009
Sponsored By
HELP/SYSTEMS


     SEQUEL
     IBM® System i® Data Access Made Easy

 


  · Complete management access to critical data
  · Easy to use by IT and end users
  · Automated data access and display
  · Comprehensive BI package: reports, tables,
     key performance indicators, and dashboards
  · System i-centric for real-time data analysis
  · Expert support and training

 


Click here for a FREE Information Kit!



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


Configuring Run SQL Scripts for Ad Hoc Queries
by Skip Marchesani

Many months ago, when I needed to create and execute an ad hoc query using SQL, my tool of choice was Interactive SQL, available via the System i green screen interface. I don't recall any dramatic change taking place--I suspect it was gradual--but these days I find myself using Run SQL Scripts (a.k.a. SQL Script Center or Script Center) from System i Navigator, instead of Interactive SQL, to execute an ad hoc SQL Query. READ MORE >

Advanced DB2 for i Data Access Techniques with .NET
Hey, Mike:

There are a lot of shops like mine where one or two people are responsible for everything and we are very busy trying to learn new technologies and push the business forward. My project is very large. It will eventually replace 90 percent of the green-screen menu driven system we currently use. I am working on this project alone and building it slowly from the ground up. READ MORE >





Taking Care of PC5250 Popup Keypad Problems
Hey, Joe:

We just ghosted and sent out 20 new PCs with iSeries Access for Windows V5R4M0 on them. Now we're getting complaints that the Popup Keypads on the new machine's PC5250 display sessions aren't working correctly. On the old PCs, we had three Popup Keypads available to the users. The new PCs only have two keypads and some of the functions are missing. What's going on? 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

Vision Solutions:  New white paper! Review the full range of Data Protection & Recovery options.
BCD:  View the WebSmart PHP YouTube demo direct from the COMMON Expo floor - Free Trial !
Cosyn:  Get a BI 'Proof of Concept' using your own data

 

 

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
With No Power6 QCMs, IBM Waits for Power7

Gartner Confirms Server Sales Were Awful in Q1

Manufacturers to ERP Vendors: Give Us More Functionality

As I See It: Smarten Up

IBM Helps Customers Understand the Cost of Paper

Four Hundred Stuff
ShowCase Essbase 11 for IBM i: It's About Time

WTS Expands Into Managed DR for i OS Apps

SunGard Launches Secure2Disk Online Backup Solution

Help/Systems Supports Windows with i OS-Based Job Scheduler

Pat Townsend Hooks up with Solutionary for Outsourced i Log Monitoring

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

System i PTF Guide
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

May 2, 2009: Volume 11, Number 18

TPM at The Register
Fortune 1000 in California Goldman rush

Dell heading to court over Tennessee factory?

Cray sells Opteron-Linux super to Swiss boffins

US unemployment rate growth slowed in May

Swedish boffins spring for IBM System S super

Cisco promises gold in California rush

Intel paying $884m for Wind River?

Verizon sends compute cloud over US, Europe

Cisco punts not-so-unified rack servers

Tukwila Itanium delay situation still as clear as mud

Xandros - the Linux company that isn't

HP leads pack with Istanbul iron

IBM BladeCenters still touring Shanghai as Istanbul beckons

Gartner: No server growth until 2010

THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
Guild Companies



TABLE OF CONTENTS
Configuring Run SQL Scripts for Ad Hoc Queries

Advanced DB2 for i Data Access Techniques with .NET

Taking Care of PC5250 Popup Keypad Problems

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