February 1, 2023
February 1, 2023 | Volume 16 Issue 79
- LEAD ARTICLE: Practical SQL: Who Deleted My Program?
- FEATURED ARTICLE: Creating and Using Files: SQL Database Concepts
- NEWS HIGHLIGHT: Businesses Plan to Invest in Tech in 2023, Despite Economic Headwinds
- FEATURED NEWS: IBM Report Details Steps to Secure Data for Quantum Era
- WHITE PAPER: Why Migrate When You Can Modernize?
- EVENT: iCON - WMCPA Spring Conference 2023
Practical SQL: Who Deleted My Program?
Use the DISPLAY_JOURNAL table function on QAUDJRN to answer a very common question.
By Joe Pluta
An area I deal with regularly is change management. We promote programs from a development machine to a production machine, and one of the regular tasks is to make sure those objects are in sync, which requires comparing objects across machines. In an upcoming article, I’ll show how I compare existing objects using the OBJECTS_STATISTICS table function and the BOUND_MODULE_INFO view, but for this article I want to address the problem when a program that should be there simply isn’t.
ChatGPT recommends a VTL for backup; LaserVault ViTL meets the challenge
Creating and Using Files: SQL Database Concepts
You may already be familiar with Structured Query Language (SQL), an industry-standard language for defining, accessing, and manipulating a database.
By Brian Meyers and Jim Buck
Editor's Note: This article is excerpted from chapter 3 of Programming in ILE RPG, Fifth Edition.
The IBM i operating system uses SQL to create database objects, and ILE RPG programs can incorporate SQL statements to access and update data. The IBM i database principles correspond to SQL standards, but they predate SQL. Consequently, the system also uses an alternative tool, Data Description Specifications (DDS), to define and create database objects. Additionally, IBM i employs DDS to create device files, which SQL does not address.
Why Migrate When You Can Modernize?
Explore the main considerations you should be aware of before embarking on a (migration or modernization) project. Take a deeper dive into business motivations and factors that could potentially influence your decision to migrate or modernize your existing IT platform and its risks.
More than ever, there is a demand for IT to deliver innovation.
Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects.
The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the companyare not aligned with the current IT environment.
Get your copy of this important guide today!
Node Webinar Series Pt. 1: The World of Node.js on IBM i
Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.
Part 1 will teach you what Node.js is, why it's a great option for IBM i shops, and how to take advantage of the ecosystem surrounding Node.
In addition to background information, our Director of Product Development Scott Klement will demonstrate applications that take advantage of the Node Package Manager (npm).
Low Code: A Digital Transformation of Supply Chain and Logistics
Learn how businesses leverage Low-Code to continue to deliver value through digital transformation. Discover how the power of Low-Code is helping many businesses evolve their supply chain, increase ROI, and achieve more tangible results.
Watch this webcast now.
Easiest Way to Save Money? Stop Printing IBM i Reports
The thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing.
Manage your reports with the Robot Report Management Solution.
Rerun another report? Never again. Try the Robot Report Management Solution FREE for 30 days.
Comply in 5! Well, actually UNDER 5 minutes!!
TRY the one package that solves all your document design and printing challenges on all your platforms.
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.
IBM Report Details Steps to Secure Data for Quantum Era
As quantum-powered cyberthreats loom closer, experts outline a plan of action
By IBM Corporation
The IBM Institute for Business Value (IBV), IBM’s thought leadership think tank, has published its Security in the Quantum Era report. This in-depth analysis of the quantum security landscape unveils the need for “quantum-safe” strategies today to maintain the integrity and security of highly sensitive data in the future. Additionally, the report maps out a clear path as to how organizations can work across their ecosystem to protect data from cybercriminals tapping into the power of quantum computers.