- You are here:
- Home
- Publications
- MC TNT Tips 'n Techniques
July 12, 2019
Issue Highlights
July 12, 2019 | Volume 14 Issue 37
- LEAD ARTICLE: SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 2
- FEATURED ARTICLE: Top Five Misconfigurations That Leave Your IBM i Vulnerable
- FEATURED NEWS: IBM Closes Landmark Acquisition of Red Hat for $34 Billion; Defines Open, Hybrid Cloud Future
- NEWS HIGHLIGHT: Kisco Announces Update For IBM i System Monitoring Tool
- WHITE PAPER: 2019 State of IBM i Modernization
- MC VIDEO SHOWCASE: Design an Invoice in 10 Minutes
- EVENT: IBM i in 2019: It’s Not Just AS/400
Lead Article - Programming
SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 2
Last time around, I introduced the concept of using an SQL cursor as a way to replace the typical RPG opcodes to access data. Now let’s go deeper and find out where cursors can really help you.
By Rafael Victória-Pereira
The previous TechTip explained what a cursor is and how to declare it. Now let’s see how to use it and, more importantly, why you should consider using it. As I wrote in the previous article, SQL is no match to RPG’s CHAIN. Since I previously showed how to declare the cursor, let’s go over the actual read operations, hidden under the FETCH instruction.
Industry News
IBM Quantum Computer Demonstrates Next Step Towards Moving Beyond Classical Supercomputing
Analytics & Cognitive News
IBM News
IBM Industry News
Feature Article - Security
Carol Answers Her Top 6 Most-Asked Questions
I’m guessing that you’ve asked someone (perhaps even yourself) one or more of these questions.
By Carol Woodbury
I get asked a lot of questions—via email, when I’m presenting at conferences, after my Coffee with Carol article series sponsored by my employer, as well as questions asked in response to these articles, but some questions are asked more often than others. I thought it might be fun to answer the top six most-frequently-asked questions and provide references for additional information. Here we go!
White Papers
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!
Webcast
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.
Trial Software
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.
Featured News - Cloud
IBM Closes Landmark Acquisition of Red Hat for $34 Billion; Defines Open, Hybrid Cloud Future
- Acquisition positions IBM as the leading hybrid cloud provider and accelerates IBM's high-value business model, extending Red Hat's open source innovation to a broader range of clients
- IBM preserves Red Hat's independence and neutrality; Red Hat will strengthen its existing partnerships to give customers freedom, choice and flexibility
- Red Hat's unwavering commitment to open source remains unchanged
- Together, IBM and Red Hat will deliver next-generation hybrid multicloud platform
IBM and Red Hat announced today that they have closed the transaction under which IBM acquired all of the issued and outstanding common shares of Red Hat for $190.00 per share in cash, representing a total equity value of approximately $34 billion.
Upcoming Events
27
Jul, 2023
OCEAN TechCon23 - July 27 - 29, 2023
MC Press Bookstore