MAGAZINES

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

August 17, 2016 | Volume 15 Issue 16

ISSUE HIGHLIGHTS

LEAD ARTICLE: Using Scope in Linear-Main Programs to Create More Stable Applications
FEATURED ARTICLE: SQL 101: Date-Related Functions, Part 3—Extracting Information from Dates
NEWS HIGHLIGHT: Cilasoft Announces Job Log Explorer
WHITE PAPER: 2016 State of IBM i Modernization White Paper
EVENT: TOMORROW - Using ASNA Mobile RPG to create mobile apps with ILE RPG
USER GROUP CONFERENCE: Omni User Technical Conference 2016

Sponsor - BCD Software
 

What's Possible with IBM i Green Screen Modernization

Recorded Webinar

 

Green screen modernization is about more than improving the look of your applications. This recorded webinar highlights real-world examples of modernized and mobilized screens that have also improved workflows, increased productivity and decreased training costs.

 

Watch this webinar to see:

  • Mobile warehouse application
  • Customer facing order entry application
  • Dashboards and other visual elements
  • Web GUI for new RPG programs

View this webinar!


Read More >>

Feature Article - Programming
 
Using Scope in Linear-Main Programs to Create More Stable Applications

Linear-main RPG programs eliminate the RPG logic cycle and add new levels of variable scoping to protect your code from bugs down the road.

brian mayWritten by Brian May

While I am no expert in the RPG logic cycle, I have had to deal with it in older applications over the years. Most RPG developers have dealt with a logic cycle program at least once. I can honestly say I have never written a new logic cycle program, but I have seen others in the community doing it. This article is not intended to start a religious war about cycle programming. There are some who will never give it up. Instead, this article will demonstrate how to create a program without the logic cycle and concentrate on what I think is a very useful benefit to using linear-main procedures in program.


Read More >>

Sponsor - New Generation Software, inc.
 

Graphical, Web & mobile query and reporting. Make it all happen on IBM i. NGS-IQ enables business users and analysts to write queries that output to Excel, Access, Word, PDF, CSV, TXT, and XML; develop analytical reports; build multidimensional models; and run Web reports with charts and drill down. Modernize your reporting without adding another server or database to your network. Watch an on demand video. Tell us your goals. Request a proof-of-concept or FREE trial. www.ngsi.com. 800 824-1220.


Read More >>

Feature Article - Programming
 
SQL 101: Date-Related Functions, Part 3 - Extracting Information from Dates

This article continues the date-related functions discussion, introducing a few more simple but extremely useful SQL functions: DAYOFWEEK, WEEK, QUARTER, DAYOFYEAR, and MIDNIGHT_SECONDS. Do you have time for some date fun?

rafael victoria preiraWritten by Rafael Victória-Pereira

Let me start with a quick flashback: an RPG Academy TechTip published in October 2015, explaining how to create an RPG function to calculate the day of the week of a given date stirred things up quite a bit. Some readers complained this kind of function was totally unnecessary, because SQL is better equipped to do this type of thing and so on. My reply was that I’d get to a point in the SQL 101 series in which I’d cover the “SQL version” of that particular function, named Clc_DayOfWeek.


Read More >>

Sponsor - The MC Press Bookstore
 

One Book Gets You There!

Ace exam 312 with the latest DB2 certification study guide from MC Press. One book gives you all you need to know about the core DB2 11 for z/OS topics. Author Susan Lawson—who also helped develop exam 312—introduces DB2 11 for z/OS and gives you a comprehensive review of database design and implementation, applications and database functionality, environment management, data management, and more! Features 90 practice questions & answers. Order your copy today.


Read More >>

MC White Paper Center
 

Choose one or more of these recently added downloads in our MC White Paper Center

 

Element Break

3 Compelling Drivers for Implementing an HA Solution on an IBM i Cloud with MIMIX

1. Affordable Cloud Solutions

2. Efficiencies of MIMIX

3. Rising Cost of Downtime

This white paper is a collaborative effort between Connectria Hosting, a pioneer in the development of the IBM i Cloud, and Vision Solutions, the leader in High Availability and Disaster Recovery solutions including MIMIX®, the standard for complete, scalable HA/DR protection for the IBM i.

It will provide a review of the core causes and costs of both planned and unplanned downtime and will then provide a detailed discussion of current options for IBM i High Availability and Disaster Recovery in the Cloud.

Most importantly, as you read you will learn why true HA and DR protection are now within reach of even the smallest of businesses.

 

Element Break

2016 State of IBM i Security Study

Drawing participants from healthcare, communication, transportation, finance, and many other industries, the 2016 State of IBM i Security Study analyzed 177 servers and partitions. Now in its 13th year, the study provides compelling insight into security weaknesses affecting many IBM i systems. Some of the most dangerous defects include:

  • Unmonitored network access
  • Lax system auditing
  • Dangerous default security settings

The alarming results show improperly configured servers where users are allowed to keep default passwords and traffic passes through exit points like FTP and SQL unmonitored.

 

Element Break

2016 State of IBM i Modernization White Paper

After surveying 400+ IBM i professionals, we discovered:

  • The state of IBM i modernization in today's businesses and their goals for the future
  • The effect legacy applications have on the businesses' internal and external processes
  • The #1 concern upper managers have with the IBM i, and how to combat it

...and much much more!

Download your copy of The 2016 State of IBM i Modernization today.

Element Break

DR Strategy Guide from Maxava: Brand New Edition - now fully updated to include Cloud!

PRACTICAL TOOLS TO IMPLEMENT DISASTER RECOVERY IN YOUR IBM i ENVIRONMENT

  • CLOUD VS. ON-PREMISE?
  • COMPREHENSIVE CHECKLISTS
  • RISK COST CALCULATIONS
  • BUSINESS CASE FRAMEWORK
  • DR SOLUTIONS OVERVIEW
  • RFP BUILDER

Download your free copy of DR Strategy Guide for IBM i today.

The DR Strategy Guide for IBM i is brought to you by Maxava – innovative global leaders in High Availability and Disaster Recovery solutions for IBM i.

Element Break

8 Very Good Reasons to Use Your Power i For Shipping

Learn how companies are reducing shipping costs by Centralizing all of their Shipping Systems and Transportation Management Systems (TMS) on One Platform with One Vendor. See how companies deployed an enterprise-wide, multi-carrier shipping solution to manage both their Parcel and Freight shipments directly from their IBM i, and seamlessly integrated it to their back end IBM i ERP and WMS. This Whitepaper examines eight reasons for centralizing standalone shipping solutions on the IBM i. In addition, you will see how a Modular TMS Solution integrated with ERP has driven significant efficiencies and cost reductions in companies shipping and transportation operation.
(USA and CANADA only please!)

Element Break

2016 IBM i Marketplace Survey Results

Now in its second year, HelpSystems surveyed over 800 IBM i users from around the world to produce the IBM i Marketplace Survey Results. The expanded 2016 survey builds on last year’s results to provide even greater insight into the IBM i marketplace.

From manufacturing and retail to finance and healthcare, IBM i professionals from around the world reported their plans and concerns for their IT environments, revealing how IBM i is being used and how it relates to their broader IT objectives.

Download the survey results to see how over 800 of your peers on the platform address:

  • Modernization & mobile applications
  • Hardware & operating systems
  • IT concerns & initiatives
  • Data growth, storage, & security
  • The future of IBM i

Element Break

5 Winning Strategies to Combat Information Overload

Today’s businesses must be available 24/7 with fewer people having to manage more complex systems and processes.

IT departments receive a constant bombardment of information from a diverse variety of operating systems, business applications, and critical processes and support a complex array of servers and devices running across their entire network.

With tight resources and the need to keep costs in check, more and more is expected of IT operational staff to handle this information efficiently. They need to ensure a swift response with appropriate actions, that essential data is received at the right time, prove service levels are maintained, that contingency and high availability strategies are fully operational, and that vital business activities run smoothly and without disruption.

What kind of safety net processes can you put in place so you can combat information overload, yet not miss a single thing, drop the ball, or cause a negative impact on the business—and more importantly, how do you go about it?

Learn how to handle the daily deluge of information and discover five strategies you can deploy to become an IT superhero in your organization.

Element Break

2015 Guide to Manufacturing Software

For all manufacturing industries, growth remains top of mind. Post-recession cautiousness has given way to confidence and more ambitious business goals. From automotive to fashion, more manufacturing leaders are ready to take bigger risks in the hopes of bigger payoffs, and optimism is the highest it’s been in years.

To help manufacturers choose the right software in a rapidly changing industry landscape, this guide will explore four key technologies that are essential to any successful manufacturing operation:

  • Enterprise Resource Planning (ERP)
  • Enterprise Asset Management (EAM)
  • Configure Price Quote (CPQ)
  • Supply Chain Management (SCM)

We’ll discuss the market trends increasing the need for adoption of each technology, provide a “shopper’s checklist” of essential features and functions, and share success stories from real-life industry leaders. This guide will also outline how Infor’s industry-specific software and cloud-based technology are helping global companies thrive.

Element Break

Automate IBM i Operations using Wireless Devices

Download the technical whitepaper on MANAGING YOUR IBM i WIRELESSLY and (optionally) register to download an absolutely FREE software trail. This whitepaper provides an in-depth review of the native IBM i technology and ACO MONITOR™'s advanced two-way messaging features to remotely manage your IBM i while in or away from the office. Notify on-duty personnel of system events and remotely respond to complex problems (via your Smartphone) before they become critical-24/7. Problem solved!

 

Element Break

Plus Choose From The Outstanding Full Selection in our MC White Paper Center

*Some offers may be limited to U.S. and/or Canadian citizens only. Please see the site for details.


Read More >>

In the News

Vendors:  Have a press release to share?  Send it to MC Press.


Read More >>
The Latest from IBM

Read More >>
Support MC Press - Visit Our Sponsors

Forums

Search Sponsor

Search

MC Press Resource Centers

Webcasts

White Papers

Trial Software

 120x90-WOD-MCPOct2015  SB SkyView PPL 5194-120x90  SB HelpSystems ROBOT Generic120x90
Create Amazing, Modern Apps With Profound UI What Authorities Do Programmers Really Need? Easiest Way to Save Money? Stop Printing IBM i Reports
Interested in IBM Power System White Papers, Webcasts and Software solutions? Visit our resource centers today!


Read More >>
   MC-STORE.COM