By Lisa Vaas – As Oracle Corp. girds for the upcoming release of its Oracle 10G database next month, the company is cranking up the G-for-grid part of the message for this major update.According to beta users, the update will feature easier-to-configure grid capabilities. But a big part of O
Other News
Application Development Experiences with PHP and IBM DB2 Universal Database Version 8
By Clara Liu – This article shares the author’s experience in developing a PHP application that accesses data in IBM DB2 Universal Database Version 8 on Linux. This sample application, called EFORM, is an online training evaluation tool. The article reviews the application framework and the developm
Learn the Nuances of Text, Ntext, and Image Data
Text, ntext, and image data have been around a long time, but their nuances can be easy to overlook. In this tutorial, Joseph Gama provides a quick overview of the implementation and usage of these special data types.
Collaboration tools enable groups to communicate in a virtual world
By Michael Dougherty – The information age is on the verge of becoming the inundation age. Separating the valuable information from the less useful is one of the biggest challenges most workers face today. But they shouldn’t have to personally separate the wheat from the chaff. Instead, tools should
IBM seeks to expand data management platform
By Paul Krill – IBM’s labs are at work on a number of improvements to IBM’s DB2 data management platform, focusing on data warehousing and integration as well as on autonomic, or self-managing, computing systems, company officials said on Thursday.
Generate Audit Table Trigger Code
This code will generate code to do a column-by-column comparison against a table, assuming that you are joining the inserted table (aliased as “i”) with the deleted table (aliased as “d”) in a trigger:
Administrative Assistant for DB2
Administrative Assistant for DB2 makes it easier to manage a DB2 environment on S/390 effectively and safely, while reducing the price of ownership.Product Announcement
Querying When Table and Column Names are Unknown
by N. Venkatagiri – If you have to run a query for some data but don’t know the table name and the column name, the following query will run the query. Replace the TEXT_VALUE with the text you want to search.
SQL Server Worm on the Loose
By Lisa Vaas – A worm code-named “Voyager Alpha Force” that targets Microsoft Corp. SQL Server databases is roaming the Internet, trying to turn insecure database servers into launching pads for applications running out of FTP sites in the Philippines.
Oracle 9i XML component vulnerable
By Ellen O’Brien – A set of buffer overflows in the XML component of Oracle Corp.’s 9i database makes it highly vulnerable to attack through a company intranet portal. Oracle is urging customers to immediately patch the vulnerabilities and to avoid connecting the database to the Internet until they