This tutorial shows you how to successfully create two tables and an index using the IBM DB2 Development Add-In for Microsoft Visual Studio .NET. You can use the IBM Explorer to view a sample of the contents of the table. The IBM Explorer automatically queries the number of rows that the user specif
Other News
The Secret Lives of DBCC Commands
(Brian Moran) Microsoft’s unwillingness to document many valuable Database Consistency Checker (DBCC) commands has always been a pet peeve of mine. In SQL Server’s early releases (6.5 and 4.2), the “consistency checker” name was more relevant than it is in SQL Server 2000 and 7.0. Many early DBCC co
An IBM DB2 Universal Database
(Paul C. Zikopoulos and Roman B. Melnyk) This article is the first in a series that will introduce some of the new key features in DB2 UDB “Stinger,” with “work-through” examples that you can use with the open beta today. In this article, we will cover some of the new options available to programmer
SQL Server 2000 Security – Part 4 (Authorization)
(Marcin Policht) In our series, so far, we have been discussing topics related to authentication, which establishes identity of a login attempting to access SQL Server. Starting with this article, we shift our focus to authorization, which takes place once the submitted credentials (in the form of a
HOW TO: Troubleshoot the Setup Failed to Perform Required Operations on the Cluster Nodes Error
This step-by-step article describes how to troubleshoot SQL Server 2000 Virtual Server setup failures. SQL Server 2000 Virtual Server setup operations might stop responding and you receive the following error message: Setup failed to perform required operations on the cluster nodes. This err
XML Matters: GUIs and XML configuration data, Part 2
(David Mertz) This article continues his discussion of how XML is used in the configuration of GUI interfaces. He looks at Mozilla’s XML-based User Interface Language (XUL) which allows you to write applications that run without any particular dependency on the choice of underlying operating system.
To Tag or Not to Tag
(Patrick O’Kelley) Every generation remakes Shakespeare for itself with new costumes, new set designs, and new interpretations. But, despite numerous advances in humanities computing, variorum editions of the works of Shakespeare have relied on models established well before the digital age. Since t
Capturing The Error Description In A Stored Procedure
(Amit Jethva) How do you accomplish error handling in a stored procedure? 99.99 % of people will answer use @@ERROR. How do you capture actual error message of the error raised by SQL Server within a stored procedure? Such as: Server: Msg 547, Level 16, State 1, Line 1 DELETE statement conflicte
Managing content in an employee workplace, Part 6: Create a task-handling process using portlets and IBM DB2 Content Manager
(Therese Sroujian) In this sixth article in the series about managing content in an employee workplace, the author describes how the team designed and implemented a sample Web portal application to support the task processing of the Document management scenario Analyst research reporting. The scenar
Speed Tests: A Comparison Between .NET XML Web Services and .NET Remoting
(Hilton Giesenow) Prior to .NET, DCOM existed as Microsoft’s solution to remote object access. This technology leveraged the successful COM architecture to provide an infrastructure for remote communication. However, DCOM suffered from a variety of drawbacks and difficulties, and it ultimately led t