Other News

Community

Foreign Key DDL wizard

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,

Community

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

Community

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