Power Tips for iSeries Database & SQL

The IBM iSeries has a sophisticated and powerful database, DB2 UDB for iSeries. In this book, SQL and database expert Paul Conte (author of SQL/400 Developer's Guide) focuses on helping you use DB2 UDB for iSeries more effectively. The pointers you'll find in this book -- more than a hundred of them! -- will save you significant time and help improve the quality or performance of your database applications. Using DB2 effectively involves creating database objects, managing them, and accessing contents using one of several available interfaces. You'll find tips for each of these areas, loosely grouped into chapters that deal with a particular area of database development or administration. Whether you're making the transition to SQL, handling dates, or working with triggers, JDBC/ODBC, or IFS, you'll find numerous valuable nuggets of knowledge in this handy guide. Table of Chapter 1: SQL and The Traditional OS/400 Database Chapter 2: SQL and "Traditional" Database Coexistence Chapter 3: SQL Data Definition Language Chapter 4: SQL Data Manipulation Language Chapter 5: Additional SQL Topics Chapter 6: Handling Dates Chapter 7: Stored Procedures, User-Defined Functions, and Triggers Chapter 8: Transactions Chapter 9: DDS and ILE RPG I/O Chapter 10: JDBC and ODBC Chapter 11: CL, OpnQryF, and Miscellaneous DB Chapter 12: Integration File System