February 7, 2018
- LEAD ARTICLE: Practical RPG: NULLs in DDS-Defined Files
- FEATURED ARTICLE: Gifts You Can Give the IBM i Community
- FEATURED ARTICLE: Make Your IBM i Database More User-Friendly
- NEWS HIGHLIGHT: New RPG & DB2 Summit Sessions Help IBM i Developers Achieve Big Goals
- WHITE PAPER: Node.js for Enterprise IBM i Modernization
- FEATURED VIDEO: Design an Invoice in 10 Minutes
- EVENT: TOMORROW - Powerful Cloud Strategies for IBM i CustomersPowerful Cloud Strategies for IBM i Customers
- MC PRESS MAGAZINE: A Small Intro to Big Data, Part 3: HFDS and the MapReduce Algorithm
DDL-defined tables are very good about handling null values, but sometimes we still need to deal with them in DDS-defined files as well; this article shows the RPG techniques required to do that.
By Joe Pluta
When you create a table in SQL using DDL statements, the default is to allow nulls, which means that, for any row, you can populate the column with a null value. Nulls have a number of specific characteristics; you can read about them here. We won't go into those issues in detail, although they can be quite interesting. The issue of nulls in WHERE clauses is particularly fascinating but not relevant to our discussion. Instead, today we're going to see how to support null result values in more-traditional RPG and DDS settings.
This year, why not give a gift to others and contribute to the IBM i community?
By Brian May
It has been quite a while since I wrote about favorite gifts from IBM. A little over a year ago, I wrote gifts to give yourself. Now, in true trilogy form, because the best things come in threes, I am writing the last article in the gifts series. I guess that means I will need a new themed series.
Live Webinar: Make Modern Apps You'll Love with
After surveying 500+ 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 2017 State of IBM i Modernization today.
1. Affordable Cloud Solutions
2. Efficiencies of MIMIX
3. Rising Cost of Downtime
This collaborative effort from Connectria Hostingand Vision Solutions 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.
It's time to make your apps proud to be seen! Whether you have green screens or a drab GUI, your outdated apps can benefit from modern source code, modern GUIs, and modern tools. Alex Roytman and Liam Allan show you how Free-format RPG and Node.js make it possible to deliver apps your business will love.
You'll learn how you can use both Profound UI and Profound.js to: Transform legacy RPG code to modern free-format RPG and Node.js; Deliver truly modern application interfaces with Profound UI; Extend your RPG applications to include Web Services and NPM packages with Node.js.
High availability for IBM i has been a hot topic in 2017, becoming the #2 IT priority just behind cybersecurity. And no surprise with these two topics so closely tied to your most valuable asset: your irreplaceable business data. You must be asking yourself: am I doing everything I can to protect my organization's data? Tune in as our panel of IBM i high availability experts deliver lively discussion around the top high availability issues of today.
Once data is gone, it's gone...unless you have a data replication layer in place to protect it. Learn the value of strategic solutions and how to implement them in a hurry...watch now!
ACO MONITOR is a complete systems management solution for your Power Systems running IBM i. ACO MONITOR manages your Power System 24/7, uses advanced technology (like two-way messaging) to notify on-duty support personnel, and responds to complex problems before they reach critical status.
ACO MONITOR is proven technology and is capable of processing thousands of mission-critical events daily. The software is pre-configured, easy to install, scalable, and greatly improves data center (and staff) efficiency.
Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Why support 5 different products, when you can do it all with MarkMagic?
Here's how to create descriptive table and column names that make DB2 for i easier for end users to navigate
by Rafael Victoria-Pereira
Editor's note: This article is excerpted from chapter 4 of SQL for IBM i: A Database Modernization Guide, by Rafael Victoria-Pereira.
Chapter 3 led us on the first step toward a true database, but it kept most of the hallmarks that make a DB2/400 database very "user-unfriendly": the table and column names are short, in the typical and old-fashioned way of the AS/400. However, end users' demands in regard to data queries have evolved significantly in recent years. The users of our UMADB are particularly data-hungry and are overtaxing the university's IT staff labor resources. This added burden on the IT staff is something that often occurs when you "open up" the database to the end users. The problem is that the database is not always ready to be used by someone not used to short, cryptic names, and this ends up causing additional stress on the IT staff, because it requires additional time…