In our previous posts, we had covered re-naming of objects in SQL Server and re-naming of tables and columns in Oracle. In this post, we will cover how one can re-name a table in DB2 LUW. In DB2, there is no straight way to rename the column. One has to drop and re-create the table with new column n
Other News
Clearing Alerts in Enterprise Manager
(Steve Callan) SYSMAN can be compared to a mothman in the movie titled “The Mothman Prophecies” because like the mothman, SYSMAN also seems like it is a dark, mysterious figure lurking in the background. SYSMAN, by way of introduction, is used in Oracle as the schema used for Enterprise Manager or G
Develop an Ajax-based file upload portlet using DWR
(Xiaobo Yang and Robert Allan) Web portals provide users a central gateway for accessing various resources and services. At the same time, they provide users a platform for contributing resources to be shared with other users. Users might share anything from photos to audio and video files to scient
Just an example of creating XMLType Tables
(Marco Gralike) The following is just an simple example of creating XMLType Tables (binary and object relational), that I want to share here for future reference.
Oracle Olap 11g – Reporting using OBI EE
As I had pointed out in my earlier article here, Oracle OLAP 11g have two modes of operation. In the 10g mode, users would have to create sql access views on top of these cubes in order to make them accessible to end users (for users who are on relational reporting tools like OBI EE). In order to cr
Monitoring Locking and Deadlocking
(Buck Woody) After you know the basics about how locking and blocking work in SQL Server, you’ll want to monitor them so that you can fix any errors they cause. While locking is a natural part of any Relational Database Engine, excessive locking will slow down your system, especially during data ent
Error message when you use SQL Server Management Studio to connect to SQL Server 2005 Integration Services from a client computer
Consider the following scenario. A server is running Microsoft SQL Server 2005 Integration Services (SSIS). From a client computer, you use SQL Server Management Studio to connect to Integration Services on the server. To connect to Integration Services on the server, you use a user account that is
Building an aggregation function using WebSphere ESB
(Russell Butek) Many consider the aggregation function as an integral part of an Enterprise Service Bus (ESB). While the IBM WebSphere ESB product does not provide an aggregation function and includes no aggregation primitives, you can write your own. This article provides two sample aggregation pri
Using Coordinated Universal Time (UTC) to Store Date/Time Values
(Scott Mitchell) Many data-driven applications have date/time values that are automatically populated with the current date and time. For example, in an online messageboard, whenever a user makes a post the current date and time is recorded and saved with that post. Another example is in application
Delving Deeper into Serialization with .NET
(Peyton McCullough) In “Serialization with .NET,” we began by serializing a simple string. Then, we moved on to serializing custom types and examined how a class can participate in the serialization and deserialization processes using the OnSerializing, OnSerialized, OnDeserializing and OnDeserializ