(Serge Rielau) Do you want to learn some tricks for tuning SQL PL? If so, this article describes common examples for tuning SQL procedures in IBM DB2 Universal Database (UDB) V8.2 for Linux, UNIX, and Windows, with a special focus on procedures ported from other database management systems.
Other News
All About Transactions – Part 2
(Don Peterson) In Part 1 of this series I talked about transactions in general, I explored the three Transaction Modes that SQL Server supports, and nested transactions. In that article I stated “…just placing several SQL commands between a BEGIN TRAN and a COMMIT or ROLLBACK does not ensure t
BUG: The list of errors is incomplete when you use the Import Catalog Wizard to validate or to import an XML catalog file and validation fails in Commerce Server 2002 Feature Pack 1
In Microsoft Commerce Server 2002 Feature Pack 1, when you use the Import Catalog Wizard to import an XML catalog file and the XML catalog file validation fails, the list of errors is incomplete. The complete list of errors is displayed only when you save the errors to a file.
Declaring Variables
(Azim Fahmi) I have two tables with the same column names. Table1 has data for a certain time period. Table2 also has the data for the same time period. Table2 has the correct data for col1, col2. I want to update the columns (col1, col2) in table1 with data from columns (col1, col2) in table2 and
Mass deployment of DB2 Universal Database Version 8.2 on Microsoft Windows operating systems
(Rory A.A. Hinton, Andrew Hilden and Louisa Ford) The distribution and installation of any database software across large numbers of clients and servers can be a daunting task. However, DB2 Universal Database (UDB) Version 8.2 has features and tools that allow both servers and clients to be deployed
MySQL warning users, contemplating changes after worm
(Paul Roberts) Open source database software maker MySQL warned its users to tighten security after news broke about a new Internet worm that targets the popular relational database, according to a company executive. The company is looking at making bigger changes to harden its product against f
Easier ERP Implementation?
(Lawrence S. Gould) Oracle has been seeing some of its major customers, many of them growing through acquisitions, implementing ERP in roughly three months at facilities around the world. SAP has also seen faster implementations of its software.
Custom Editor Menus…
(Brian Mains) Custom editors modify any type of property, and can be linked to any property through the Editor metadata attribute. Editors use the IWindowsFormsEditorService interface to display a Windows form as a drop-down box or a dialog box, within the Visual Studio .NET environment.
Why Projects Fail
(Eric Lundquist) The possibility that the FBI may have to scrap its $170 million Virtual Case File software program was described by Sen. Patrick Leahy, D-Vt., in one report as a “train disaster in slow motion.”
Integrate Cocoon with PostgreSQL for XML-driven Apps
(Wellie Chao) Cocoon is a powerful tool for publishing content to multiple formats from XML. It can be used for static content, but its most powerful application is publishing dynamically generated XML streams. The XML streams can come from database information wrapped in XML tags, from XHTML We