Volume 15, Number 09 -- May 5, 2015
Sponsored By

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

For IBM i servers, poor security configuration and missing controls can make a hacker's work easier--and much harder to detect.

The only study focused exclusively on IBM i security found that one-third of systems have more than 100 user profiles with default passwords.

What are best practices for user security?
How would your systems stack up?

Download the study to find out.

Pipelined User-Defined Table Functions In DB2 For i
by Michael Sansoterra

Pipes are a fantastic invention as they are useful for conveying a substance in an efficient and well directed manner. Whether used for transporting sewage, carrying oil, or even bottling a duck (if you're old enough to remember The High and the Flighty Foghorn Leghorn cartoon featuring the Ace Novelty company's Pipe Full of Fun Kit #7); our world wouldn't be the same without them. READ MORE >

Formatting Dates with SQL, Take 2
Hey, Ted:

I am trying to use your FMTDATE SQL function but the system tells me it can't find it. I know FMTDATE is there. Can you help? READ MORE >

Sponsored By

UCG's VAULT400 BaaS Delivers Secure Cloud Backup and DR Solutions

IBM Power8 Servers
IBM i Solution Edition for VAULT400
Supports all platforms and databases
Secure data centers nationwide
Data encrypted and available 24/7
Support excellence, disaster readiness, technology that scales with your business

For a complimentary risk assessment, click here or call UCG at 800.211.8798!

VAULT400 BaaS Intro

Ruby And Existing Databases
by Aaron Bartell

Recently I came across a scenario for a customer where I was asked, How do we interact with our existing DDS-based, composite key, database tables? That's going to be a very common trait of most all IBM i shops using Ruby, and this article will cover some common situations you will come across as you use Ruby to interact with existing DB2 for i tables. 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

Remain Software:  Take control of your software modernization process with TD/OMS and X-Analysis
ProData Computer Services:  SQL/Pro 5.0 - New & Improved! Download today!
United Computer Group:  VAULT400 BaaS delivers secure cloud backup and DR solutions


The Four Hundred
Head Power Sales Honcho Fires Up The IBM i Base

IBM Upgrades High-End And Low-End Power8 Machines

Cautious Optimism Pervades COMMON

As I See It: Cold War 2.0

An Open Letter To IBM From A Developer

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

System i PTF Guide
May 2, 2015: Volume 17, Number 18

April 25, 2015: Volume 17, Number 17

April 18, 2015: Volume 17, Number 16

April 11, 2015: Volume 17, Number 15

April 4, 2015: Volume 17, Number 14

March 28, 2015: Volume 17, Number 13

The Platform
Microsoft Stacks Azure Up Against AWS

Microsoft Expands Azure With Data, Fabric Services

Riding The Inevitable Curve From Analytics To Deep Learning

Google Will Do Anything To Beat Moore's Law

Simulating the Next Generation of Quantum Computers

Thoughts And Conjecture On Knights Landing Near Memory

PCI-Express Flash Revamped To Compete With NVMe Drives

Still Shrouded in Stealth, DSSD Proves Early Performance at Scale

Mellanox Makes Interconnect Waves, Then Surfs On Them

Why You Should Give A Damn About Supercomputers

How AWS Is Turning Virtual Iron Into Gold

Dell Strikes First, Cuts Deep With Tomahawk Switches


WorksRight Software
United Computer Group, Inc.

Pipelined User-Defined Table Functions In DB2 For i

Formatting Dates with SQL, Take 2

Ruby And Existing Databases

Four Hundred Guru


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

Privacy Statement