FEATURE ARTICLES >>

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 >>
 
Group Profiles in Review

Carol takes a look at the proper use and configuration of group profiles.

carol woodburyWritten by Carol Woodbury

I realized that it's been awhile since I've discussed group profiles, so this article is a review of when to use group profiles and how they should be configured.

Read more >>
 
TechTip: SQL Date and Time Arithmetic

Are you looking for a hands-on approach that provides start-to-finish coverage of database design and SQL

Written by James Cooper

Editor's note: This TechTip is an excerpt from Chapter 6, "Single-Table Queries," of Database Design and SQL for DB2 (MC Press, 2013).

 

SQL on IBM i includes expressions and functions for working with date and time values. Externally, date values are character strings containing numbers for the year, month, and day and (in some formats) date separators. When a literal date is entered, the value is coded as a string. The format of the string depends on the values specified for the DATFMT and DATSEP parameters. For example, if *ISO format is specified, the following string represents May 1, 2011:

Read more >>
 
What Change Control Is

Change control: is it a tool or is it an attitude? Maybe it's a little of both.

david shireyWritten by David Shirey

Last month, we talked about some of the myths that seem to surround change management. Now let's take a few moments and talk about what a change control system should be.

Read more >>
 

INDUSTRY NEWS >>

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 >>
 
IBM Tivoli Storage Productivity Center V5.2.5

IBM Tivoli Storage Productivity Center V5.2.5 boosts storage intelligence with improved alerting and Elastic Storage support.

Read more >>
 
IBM API Management V4.0

IBM API Management V4.0 helps organizations manage a single API catalogue for developers to use with their mobile and web applications.

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 >>

Tue Mar 03 @13:00 - 02:00PM
Outperforming Tape: Faster IBM i Backups with Fibre Channel
Tue Mar 03 @21:00 - 11:00PM
Meetup for Zend Framework
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 >>

FLASH SALE!

50% OFF Sale Price

RPG TNT

Promo Code

"FLSA5120"

 

Flash Sale Ends

February 27 at Midnight

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

 

FLASH SALE!

 

Take an EXTRA 50% OFF the Sale Price of

 

RPG TNT
101 Dynamite Tips 'n Techniques with RPG IV

 
Now just $9.98
  

Enter the Promotional Code "FLSA5120" at Checkout
Sale Ends February 27 at Midnight

Element Break

eBook Special >>

 

 

Shop the MC Press Store