fhg
Volume 10, Number 29 -- September 29, 2010
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


Sponsored By
iSERIES DevCon2010

iSeries DevCon2010
Las Vegas | November 15-17

 

Get all the real-world training you need to:

 

Develop applications with RPG
Develop Web applications with Java, RDi-SOA,
   and Rational
Access and work with System i Data
Manage and maintain your systems to run at
   peak efficiency

 

Get 3 days of IBM i training and
365 DAYS OF VALUE at

www.iseriesdevcon2010.com now!


RPG Sorting and Searching: A 7.1 Update
by Susan Gantner

Back in 2008, I wrote a tip about using SORTA and group fields in RPG to easily sort array data, such as subfile data. Array Data Structures existed back when I wrote the original tip, but SORTA was not supported at that time. So I was forced to use the less-than-obvious group fields technique described in that tip. With new support in RPG 7.1, things have changed, so I'm revisiting the example with an updated look. READ MORE >

CASE Simplifies SQL Update
Hey, Ted:

I need to run a series of similar updates against 12 groups in a very large physical file (millions of records). Is there a way I can combine the updates into one SQL update command? I'd rather have the system read the file once, not 12 times. READ MORE >



Sponsored By
inFORM DECISIONS

Go Paperless & Save
You can deliver vital reports, checks and forms faster AND save big money with inFORM's paperless & web-based document solutions.

 

inFORM Decisions' iDocs suite eliminates the cost of paper from AP, customer service, sales & more for fast ROI. In no time you can:

 

    Generate electronic forms, checks, reports,
      PDFs directly from System i spool files
    Intelligently route via email, fax, printer
    Provide secure browser-based access to
      docs from anywhere in the world, 24x7

 

Go paperless today - affordably - with iDocs.
Learn more & get free white papers here.




Feeding the Auditor: Taking Care of Problem User Profiles
Hey, Joe:

Help. My iSeries shop is being audited. The auditors want a list of all users who have default passwords. They also want us to automatically disable any user profiles that haven't been active for 60 days. I don't want to automatically disable my inactive users because I have a lot of profiles that should never be disabled on our system. How do I handle this? I'm on i/OS V5R4M5. 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

PowerTech:  FREE Webinar! Reduce the Cost and Effort of IBM i Auditing. Sept. 29, 10 a.m. CT
LANSA:  2010 iPulse Survey. Taking the pulse of the IBM i market. Get a chance to win an iPad!
COMMON:  Join us at the Fall 2010 Conference & Expo, Oct. 4 - 6, in San Antonio, Texas

 

 

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 720: Same Entry Price, But More Room to Grow at Less Cost

Microsoft Technologies Gaining Ground in the IBM Midrange

IBM Offers Sun, HP Shops Generous Leases--What About iSeries Shops?

As I See It: Of Better Jobs and Billy Joel

Oracle Gets Systems Design, and Starts Proving It

Four Hundred Stuff
Software Vendors Adapt to the Social Media

Q1 Labs Adds IBM i, Social Media Monitoring to SIEM

JDE Fulfillment App Efficiently Allocates Constrained Supply

Big Blue and Brown: Varsity and UPS Join SAP in Partnership

ASG Revs Job Scheduler, Which Supports IBM i

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

System i PTF Guide
September 25, 2010: Volume 12, Number 39

September 18, 2010: Volume 12, Number 38

September 11, 2010: Volume 12, Number 37

September 4, 2010: Volume 12, Number 36

August 28, 2010: Volume 12, Number 35

August 21, 2010: Volume 12, Number 34

TPM at The Register
Orange sells infrastructure nuageux based on Vblocks

IBM eats Blade Network for switches

HP purges Cisco gear from data centers

HP gooses Integrity server virt with PA-RISC emulation

AMD chops Q3 sales forecast

IBM punts first z196 mainframes

NextIO squeezes Nvidia GPUs into super-dense package

Yahoo! opens chicken coop data center

Red Hat revenues bulge 20%

Power Assure revs data center power control wares

Startup takes WAN optimization to the clouds

Server makers leap on GPU bandwagon

THIS ISSUE SPONSORED BY:

WorksRight Software
iSeries DevCon2010
inFORM Decisions



TABLE OF CONTENTS
RPG Sorting and Searching: A 7.1 Update

CASE Simplifies SQL Update

Feeding the Auditor: Taking Care of Problem User Profiles

Four Hundred Guru

BACK ISSUES




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

Privacy Statement