Calling Stored Procedures. Read Part 1, Part 2, and Part 3 of this series.

By Roger Sanders

Editor's Note: This article is excerpted from chapter 6 of QuickStart Guide to Db2 Development with Python, by Roger Sanders.

If an application has one or more transactions that perform a relatively large amount of work with little or no user interaction, those transactions can be encapsulated and stored on the database server as a stored procedure. Stored procedures make it possible to perform data processing operations directly at the server, which typically is a high-performant computer that can provide quick, coordinated data access. More importantly, because a stored procedure is invoked by a single SQL statement (or API/Cursor object method), fewer messages have to be transmitted across the network—only the data that is actually needed at the client has to be sent across the wire.

IT has undergone a dramatic shift in recent years. For some organizations, a distributed workforce is the new norm. For everyone, threats have ramped up and new compliance mandates are popping up across the globe. Cybersecurity is both more important and more complicated than ever before.

By HelpSystems

Editor's note: This article introduces the webinar: The State of IBM i Security in 2022: 3 Key Takeaways, which is On-Demand and available to download and view from the MC Webcast Center.

Join this live webinar to learn how your fellow IBM i pros are tackling these issues and get practical, action-oriented tips to help you make improvements on your systems.

IBM kicked off its annual Think conference in Boston, bringing together clients and IBM Ecosystem partners around the world to discuss how technology drives organizations to excel in a digital world. During the event, IBM senior executives, global business leaders, and industry experts will discuss significant advances in technology and issues such as sustainability, innovation and research, talent retention, and automation.

By IBM Corporation

"Technology is now the source of competitive advantage with digital transformation leading the way. Our clients and partners trust IBM to deliver the innovation behind hybrid cloud, AI, and consulting solutions that are helping to ensure their success," said Arvind Krishna, Chairman and Chief Executive Officer, IBM. "Our Think events will showcase how IBM is co-creating with an expanding ecosystem to make progress on the most pressing issues enterprises and society face today."