fhg
Volume 9, Number 13 -- April 15, 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
VISION SOLUTIONS


FINALLY!

 


All i5/OS and AIX data protection and recovery options described in one document!

 


Click here to download this comprehensive 29-page white paper



A Bevy of BIFs: Dealing with a Bad Date
by Susan Gantner

In an earlier tip, I talked about how %Date simplifies our logic by converting our 'date' values stored in numeric or character fields into true dates. In that tip, I mentioned that using %Date could potentially result in an error message in the event your 'date-like' fields contain an invalid date value, such as zero or blank or a month value of 25. READ MORE >

A Bevy of BIFs: %CHAR, %EDITC and %EDITW
by Jon Paris

'I need to convert a numeric value into a character string. How do I . . . ?' READ MORE >



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




Admin Alert: And /QOpenSys and /QOpenSys and /QOpenSys and. . .
by Joe Hertvik

Last month, I wrote about an i5/OS issue involving the AS/400 Integrated File System. When opening the /QOpenSys folder inside the AS/400 IFS, I found a second /QOpenSys entry. Opening that entry revealed another /QOpenSys folder, and then another, and another, until the trail ended 15 /QOpenSys entries later. I passed the problem on to the Admin Alert readership for research. This week I explain what they found. READ MORE >


Reader Feedback: Programming E-mail Notification When a Robot/SCHEDULE Job Fails

I appreciate your recent Robot/SCHEDULE article describing code that users can write to program e-mail notification when a Robot/SCHEDULE job fails. For further clarification, I would like to mention two points. 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: What Do IBM i Developers Want Out of Their ALM Software?
S4i Systems:  Say YES to DASD-Plus. Disk management starting at $350
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
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
Power vs. Nehalem: Time to Double Up and Double Down

The IBM-Sun Saga Continues--Or Rather, Doesn't

Clone Memory Maker Dataram Buys Rival MMB

Lawson Ekes Out Profit in Q3, Partners to Peddle in Quebec

Automation: Monitoring the Monitors Isn't It

Four Hundred Stuff
Fujitsu Introduces RPG to .NET Application Modernization Service

LANSA Adds Refinements to BPI Product

SkyView Adds PCI Checks to Risk Assessment Tool

SPSS Changes Data Miner's Name, Drops System i Support

So Long ASNA--It's BluePhoenix System i Division From Now On

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

System i PTF Guide
April 11, 2009: Volume 11, Number 15

April 4, 2009: Volume 11, Number 14

March 28, 2009: Volume 11, Number 13

March 21, 2009: Volume 11, Number 12

March 14, 2009: Volume 11, Number 11

March 7, 2009: Volume 11, Number 10

TPM at The Register
Big-iron brains powers Schooner appliance power

Dell adds VC hotshot to board

IBM serves System S streaming super

Sun software - Does it make diddly?

Nehalem aces OLTP test on HP iron

Cisco shells out $105m for Tidal

Microsoft puts Sun's Tremblay in SiArch

Novell's openSUSE does ARM Linux

Sun Sparc guru splits for Redmond

Sun revs VirtualBox to 2.2

Double-Take expands beyond server replication

Blade server standards coming this year

Apple plays catchup with Nehalem EP-powered Xserves

Egenera grooms Nehalem EP blades

THIS ISSUE SPONSORED BY:

Help/Systems
Vision Solutions
WorksRight Software



TABLE OF CONTENTS
A Bevy of BIFs: Dealing with a Bad Date

A Bevy of BIFs: %CHAR, %EDITC and %EDITW

Admin Alert: And /QOpenSys and /QOpenSys and /QOpenSys and. . .

Reader Feedback: Programming E-mail Notification When a Robot/SCHEDULE Job Fails

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