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

May 20, 2011 | Volume 8 Issue 20


TOP STORY: TechTip: Boost SQL Performance on DDS Databases
FEATURED ARTICLE: COMMON Certification Program Builds Momentum
NEWS HIGHLIGHT: New Intellichief V3.2 Offers Enhanced Document Management Features
FORUM: Unicode in an AS/400 WMS Package
BUYER'S GUIDE: Maxava HA Enterprise and Barcode 400 
Manage Subscription | Contact Us

Feature Article - Programming
TechTip: Boost SQL Performance on DDS Databases

Did you know that there are PTFs that can give you some 7.1 performance benefits even if you're still on 6.1?

kent_milligan_117x117Written by Kent Milligan

One of the benefits of having a single integrated relational database in the IBM i operating system is that developers can freely mix and match different database interfaces. Database objects created with SQL can be accessed using the native record-level access interfaces. And database files created with Data Definition Specifications (DDS) can be accessed from SQL interfaces. There are a few exceptions, but this interface flexibility holds true most of the time.


Feature Article - Careers
COMMON Certification Program Builds Momentum

After three years of work, the COMMON Certification Steering Committee introduces a second certification exam while work continues on the curriculum.

chris_smithWritten by Chris Smith

When you think of what an education today can cost, those of us who emerged from college with degree in hand two or three decades ago and didn't have to spend the ensuing years paying down student debt were truly fortunate. In fact, the best gift my father ever gave me was my college education, which, despite a little grumbling at the time, was completely covered—as far as I know—out of the regular household budget. Thanks to a lot of hard work over the past three years by a team of dedicated COMMON volunteers, today's savvy IT professionals now have a cost-effective means of differentiating themselves from the rising sea of worldwide job seekers by earning a certification that stands to truly set them apart from the crowd.


MC Showcase Buyer's Guide
Maxava HA Enterprise delivers comprehensive High Availability and Disaster Recovery readiness for your IBM i. Maxava HA Enterprise includes all the functionality of the Maxava HA SMB version along with enhanced replication and tools necessary for more complex environments.


Secure, reliable replication of data, objects, spool files, IFS and MQ Series – Maxava HA Enterprise does it all, along with Command Scripting Function and maxView ; remote monitoring of your HA solution and key IBM i system resources from your web-ready mobile device.


Learn more about Maxava and its high availability and disaster recovery software solutions for IBM i systems here.



T.L. Ashford's award winning BARCODE400 software is the labeling answer for the iSeries. With this versatile and easy to use software you will be designing and printing labels in minutes. Compliance labeling is a snap using templates provide by TL Ashford.

Learn more about T.L. Ashford & Associates and its Barcode and RFID solutions here.


Want to feature your company products? Click here or call (208) 726-6822 for information.


In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor




Business Continuity Today

E-Magazine: Business Continuity Today from Vision Solutions, Inc.


Latest Chapter: Business Continuity Today Ch.11: Is the Cloud Right for You?


Business Continuity Today Ch. 1: Planning for Business Resilience

Business Continuity Today Ch. 2: Security Threats, Trends and Risks

Business Continuity Today Ch. 3: Optimizing Data Availability in Information Hungry Organizations

Business Continuity Today Ch. 4: Compliance and the New Reality for IT Resiliency

Business Continuity Today Ch. 5: Maintaining Availability with Virtualization Technologies

Business Continuity Today Ch. 6: Data Replication: Making Sense of the Options

Business Continuity Today Ch. 7: Recovery: Strategies for Resilience

Business Continuity Today Ch. 8: BCROI: Measuring Returns on Your Business Investment

Business Continuity Today Ch. 9: Making the Green Connection: Ensuring Sustainability and Continuity

Business Continuity Today Ch.10: Disaster Recovery by the Numbers