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 Contents: 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
"synopsis" may belong to another edition of this title.
Paul Conte is president of PCES, an educational and consulting company in Eugene, Oregon. He is also a senior technical editor for iSeries NEWS and for e-Pro Magazine. Paul is a widely published expert on database systems, database design, software engineering, and programming languages. He's considered a leading authority on DB2 Universal Database for iSeries, and his articles have appeared in iSeries NEWS, DB2 Magazine, Database Programming & Design, and many other publications. He has authored or co-authored five other books, including SQL/400 Developer's Guide (29th Street Press, 2000) and SQL Server 2000 Developer's Guide (Osborne/McGraw-Hill, 2000). Paul has a B.A. in psychology from Georgia State University and an M.S. in computer science from University of Oregon.
"About this title" may belong to another edition of this title.
Book Description 29th Street Press 2004-06-01, 2004. Paperback. Book Condition: Good. 1583040986 Your purchase benefits those with developmental disabilities to live a better quality of life. wear on edges and conrers cover wear creasing sun damage miimal stains on edges. Bookseller Inventory # 3492-082517-DR-020