The SQL Error Logging Facility (SELF) is a new tool that can help you find and understand SQL errors and warnings.

By Sarah Mackenzie

SQL has become the standard method for communication with your database. You can use SQL to create and modify your database tables, insert or update data in your table, or access data in your database. More-complex SQL features allow you to create triggers, procedures, and functions to perform more-complicated operations. Additionally, IBM i SQL services provide you with new ways of interacting with everything IBM i that isn’t the database. However, if an error occurs while using SQL to perform these tasks, it can cause significant problems in your applications. It thus becomes very important to proactively find and fix these errors before they become problems.

SQL views provide alternative ways of accessing the data in a table.

By Brian Meyers and Jim Buck

Editor's Note: This article is excerpted from chapter 3 of Programming in ILE RPG, Fifth Edition.

Although a program can retrieve and process virtual rows from a view, the view does not actually contain data. Instead, it stores an access path, a sequence of pointers to the actual data in one or more tables. When SQL creates a new view, the database constructs an unkeyed logical file based on a physical file. An RPG program does not make a distinction between a table and a view when it is processing the file—the program can read and generally update the file whether it is a table or a view.

Ever wonder what the difference is between Risk Assessments and Pen Testing for your IBM i?   In this video, Carol Woodbury explains her experience with Risk Assessments and how Pen Testing gives “proof” of vulnerabilities, helping clients to know exactly what to address to reduce risk and improve security.

Want to learn more about the benefits of Pen Testing your IBM i? Contact us today at www.dxrsecurity.com

In its most recent report on insights-driven businesses, Forrester found that those with advanced business intelligence infrastructure are confidently growing by at least 20%. These are organizations that have been successfully enabling smarter and faster decision-making across the board through technology and data governance.

By LANSA, An Idera Inc. Company

Intelligent use of data analytics is key to optimized business processes, high customer satisfaction rates, and increased profits. With the ability to closely monitor performance and trends, companies are able to respond faster to the market – even make reliable forecasts and ultimately gain a competitive advantage.