Extended Dynamic SQL for the masses
Extended Dynamic SQL is a unique feature of IBM® DB2® for i that can facilitate well performing SQL applications, but the associated QSQPRCED programming interface is of low level and is complex to use. This article introduces a set of C++ classes that can significantly aid in the development of applications designed for
IBM DB2 for i indexing methods and strategies
Link to white paper that lays the foundation for an indexing strategy and design that delivers high-performance queries and SQL applications on IBM DB2 for i.
Moving from OPNQRYF to SQL
This white paper discusses the major advantages that SQL has in comparison to the IBM i5/OS Open Query File (OPNQRYF) command. It also provides a methodology for converting OPNQRYF applications to an SQL-based model, as well as some key points to consider during the conversion process.
Exploring the IBM OmniFind Text Search Server
Explore the IBM DB2 for i indexing technology IBM OmniFind Text Search Server and compare it with traditional database index technologies. Find out how applications developed in any language can use SQL to perform text searches against simple text data stored in DB2 databases, business data encapsulated in XML documents,
DDS and SQL - The Winning Combination for DB2 for i: Business and technical benefits of a modern DB2 for i database
This white paper explains how modernizing a DB2 for i database with Structured Query Language (SQL) and data-centric programming can deliver benefits that range from reduced IT expenses to enhanced developer productivity and improved application performance and scalability.