FEATURE ARTICLES >>

Practical SQL: Partitions and MERGEs

Updating one file from another in SQL has been messy in the past, but this technique makes it a lot easier.

joe plutaWritten by Joe Pluta

One of the big advantages of SQL is the fact that you can add columns to a table without worrying about the underlying access; columns that aren't used are simply ignored in the SQL client programs. However, once you have added that column, the next trick is to populate the column correctly.

Read more >>
 
RPG Academy: BIF Up Your Code! More Excel-like Functions with %XLATE

There's more to string operations than splitting and stitching. Curious? Keep reading.

rafael victoria preiraWritten by Rafael Victória-Pereira

Something as trivial as changing the case (from lowercase to UPPERCASE, for instance) of a string can be a challenge in RPG, because unlike SQL (and MS Excel), RPG doesn't have a change case function. So let's build one, using yet another BIF: %XLATE.

Read more >>
 
TechTip: Store and Parse JSON Data Natively with DB2 for i

Learn how the latest DB2 for i features can reduce development time when interacting with the popular JSON data format.

Written by Michael Sansoterra

In my prior tip about using JSON with DB2 for i, I articulated a method of accessing JSON with SQL by use of Java external user-defined functions (UDFs) that convert JSON to XML and XML to JSON. Starting in IBM i 7.1 TR10 (Database Group PTF Level 34) and IBM i 7.2 TR2 (Database Group PTF Level 5), IBM has added native JSON support to the DB2 for i database engine. Keep in mind that, at this first release, the JSON support is still considered a "technology preview," so be sure to test any JSON implementations carefully before using them in production. Also, based on available documentation, some of these features and JSON functions are not yet advertised by IBM for the IBM i and may be subject to change.

Read more >>
 
TechTip: Wizard Analytics on DB2 Web Query, Part 1

Business analysts, developers, administrators, and even non-technical individuals can get started generating sophisticated reports and visualizationsover their own datain minutes!

kathy steinbrinkWritten by Kathy Steinbrink

IBM DB2 Web Query for i is an analytics tool for modernizing Query/400 reports and delivering analytics to the web or mobile devices. It's a web-based Business Intelligence (BI) solution for visualizing, analyzing, and sharing critical business data. Available since 2007 on the IBM i platform, DB2 Web Query has delivered through the years a steady heartbeat of new function.

Read more >>
 
What's Hot: Secure File Transfers on IBM i. What's Not: FTP

Organizations must rethink how file transfers are secured and controlled within the organization.

bob luebbeWritten by Bob Luebbe

Every day, millions of files are transmitted around the world by corporations, government, and other organizations. These electronic transfers include the critical data needed to conduct business, such as customer and order information, EDI documents, financial data, payment information, as well as employee and healthcare information.

 

File Transfer Protocol (FTP) has been used for decades to transmit vital information, but this popular protocol has serious security risks that should not be ignored.

Read more >>
 
The Benefits of a Strong Security Implementation…Beyond Security

Carol explains the benefits of implementing the features of IBM i security…beyond the obvious security-related benefits.

carol woodburyWritten by Carol Woodbury

While the benefits of using the integrated features of IBM i security are obvious—confidentiality of data, data integrity, fully audited, etc. —benefits beyond the obvious exist. Let's take a look.

Read more >>
 

INDUSTRY NEWS >>

IBM BigInsights on Cloud V2.0 Delivers Enterprise-Grade Hadoop Service

IBM BigInsights on Cloud V2.0 delivers a faster, managed, secure, and enterprise-grade Hadoop service that avoids the cost and complexity of on-premises infrastructure and administration.

Read more >>
 
IBM Performance Management on Cloud Offers a New Component

IBM Application Performance Management Advanced on Cloud, a new component of IBM Performance Management on Cloud, combines the capabilities of IBM Application Performance Management on Cloud and IBM Application Diagnostics on Cloud.

Read more >>
 
Preview: IBM BigInsights V4.1

Preview: IBM BigInsights V4.1 intends to deliver an open source Hadoop distribution with value-added features to help enterprises succeed.

Read more >>
 
IBM InfoSphere Streams V4.0

IBM InfoSphere Streams V4.0 offers business agility, application resiliency, and simplicity for IT administrators and developers.

Read more >>
 
OpenLegacy Announces New eSuite Integration Platform and Secured Web Gateway

Enables any core enterprise system to integrate with mobile, web, or cloud via standard APIs.

Read more >>
 
Red Hat Updates Integration Offerings

Red Hat, Inc. announces the release of Red Hat JBoss Fuse 6.2 and Red Hat JBoss A-MQ 6.2, introducing new capabilities to help developers simplify their enterprise application and messaging initiatives.

Read more >>
 
Red Hat Introduces the Red Hat Mobile Application Platform

Red Hat, Inc. introduces the Red Hat Mobile Application Platform, which incorporates technology from the  acquisition of FeedHenry with products from Red Hat's JBoss Middleware and OpenShift PaaS portfolio, and adds new mobile services.

Read more >>
 
IBM Performance Management Portfolio Provides Three New Offerings to Manage Critical Hybrid Workload

IBM Application Performance Management V8.1.1IBM Application Diagnostics V8.1.1, and IBM Application Performance Management Advanced V8.1.1

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

July 2015
S M T W T F S
28 29 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

LATEST COMMENTS >>

RESOURCE CENTERS >>

NEW White Paper

MC White Paper Center

8 Very Good Reasons to Use Your Power i For Shipping

 

MC PRESS STORE >>

NEW BOOK!

FREE-FORMAT RPG IV

 

See the new H, F, D

and P specs in action.

ORDER YOUR COPY TODAY

*******************

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

 

eBook Special >>

 

 

Shop the MC Press Store