June 7, 2023
- LEAD ARTICLE: SQL 101: DML Recap: The Two “Flavors” of INSERT
- FEATURED ARTICLE: Programming in ILE RPG - Externally Described Printer Files
- FEATURED VIDEO: A Moment with Carol Woodbury: The Benefits of Authorizations Lists
- NEWS HIGHLIGHT: CEO Matt Hicks On Red Hat Layoffs, IBM’s Open Source Vision
- WEBCAST: Low Code: A Digital Transformation of Supply Chain and Logistics
- EVENT: OCEAN TechCon23 - July 27 - 29, 2023
No, it’s not bitter and sweet or anything like that! INSERT is a very powerful SQL statement that many people don’t take full advantage of. I’m going to explain its two ways of working—its two “flavors” if you will. Keep reading!
By Rafael Victória-Pereira
Most programmers are familiar with the INSERT SQL statement, and some (including me) prefer it to Data File Utility (DFU) because it’s reproducible, controlled, and most important, easy to track. It’s true that you can save all those spool files produced by DFU somewhere, but it’s not easy to re-input data or even reuse inputted data. With INSERT, a simple copy-paste-adjust operation is all it takes to add a second or third record that shares some similarities with the original statement.
In addition to allowing the external definition of database files, ILE RPG lets you define reports externally.
By Brian Meyers and Jim Buck
Editor's Note: This article is excerpted from chapter 3 of Programming in ILE RPG, Fifth Edition.
Externally describing printer files offers many of the same benefits as externally describing database files. In particular, this method lets you change a report format without changing the source code of the program that produces the report—a wise approach to application maintenance. Also, if you externally define printer files, you can use a system utility, such as RDi’s Report Designer, to help you design the report’s layout visually on your workstation. The utility then generates the DDS required to describe the report so you don’t have to do the grunt work of figuring out line position and spacing entries. (Appendix B covers Report Designer in more detail.)
“[Layoffs are] a healthy thing that you have to do every once in awhile to make sure you’re putting investment in the right areas that are going to help you keep being successful with customers,” Red Hat CEO Matt Hicks tells CRN.
By Mark Haranas
Red Hat CEO Matt Hicks sat down with CRN to discuss the company’s recent layoff round, whether any more pieces of Red Hat will be absorbed by IBM, and avoiding cloud lock-ins when it comes to Red Hat’s open hybrid cloud strategy.
Hicks became president and CEO of Red Hat in July and is approaching his eighteenth year with the Raleigh, N.C.-based open-source software superstar.
“When I started [in the CEO role], the thing I really wanted to correct is: know why we’re here, known what we do, be excited about what we do,” Hicks told CRN. “We can’t chase every single battle challenge in technology that’s out there. We’ve got to be laser-focused on that.”
Before jumping into what Hicks had to say about Red Hat laying off about 800 employees and IBM becoming “more comfortable” with open source, it is key to note that the 2023 Red Hat Summit is wrapping up…
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.
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).
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.
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.
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.