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

INDUSTRY NEWS >>

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 >>
 
IBM PureApplication Software V2.1.0 Enhancements

IBM PureApplication Software V2.1.0 delivers enhancements for an enterprise-strength hybrid cloud, with additional options to bring your own hardware for on-premise clouds.

Read more >>
 
IBM Integration Bus V10.0 Delivers a Comprehensive Integration Solution

IBM Integration Bus V10.0 delivers key enhancements to enable improved developer experience, manageability, cloud, and functional capabilities.

Read more >>
 
IBM MobileFirst Platform Foundation V7.0

IBM MobileFirst Platform Foundation V7.0 delivers enhanced enterprise mobility with a robust and ubiquitous data layer for web and mobile access.

Read more >>
 
Cloud Orchestrator on Cloud Increases Speed and Scale of Service Delivery in Hybrid Clouds via SaaS

IBM Cloud Orchestrator on Cloud provides the following core capabilities:

Read more >>
 
IBM Security Directory Server V6.4 Provides a Highly Scalable LDAP-Based Directory

IBM Security Directory Server V6.4 is designed to offer a very flexible yet highly scalable Lightweight Directory Access Protocol (LDAP) infrastructure.

Read more >>
 
IBM Announces Business Process Manager V8.5.6 and Business Monitor V8.5.6

IBM Business Process Manager V8.5.6 improves quality of service, delivers new federation and mobile capabilities and IBM Business Monitor V8.5.6 supports new operating environments.

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

No events

Events Calendar

October 2018
S M T W T F S
30 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

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