fhg
Volume 8, Number 38 -- November 5, 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


OPNQRYF Has No "If" But You Can Fake It
Hey, Ted:

We recently started adding Web customers to our customer master file, in which a customer ID is a field of seven characters. The ID's of Web customers consist of the letter 'W' followed by six digits. Is there any way using OPNQRYF to change only the customer IDs that start with 'W' to the customer number '5000000' for reporting purposes? Doing so would allow us to keep a lot of existing programs running without a lot of modification. READ MORE >

Embed PJL Statements in a Workstation Customizing Object
by Michael Sansoterra

Modern day printers are fabulous in all that they do. In addition to accepting basic ASCII text streams, modern general purpose laser printers usually process either postscript (PS) or printer command language (PCL) streams to generate ornate printouts. So what about using these printers with the IBM i? If the printer understands PCL (or a few other data streams such as IBM's PPDS or Epson FX/LQ), then there is no problem because IBM's host print transform functionality magically converts SCS/AFP spool files into one of the aforementioned data streams that the printer can understand. The host print transform function has made most of my life doing IBM i based printing has been very good--until recently. READ MORE >



Sponsored By
VISION SOLUTIONS


TiVo for Data?

 


Learn more about
the surprising benefits of
continuous data protection (CDP)

 


Click for informative whitepaper.





Admin Alert: Avoiding Restoration Problems with Remote Output Queues
by Joe Hertvik

i5/OS remote output queues are used to send spooled files to printers attached to remote systems. They are commonly created with two objects: the remote output queue itself; and a virtual printer device that allows the queue to function as a locally attached printer device. However, this configuration has some issues when it is restored from backup media, but those problems are easily fixed if you know the right tricks. 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

PowerTech:  Incorporating real-time security events from the System i into a security program
Seagull Software:  Update your System i apps with LegaSuite GUI
COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, 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
Is the Smart Cube the New i?

You Can Still Walk Upgrade Paths with Power Systems i

IBM Sues to Block Server Executive from Joining Apple

The i Gives Manufacturers and Distributors Cost Control

Forrester CEO Weighs In on IT Spending for 2009

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
Seagull Unveils New LegaSuite Reporting Tool

Spectrum Manages 'E-Assets' with SCM Tool

ProData Expands Database Support in DBU

Micro Focus Works on COBOL Standardization, Training

Oracle Launches 'Best Practice Center' for SOA-Enabling JDE EnterpriseOne

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
November 1, 2008: Volume 10, Number 44

October 25, 2008: Volume 10, Number 43

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

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
Vision Solutions



TABLE OF CONTENTS
OPNQRYF Has No "If" But You Can Fake It

Embed PJL Statements in a Workstation Customizing Object

Admin Alert: Avoiding Restoration Problems with Remote Output Queues

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