Due to recent accounting scandals in the financial industry, the FCC may implement new regulations that require companies to preserve the content of electronic documents, primarily e-mail, for predetermined time periods. Being able to store and retrieve these documents in a DBMS might be advantageou
Tag: IBM
BMC Buys Maker of IBM DB2 Tools
By Lisa Vaas – BMC Software Inc. has gobbled up yet another company, a small IBM DB2 Universal Database toolmaker, company officials told eWEEK on Wednesday—a move that’s in line with its Project Golden Gate roadmap for providing data management tools that work in a heterogeneous environment.
Performance of DB2 Information Integrator in a J2EE Environment
In this last of our three-part series, our authors compare performance results for queries run with federation with those run using direct access.
DB2 user certification prep, Part 1: DB2 Tools, data warehousing and OLAP
This tutorial introduces the basics of the DB2 Tools, and the concepts of data warehousing and OLAP. It is designed to help you prepare for the DB2 Fundamentals Certification (Exam 512). The material in this tutorial primarily covers the objectives in the first section of the exam, Section 1. Instal
IBM Lowballs DB2
By Charles Babcock – IBM is challenging Microsoft for midsize- and small-business database users by pricing the Express version of its DB2 database at $598 for a single user running it on a single processor.
IBM To Add Order To XML
By Antone Gonsalves – IBM plans to release next year a software tool that will improve DB2 Content Manager’s ability to manage the many different XML documents used by enterprises.Code-named “Cinnamon,” the utility will be integrated with the administrative tools for Content Manager’s reposi
IBM adds database support to Risk Manager
IBM will expand its Tivoli Risk Manager security event management product to manage security events from a number of common enterprise databases.The Risk Manager software can now manage security events from IBM DB2 Universal Database as well as Oracle Database by Oracle and Microsoft’s SQL S
IBM Fits DB2 With Automation
By Lisa Vaas – An upgrade to IBM’s DB2 Express database offers small and midsize businesses a no-click, quiet-as-a-mouse, self-installing version of its enterprise-level DB2 Universal Database, IBM officials said.
Efficient Ways to Publish DB2 Data as XML
By Seeling Cheung – What’s new in DB2 UDB V8 for information integration and interchange? The new built-in SQL/XML publishing functions offer DB2 users and application developers easy and efficient ways to publish XML from DB2 data. This tutorial gives an overview of some of the new SQL/XML function
How can I insert multiple rows in a DB2 table?
By Craig Mullins – Well, one way is to issue multiple INSERT statements, one for each row. But I don’t think that is what you are asking. If you are looking for a way to insert multiple rows into a DB2 table using one INSERT statement, that is possible using a SELECT within the insert.