FEATURE ARTICLES >>

Practical SQL: DB2 at Home, Part 3, Using XML Data

 

Now that we have XML data, it's time to learn how to use it.

 

joe plutaWritten by Joe Pluta

 

In previous articles (parts 1 and 2), we began to explore DB2's pureXML capabilities. While DB2 provides exceptional XML data-handling, it's not enough to simply be able to store and retrieve XML data. In any real world business application, you'll also need to integrate that XML data with your existing relational data. This article shows how to do just that.

Read more >>
 
RPG Academy: BIF Up Your Code! More on Moving MOVE and MOVEL out of Your Code

Understanding how to use the EVAL op code and the %CHAR, %EDITC, %EDITFLT, and %EDITW BIFs will help you remove even more of those MOVE and MOVEL statements from your code.

rafael victoria preiraWritten by Rafael Victória-Pereira

One of MOVEL's many uses is the implicit data type conversion from numeric to character. You probably have quite a few of these conversions in your code and don't even realize it. While they're not as error-prone as the reverse operation, it's preferable to have a more controlled conversion, especially because many of these operations are part of something that the end-user will seeeither a message on the screen or a line on a printout, for instance. As usual, there are several ways to do this.

Read more >>
 
In the Wheelhouse: Thoughts After My POWER8 Upgrade

After an upgrade, it's important to reflect on the change and compare your new environment with the old.

steve pitcherWritten by Steve Pitcher

SSDs and HMCs are my new must-have.

 

We migrated from a pair of Power Systems 720s to new Power Systems S814s in January. For this upgrade, we altered our environment a few different ways from how we traditionally set it up.

 

The biggest change that affected mindset was the addition of a Hardware Management Console (HMC).

Read more >>
 
The CL Corner: A More Flexible Interface to the RUNSQL CL Command

In this article, we'll building the SQL request dynamically.

bruce viningWritten by Bruce Vining

In the January 2015 CL Corner, Enhancing WRKQRY Reports the Easy Way, we saw how to create an SQL view for use by WRKQRY using the Run SQL (RUNSQL) CL command. I received quite a few notes asking, among other things, for an example of how to build the RUNSQL SQL parameter using variables rather than the static approach taken in the previous article. So today we'll look at what's required to build the SQL parameter using variables/parameters. For demonstration purposes, we'll continue to use the PROJECTS file that was introduced in the previous article.

Read more >>
 
Book Review: DB2 10 for z/OS: The Smarter, Faster Way to Upgrade

Trying to figure out whether to upgrade? Read on.

kent_milligan_117x117Written by Kent Milligan

Soon after a new version of software is made available to existing customers, it doesn't take long for discussions to arise between the technical and business leadership within a company on when to upgrade. The development teams drool over the productivity and performance benefits offered by the new version while the IT executives fixate on the costs and risks associated with upgrading to the latest software version.

Read more >>
 
Modernization on the IBM i: Getting Started

The only true mistake you can make with regard to application modernization is doing nothing.

brian mayWritten by Brian May

Modernization. Everyone is talking about it. Everyone wants it. But we cannot always agree on exactly what it is. It can mean a few different things, depending on your needs and environment. This of course leads to confusion for those who need it most.

Read more >>
 
Analyzing IBM i Performance Metrics

Editor's note: This article introduces the white paper "Analyzing IBM i Performance Metrics," available free from the MC White Paper Center.

chuck losinskiWritten by Chuck Losinski

In every industry, business-critical processes depend on application performance. Interruption of real-time processing, customer service delays, and missed SLAs and deadlines are all plausible outcomes with all-too-real consequences. Fortunately, IBM i and third-party vendors offer significant power to prevent such disaster.

Read more >>
 

INDUSTRY NEWS >>

Fully Dynamic Multi-Threaded IFS Streaming Is Here

The latest version of Maxava HA is designed specifically to further enhance the handling of high volume IFS data, an area that has caused critical problems for other industry players over the years.

Read more >>
 
DB2 Web Query for i DataMigrator ETL Extension

IBM DB2 Web Query for i DataMigrator ETL Extension provides the ability to extract, transform, and load data for reporting and analytics.

Read more >>
 
IBM Power Systems Miscellaneous Feature Enhancements

Power Systems I/O features enhancements:

Read more >>
 
Kisco Announces New System Monitoring Tool for IBM i

Kisco Information Systems today announces a new system monitoring tool for the IBM i platform.

Read more >>
 
mrc’s On-Demand Webinars Help Businesses Keep Up with Modern Technology

Today, software developer mrc announces the release of their On-Demand Webinar portal. Covering a variety of topics, these free educational webinars help businesses keep up with changing technology.

Read more >>
 
Jordi Marin joins ASNA as Chief Operations Officer to help further ASNA global expansion

Jordi Marin has joined ASNA as its Chief Operations Officer where he will manage its international expansion, work with its distributors and resellers, and direct ASNA's development team.

Read more >>
 
HelpSystems Introduces the Enterprise Process Automation Suite

A unified solution for cross-platform business and IT process automation increases efficiency and control of complex workflows.

Read more >>
 
HelpSystems Announces App Monitoring in IBM i Message Management and Resource Monitoring Software

New features in Robot CONSOLE version 6 allow users to monitor application logs in the IFS, as well as data queues, writers, and MQSeries channels.

Read more >>
 
Magic Acquires IT Professional Services Company Specializing in Mainframe Environments

Acquisition expands and enhances Magic’s AppBuilder solution.

Read more >>
 

VIDEOS>>

Introduction to Configuring iAccess Servers to use SSL

To see a list of all the MC Press videos, click here

UPCOMING EVENTS >>

Thu Mar 05 @13:00 - 02:00PM
Recapture Time & Resources with Document Capture

Events Calendar

March 2015
S M T W T F S
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31 1 2 3 4

LATEST COMMENTS >>

RESOURCE CENTERS >>

NEW On-Demand Webcast

MC Webcast Center

Affordable Query Tool for Software Developers

 

MC PRESS STORE >>

NEW BOOK!

FREE-FORMAT RPG IV

 

See the new H, F, D

and P specs in action.

ORDER YOUR COPY TODAY

Starts Shipping

03/06/2015

WEBCAST

MC Webcast CenterFEATURED WEBCAST

See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

 

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 

 

Watch the Webinar Now!

 

TRIAL SOFTWARE

MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.

   MC-STORE.COM

Latest Offer from the MC Press Bookstore >>

Element Break

NEW BOOK - FREE-FORMAT RPG IV


A must-read for all RPG programmers, featuring completely updated code. See the new H, F, D and P specs in action in this easy-to-use reference guide.

On Sale Now - Save 10%

ORDER YOUR COPY TODAY

Ships 03/06/2015

Element Break

eBook Special >>

 

 

Shop the MC Press Store