September 6, 2017
• LEAD ARTICLE: Practical SQL: Updating a File Using a Cursor
• FEATURED ARTICLE: RPG Academy: Debug Done Right - Working with Breakpoints
• FEATURED ARTICLE: ILE Service Programs: a Tutorial
• FEATURED NEWS: iTech Solutions' Special Offer for Hurricane Harvey Survivors
• NEWS HIGHLIGHT: IBM Launches Watson Media at the 2017 US Open Tennis Championships
• WHITE PAPER: Node.js for Enterprise IBM i Modernization
• FEATURED VIDEO: NGS-IQ: Serious Fun for IBM i Users - Highlights Version
• EVENT: COMMON Fall Conference & Expo
• MC PRESS MAGAZINE: A Small Intro to Big Data, Part 2: Introducing the Hadoop Framework
SQL isn't just for queries; this article shows you one way to use its update capabilities.
By Joe Pluta
I like to use SQL primarily as a query tool. Its very name—Structured Query Language—sort of leans you in that direction. It's also an excellent tool for set-based updates, as its many proponents will tell you. But there are circumstances under which it would be good to be able to update a file one record at a time via SQL. This is how you do it.
Now that you know how to start a debug session, let’s see how to set and use breakpoints. This is one area where the “new” ILE debugger is way better than the “old” STRDBG.
By Rafael Victória-Pereira
Finding and squashing application bugs can be frustrating and time-consuming. Often, a critical situation exists, and you’re under pressure to resolve the issue quickly and accurately. Familiarity with the navigational debug commands, explained in the previous TechTip, will help a lot during your debugging sessions. Naturally, simply moving through the source isn’t enough. You’ll also need to be familiar with the actual debugging commands. This entails, among other things, adding and removing breakpoints.
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?
Learn how to set up and compile service programs, a key feature of ILE RPG on IBM i
by David Shirey
Editor’s note: This article is excerpted from chapter 9 of 21st Century RPG: /Free, ILE, and MVC.
There is one more type of program structure that I want to introduce you to. And that is a service program: a program that can be called by many other programs and which basically serves as a holder for a variety of sub-procedures.
If you live in the area impacted by Hurricane Harvey or Irma, we hope you and your loved ones are safe. We also wanted to let you know that iTech Solutions is here for you during this time.
If you need technical support, to ask questions during a save or restore, need help on bringing your system back up after the floods subside, LAN Console connection issues, or have a hardware failure that you need help to debug, please give us a call. We will help at no charge. We can even work with you to perform a restore while you tend to other things like your house and family. We can help you with any IBM i System Admin function you need help with.