fhg
Volume 11, Number 11 -- March 23, 2011
Four Hundred Guru is taking a hiatus next week. We will resume publishing on April 6.
Sponsored By
BYTWARE

Viruses? You'll Never Know
Unless You Scan

Thursday, March 24 at 11 am CT

 

Times have changed. In today’s interconnected environments your IBM servers can host and spread viruses and malicious code. There is no way to know if this is happening unless you are scanning with a native solution designed to meet the unique needs of these systems.

 

Learn how to take preemptive measures that will keep your systems, data, and customers safe.

 

Register today!


Sponsored By
PRODATA COMPUTER SERVICES

DBU 9.0 Now Available!

 

        Just when you thought DBU had it all,
        we've added MORE!

 

       New DBUSQL command
       Enhanced Audit Logging
       Execute DBUJRN in batch
       Supports DBCS for Chinese, Korean
         and Japanese
       Wizard-based DBU security set-up

 

        And MORE!

 

Download today!
800.228.6318
www.DoDBU.com


Duplicating an Entire Table or a Subset of a Table Using SQL
by Skip Marchesani

In my previous article, Duplicating CPFY Function Using SQL, I presented three questions that are frequently asked regarding SQL that are interrelated: READ MORE >

No Truncate Table? No Problem!
Hey, Ted:

I am working on a project using DB2 for i, but my experience is with other database management systems. I can't find the SQL TRUNCATE TABLE statement. Does DB2 cover this functionality some other way? READ MORE >



Sponsored By
TWIN DATA CORPORATION

Use all your existing Twinax Terminals and Printers on new System i i5 Power6 & Power5 systems now, and the Power7 when it's introduced.

 

No need to replace your current devices. Just connect the Xip Twinax Controller to Ethernet and your Twinax devices to it, and you will be able to use them with the new Power6 in a pure TCP/IP environment. With the choice of multiple protocols, you can choose what's best for your environment.

 

Perfect for Local or Remote locations.

 

Call us for details on the Xip and a 30-day trial:
1-800-597-2525 Domestic
1-908-855-8100 International

 

www.twindata.com




Automatically Deleting Spooled Files through Expiration Dates
Hey, Joe:

Last year, I stumbled on a cool method for automatically deleting spooled files. When you create a spooled file, you can set the number of days that you want to keep that file on your system. Then once a night, you can submit a job that runs the Delete Expired Spooled Files (DLTEXPSPLF) command that will automatically delete expired spooled files. You should try it. 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
Northeast User Groups Conference:  21th Annual Conference, April 11 - 13, Framingham, MA
looksoftware:  Integrate IBM i apps with web services. FREE on-demand webinar and white paper!

 

 

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
IBM Hikes Maintenance Fees on Power-Based Gear

IBM, Oracle to Build on i Solution Edition Momentum

Calculating the Risks on All Sides of the App Modernization Issue

As I See It: Rethinking the Resolution

IBM to Ride Growth Waves on Current Iron in 2011

Four Hundred Stuff
ExtraHop Adds DB2 to Database Performance-Tracking Repertoire

InterForm Sees New Opportunities in IBM i Forms Management

Early Adopters of Profound UI Pleased

Quadrant Touts Replacement for Withdrawn IBM Domino Fax for i5/OS

Security of SecurID In Question Following Hack of RSA

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
Oracle puts out Solaris 11 compatibility tester

Cray to build huge, grunting 20-petaflop 'Titan' for US gov labs

Intel eyes up HP chief for top job

IBM: Our appliance servers smoke Ellison's 'phony baloney'

IBM accused of bribery in China, South Korea

Cisco shells out first dividend

Supercomputer charts killer tsunami's course

Intel buys Silicon Hive for SoC smarts

IBM tunes up Java for z196 mainframes

US CIOs: IT hires on the rise

GaleForce blows into the cloud

SGI talks Windows on Altix UV

THIS ISSUE SPONSORED BY:

Bytware
ProData Computer Services
Twin Data Corporation



TABLE OF CONTENTS
Duplicating an Entire Table or a Subset of a Table Using SQL

No Truncate Table? No Problem!

Automatically Deleting Spooled Files through Expiration Dates

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