fhg
Volume 11, Number 9 -- March 16, 2011
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
SEQUEL SOFTWARE


Do you need to create ad hoc queries
or harvest critical information from
IBM i data?

 

Don't feel handcuffed by inadequate query
tools--tackle your data access projects
with SEQUEL.

 

Improve your data analysis and reporting as you learn how to convert query objects into SEQUEL views and distribute the results in dashboards, reports, e-mail, spreadsheets, and more.

 

Follow this link to find out more.



Duplicating CPYF Function Using SQL
by Skip Marchesani

There are a few questions that I am frequently asked re: SQL that are interrelated. First, can SQL be used to duplicate the function found in the native CPFY (copy file) command? READ MORE >

Circumventing Integer Division
Hey, Ted:

My computer seems to have forgotten how to divide. When I divide one value by another, using SQL, the answer is always exactly one or zero. What gives? READ MORE >



Sponsored By
BOTZ & ASSOCIATES, INC.

Free 1-Hour Security Consultation
with Patrick Botz

 

Need advice you can trust on security audits, PCI, HIPAA or SOX requirements, 3rd party software, rational password management, public authority or Security Level 40?

 

Spend an hour with Patrick Botz - FREE - and get actionable info and tips to get you started. Custom, 100% independent advice from the guy who helped architect Power Systems / IBM i security.

 

Click to set up your free session with Pat. World-class security expertise is no longer just for the big guys!




Admin Alert: Corralling i/OS Storage Hogs, Part 2
by Joe Hertvik

Last week, I published part 1 of my series detailing the seven biggest culprits of unnecessary i/OS storage consumption. This week, let's continue with the remainder of my list and see what you can do to keep your storage problems under control. 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

SEQUEL Software:  FREE Webinar: Overcoming query limits with SEQUEL. March 23
SkyView Partners:  The IBM i security compliance provider who does all the heavy lifting
COMMON:  Join us at the 2011 Conference & Expo, May 1 - 4 in Minneapolis, MN

 

 

IT Jungle Store Top Book Picks

BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

The iSeries Express Web Implementer's Guide: List Price, $49.95
The iSeries Pocket Database Guide: List Price, $59
The iSeries Pocket SQL Guide: List Price, $59
The iSeries Pocket WebFacing Primer: List Price, $39
Migrating to WebSphere Express for iSeries: List Price, $49
Getting Started with WebSphere Express for iSeries: List Price, $49
The All-Everything Operating System: List Price, $35
The Best Joomla! Tutorial Ever!: List Price, $19.95


 
The Four Hundred
Wanted: Cloud-i i-nfrastructure

Infor Makes a $1.83 Billion Bid for Lawson

IBM Lays Out Plans for Future Growth and Profits

Mad Dog 21/21: Tablet Vivant, Memories Mordant

Encouraging News on IT Jobs in Q2

Four Hundred Stuff
When Disaster Strikes: Maxava Discusses the Christchurch Earthquake

Chinese Manufacturers Face IT Challenges

DDS Conversion Tool Joins Profound's Web Development Tools

LTO Group Confident in Tape's Future

Station Casinos Makes a Safe Bet with Informatica

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
Cloud Cruiser: Bean counting in the heavens

Calxeda boasts of 5 watt ARM server node

HP squeaks past IBM into number one server seller spot

Cray strides past another $12m DARPA milestone

SGI buys back spun-out Japanese unit

Intel and server buddies forge micro boxes

HP: 'Yes, we're keeping the PC biz'

Super Micro uncloaks dense Westmere-EX server

IBM rides 'third supercycle of growth'

VMware lets Apple fondleslabs tickle Windows VDI

Canonical pares Ubuntu down to 2 editions

Dell juices PowerEdge-C servers with OpenStack

THIS ISSUE SPONSORED BY:

WorksRight Software
SEQUEL Software
Botz & Associates, Inc.



TABLE OF CONTENTS
Duplicating CPYF Function Using SQL

Circumventing Integer Division

Admin Alert: Corralling i/OS Storage Hogs, Part 2

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

Privacy Statement