January 4, 2023
January 4, 2023 | Volume 16 Issue 78
- LEAD ARTICLE: SQL 101: DML Recap—Some Handy Column Functions, Part 1
- FEATURED ARTICLE: Creating and Using Files: IBM Database Concepts
- NEWS HIGHLIGHT: The IBM Ecosystem at Work: How We’re Delivering on Our Vision
- FEATURED NEWS: In the Pursuit to Modernize, a Risk-Based Approach to Security Matters
- WEBCAST: Low Code: A Digital Transformation of Supply Chain and Logistics
- FEATURED VIDEO: Barcode400
- EVENT: Tuesday, January 24, 2023 OCEAN Meeting: SQL Views - Simon Hutchinson
SQL 101: DML Recap—Some Handy Column Functions, Part 1
Now that you’ve learned (or simply refreshed your memory about) joining tables, let’s go over some handy column functions. I believe these will save you a lot of work, so keep reading!
By Rafael Victória-Pereira
SQL’s many functions are incredibly useful and can save you a lot of time. However, they can also be the cause of major headaches, so you need to understand and use them correctly. I’ll go over a few of these functions now and explore a few more later. Let’s start with everybody’s favorite: the COUNT function.
IBM Quantum Computer Demonstrates Next Step Towards Moving Beyond Classical Supercomputing
Programming in ILE RPG - Creating and Using Files: IBM Database Concepts
In this excerpt series, you learn how IBM i handles database files. You also discover the differences between tables and views and between physical and logical files.
By Brian Meyers and Jim Buck
Editor's Note: This article is excerpted from chapter 3 of Programming in ILE RPG, Fifth Edition.
This series examines field reference files and introduces you to the IBM i data types and the storage implications of numeric, character, and date data types. It also covers how to use SQL or DDS to define database files and how to access these files from within RPG programs. In addition, it compares externally described files with program-described files, and it explains externally described device files and how to use DDS to define them.
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.
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).
watch now!
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.
In the Pursuit to Modernize, a Risk-Based Approach to Security Matters
In the pursuit to modernize, financial institutions are finding themselves in an arms race against cybercriminals to defend their digital frontlines from much more bolder and sophisticated schemes. We know the impact of a security breach can be severe in terms of financial cost, reputational damage, and loss of customer trust. However, innovation cannot be stalled with increased market competition as consumers demand faster, more efficient digital experiences. Now the addition of a shifting matrix of regulatory rules that vary across geographies can potentially further slow any progress in the digital transformation journey.
By Nataraj Nagaratnam | CTO, IBM Cloud Security, IBM
In this age of technological disruption, how can financial institutions balance cloud security, industry compliance, and innovation to securely modernize?