fhg
Volume 11, Number 20 -- July 13, 2011
Sponsored By
SEQUEL SOFTWARE


If you're like most businesses, you're in a race for fast, easy access to information. That includes information from multiple databases, like DB2, Microsoft SQL Server, Oracle, and MySQL.

 

The white paper, The Race To Access Enterprise Data, describes the goals you need to achieve and the hurdles you'll face.

 

And, it reveals how quickly and easily SEQUEL can deliver the data you need, in the format you prefer, anywhere.

 

Follow this link to download.



Sponsored By
PRODATA COMPUTER SERVICES

Create your own suite deal!

 

DBU - super easy to use. The leading data access tool on the market.

 

DBU RDB - does the work for you. Analyze data on all your servers. MySQL, Microsoft SQL Server, Oracle, DB2 databases and others.

 

RDB Connect - programmatic access to remote data! Full SQL access to remote databases from all System i high-level languages.

 

Download your free trials NOW.
Order today and SAVE $500!
www.prodatacomputer.com
800.228.6318


Running Totals in an SQL Query, Take 2
by Skip Marchesani

My article, Running Totals in an SQL Query, described how to write an SQL SELECT statement that generated a running total for each row in the result set and provided an example of the SELECT statement syntax to do so. READ MORE >

The DB2 DBA: Identifying Indexes with Shared Access Paths
Hey, Mike:

The SysIndexStat catalog view has the column Owning_Index_Owner (plus schema, system names, etc.). However, that catalog view does not include constraint-created indexes, nor does it include keyed logical and physical files that share the access path owned by an SQL index. The DSPFD command does show the SQL index that owns the access path for such logical files, but I have not been able to generate this information in an outfile format from that command. READ MORE >



Sponsored By
CNX

Ready to develop true Web 2.0 applications?

 

Valence combines state-of-the-art browser components with your favorite business language (RPG) to produce World Class Web 2.0 apps on IBM i.

 

Learn industry-standard techniques for developing real Web 2.0 applications with popular UI features such as grids, forms, trees, pop-up menus, drag and drop, charts, graphs, Excel downloads, and much, much more!

 

Valence Version 3.0 BETA 3 is now available
and includes mobile device support!
Click here for free download.




How Do I Email a PC5250 Screen Shot?
Hey, Joe:

I want to email a PC5250 screen shot. But when I press the Print Screen key, nothing happens. It doesn't copy my screen to the Windows clipboard and I can't paste it into my email. What am I doing wrong? I'm using the PC5250 product that comes with iSeries Access V5R4M0. 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

Cosyn:  Add audit trails to your master files in minutes with Audit Trail/400
PowerTech:  FREE White Paper: PCI Compliance for Power Systems running IBM i
Bytware:  Viruses? You'll Never Know Unless You Scan. FREE Webinar. July 20

 

 

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
Business Is IBM's Middle Name

Lennox Takes CMO Job as Zend Plans for Growth

Gartner, IDC Boost IT Spending Outlooks For 2011

As I See It: An Icy Place Apart

iManifest EMEA Plans Webcast, IBM i Collateral

Four Hundred Stuff
Silvon Re-Emerges with Update to Stratum BI

DR Testing an Integral Part of RES-Q's Services

LaserVault Launches Hybrid Cloud Backup Appliance for IBM i

iWay Detects Business Events in Social Network Feeds

Amazing i Server Survival Story from Australia

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 wants seal busted on HP's Itanium suit

Unemployment rate inches up in the US

ARM daddy simulates human brain with million-chip super

IBM chases Itanium shops with 'Breakfree' deals

Oracle VDI now mates with both Solaris and Linux

Cray stuffs 46 mobile Intel chips into microserver

Chip makers thrive on tablets, e-readers, cars

EnterpriseDB comforts HP-UX shops with PostgreSQL

IBM chases Itanium shops with 'Breakfree' deals

Profit piranhas want a bite of HP

Gartner forecast reinflates IT spending balloon

Intel takes CPU market share from AMD in Q1

THIS ISSUE SPONSORED BY:

SEQUEL Software
ProData Computer Services
CNX



TABLE OF CONTENTS
Running Totals in an SQL Query, Take 2

The DB2 DBA: Identifying Indexes with Shared Access Paths

How Do I Email a PC5250 Screen Shot?

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