This script can be run when you want to do batch processing on a database, such as a dynamic truncate statement for all tables in your database. This script will actually script all the Foreign Keys in your database, and then store them into a table called FOREIGN_KEY_TEMP. It will then generate,
Other News
XML Database Products [a Review]
(Ronald Bourret) In this Web page, I have tried to capture the current state of the market for XML database products. These are gathered from Web sites, product reviews, XML webzines, XML resource guides, and email from product users and developers.
Index covering and DB2 query performance
(Alexander Kuznetsov) When an index contains all the columns involved in a query, we usually say that an index covers a query. Whenever, this happens, the DB2 optimizer usually chooses to access only that index to satisfy a query, which is called index-only access or index covering. “Usually” does n
Getting the Most Out of Real Time Statistics
(James Teng and Namik Hrle) DB2 UDB for OS/390 and z/OS Version 7 introduced a vital building block on its road to becoming autonomic, i.e. to becoming a database management system with zero administration and maintenance overhead: the Real Time Statistics. This feature provides a means of knowi
Simplified portal applications with DB2 Information Integrator
(Jacques Labrie) Interested in simplifying your Web or portal based applications that access relational and non-relational data? Use this tutorial to learn how to develop applications that bring all of this data together in a simple relational view. You’ll learn how the integration capabilities of D
XML 2003 Conference Diary
(Eric van der Vlist) I am on my way back from XML 2003 and it’s time for me to draw the conclusions from this event which, year after year, remains the major conference of the markup community. For this year’s conference has been dominated by schema languages, but I am so biased that this probably d
OBJECT: Notation (Understanding the Attribute)
The Notation object identifies by name the format of unparsed entities, the format of elements with a notation attribute, or the application to which a processing instruction is addressed. The name of the notation is contained in the inherited nodeName property. A Notation is read-only.
Understanding DB2 Nested Views
(Roman B. Melnyk and Paul C. Zikopoulos) A view is a virtual table, meaning that no permanent storage is associated with the data in the view; rather, the permanent storage is associated with the table or tables on which the view is based. A view allows you to look at (and in some cases to update) d
Setting up Connectivity for Application Developers
(Raul F. Chong and Jalud Abdulmenan) This is the fourth article in a series discussing connectivity scenarios involving DB2 UDB for Linux, UNIX and Windows version 8, DB2 UDB for iSeries 5.2 and DB2 UDB for z/OS V8. The focus of this article is on workstation application development connectivity for
Oracle Optimizer: Moving to and working with CBO – Part 7
(Amar Kumar Padhi) In the final installment of this series, we will cover the basics of using Stored Outlines and Oracle Application specific information.