MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

March 30, 2012 | Volume 9 Issue 13


TOP STORY: The CL Corner: Introducing the New Run SQL Command
FEATURED ARTICLE: Get Your Free Zip and Security Monitoring Tools
ADVERTORIAL: Partner TechTip: Complete Your IBM i Development Toolset
NEWS HIGHLIGHT: Vision Solutions Announces Single-User Interface Availability and DR Solutions for IBM Power Systems
EVENT: AIX File Transfers--Automation and Security Without Scripting
MC STORE: Top 10 Best-Selling Titles
Manage Subscription | Contact Us

Feature Article - Programming
The CL Corner: Introducing the New Run SQL Command

Would you like some SQL with your CL?

bruce_viningWritten by Bruce Vining

It would appear that thank-you cards to family members of the IBM CL SQL development teams might be in order as these IBM developers seem to be putting in lots of overtime—and not getting home very often.


Last month, in "New Support for CL Commands Lets You Know When a Command Ends," we reviewed how IBM has provided PTFs to V5R4, 6.1, and 7.1, allowing an exit program to be called when the command processing program (CPP) of a CL command completes. IBM is now providing new CL support for SQL as part of the next DB2 PTF groups. The planned availability for 6.1 is May 4 and for 7.1 is May 11. These PTFs provide a new CL command: Run SQL (RUNSQL).


Feature Article - Security
Get Your Free Zip and Security Monitoring Tools

This simple zipping tool supports multiple encryption formats seen as essential today for safe file transfers.

chris_smithWritten by Chris Smith

Ever since IBM began providing native support to the Linux kernel in a logical partition on the iSeries back in 2000, the option of running open-source software has been a powerful testament to the increasingly open nature of what had been a proprietary platform. The trend toward open-source applications has accelerated since then, but the journey has not been without challenges.


Advertorial - Help/Systems
Partner TechTip: Complete Your IBM i Development Toolset

ABSTRACT for RDP is the missing piece in your development puzzle.

mike_stegemanWritten by Mike Stegeman

Whether you're writing new software applications or updating existing ones for your IBM i server, you need an integrated set of cross-referencing, documentation, and programming tools to manage these projects—tools that help you find critical information quickly, automate tedious tasks, and save you time, effort, and money.


In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor