(Darren Green) There is a known issue where DTS truncates delimited columns at 255 characters when exporting to a text file. The problem is not with the DataPump itself, it is due to the default properties of text file connection provider as used within the DTS designer and the Import/Export wizard.
Author: SSWUG Research
Which edition of DB2 Connect is right for you?
(Paul Zikopoulos, Roman Melnyk and Leon Katsnelson) DB2 Connect is IBM middleware for connectivity from distributed systems to host- and mainframe-based DB2 systems. This article introduces DB2 Connect and discusses the different editions and pricing models to help you decide which implementation is
Functionality from the DB2 UDB SQL Reference for Cross-Platform Development not supported by Derby
(Mark Chiang and Daniel Debrunner) Some of the functionality described in the IBM DB2 Universal Database (DB2 UDB) SQL Reference for Cross-Platform Development Version 1.1 is not supported by Derby. This article lists these differences. This comparison was developed by reviewing the DB2 UDB SQL
Queue MSMQ Messages from SQL Server
(Calvin Luttrell) If you’ve ever found yourself scratching your head, wondering how to queue a message from MS SQL Server, then you might find yourself writing your own plumbing. (Microsoft will most certainly be dealing with this boggle in future version). And I don’t know how your boss operates, b
Working with XML Processing Instructions in C#
(Michelle Beall) Firstly, what is an XML processing instruction? A processing instruction (PI) is a tag that encodes specific application information which begins with < and ends with >. An XML document can contain multiple processing instructions for different applications. There are tw
Creating a Tree View of XML Data in Visual Studio .NET
(John Mueller) XML provides a convenient means for storing data, no matter what form the data takes. It relies on a hierarchical structure to store the data, unlike the tables used in a relational database. Consequently, XML has advantages and disadvantages versus the relational model you’re probabl
Undocumented Quick-and-Dirty Sample Applications
(Steve Muench) As part of helping customers be successful with JDeveloper and ADF I’m often creating little example applications to illustrate a point. My goal is to document them and put them together with an OTN “HowTo” paper to accompany them, but I don’t always have the time to do the documentat
Getting the Most Out of XML with XPath
(Jack D. Herrington) WML has now taken over the representation and storage of structured data in a textual format. No longer do we even have a need for new text formats because XML and its related standards do such a good job, and are so ubiquitous, that new standards are no longer needed. Understan
IBM DB2 and SQL Server: Video Comparisons
Microsoft partner Extreme Logic offers a series of demos and presentations highlighting the integration between SQL Server 2000 and IBM DB2, with a focus on how SQL Server 2000 can add value to an existing IBM DB2 environment, be it on the mainframe, AS/400, UNIX, or Microsoft Windows operating syst
Is all code really code? One question from an interview
(Andy Warren) When we hire new employees (at my day job) we start with a phone interview. I’ve got a list of a couple dozen questions we run through that give us an idea of whether we should consider bringing the person in for a more in depth interview. While a discussion of those questions is proba