(Craig Mullins) I have a DB2 database that uses social security number as employee number, and it is the primary key in over 200 tables. I need to change the primary key to another type of employee number. How do I do this? There are over 300 million rows to update accross the tables. This is a payr
Other News
Working with Analysis Services Cubes in SQL Server
(Baya Pavliashvili) Data warehousing is not for the faint of heart; it takes much diligence and dedication to learn the various tools of the trade. In this article, Baya Pavliashvili details some features available with Microsoft Analysis Services, whose Analysis Manager allows you to create and
Batching DML Opearations in SQL Server
(Vinod Kumar) This requirement again comes from the repeated posts in the local usergroup of mine. Bussiness processes at some time would want to Update millions of rows based on some criteria. Even for a matter of fact sometimes we would be interested in deleting tons of rows. And issuing a DELETE
Meet the Experts: Abdul Al-Azzawe on development enhancements in DB2 Universal Database V8.2
DB2 Universal Database V8.2, known as ‘Stinger,’ features many enhancements of particular interest to developers. Abdul Al-Azzawe, architect for the integration of DB2 with Visual Studio .NET, talks to developerWorks DB2 readers about enhancements to debugging, Web services support, new features for
‘Dog Fooding’ Lessons: Microsoft Internal IT Group Deploys Beta 2 of Microsoft SQL Server 2005
Q&A: A senior internal technology architect shares insight Microsoft has gained from deploying and testing the latest beta release of Microsoft SQL Server 2005 as part of the company’s SAP R/3 enterprise resource planning system.
SimpleType and ComplexType in a Schema
(Deepak Vohra and Ajay Vohra) This tutorial discusses the simpleType and complexType XML Schema structures and their corresponding representations in an XML document. XML Schema is used as the basis of an XML document structure, and some of the XML technologies, such as JAXB, are based on XML Schema
Making a Change in a World Without Windows: DB2 for z/OS Version 8 Provides Some New Options (Part 2)
(Susan Lawson) Achieving a true 24×7 environment is almost impossible. It is rather our cleverness at hiding outages from our users that makes us “appear” 24×7. But as requirements get stricter we are going to need more help. Maintenance aside, if our databases were static life would be great, but u
Rapid Struts Development
(Harshad Oak) Would you like to avoid having to create the same Struts structure again and again? The Oracle JDeveloper 10g integrated development environment (IDE) lets you skip some Struts tedium and do what you want to do: build Struts applications quickly. This article shows how Oracle JDeve
Converting dates in character fields
(Kent Milligan) We have files that have dates in character fields in the format “mm/dd/yy”. The dates are stored in character fields with the ‘/’ included so they can be converted to tab delimited file with the CPYTOIMP command. Under V5R1, V5R2 the dates with slashes ‘/’ converted perfectly. Now un
X Is for XQuery
(Jason Hunter) Query may cause one of the biggest changes to server-side programming since Java servlets. XQuery is a query language specification under development by the World Wide Web Consortium (W3C) that’s designed to query collections of XML data—not just XML files, but anything that can appea