(Ted J. Wasserman) Learn how to create and use user-defined routines in IBM DB2 9. This is the last tutorial in a series of nine tutorials that you can use to help prepare for the DB2 9 Application Development certification exam (Exam 733). (R)
Author: SSWUG Research
Making SQL Server 2005 Integration Services Packages Portable
(Narayana Vyas Kondreddi) Many of us have used UDL files (Universal Data Link files) in SQL Server 2000 Data Transformation Services packages (DTS packages). UDLs allowed us to make our DTS packages portable.
FIX: The description for the Dimension field is not set in the local cube file when you use the CREATE LOCAL CUBE statement in SQL Server 2005
When you use the CREATE LOCAL CUBE statement in Microsoft SQL Server 2005, the description for the Dimension field is not set in the local cube file. Additionally, the description for the Measure field is not set in the local cube file.
How to export a Crystal Report using C#
(Le0) I had been searching for some good code that allows a programmer to export a Crystal Report programmatically, without using the (not always) functional buttons that come with Crystal Reports. This is a short, straight forward article on how to export a Crystal Report in the most common formats
Understanding Relaxed Delegates in VB
(Paul Kimmel) Relaxed delegates, one feature among the slew of new stuff coming in “Orcas” (VB 9.0 and .NET 3.5), provide more options for binding event handlers to events—even if the method/handler signatures don’t match exactly. Some relaxation of method binding was introduced in VB 8.0 and .NET 2
Introduction to Managed Code in Visual Studio 2005 Tools for Office
(Kathleen McGrath and Paul Stubbs) Code that runs within the .NET Framework is considered managed code. This includes applications written in languages such as Visual C# and Visual Basic 2005. Code that is not managed by the .NET Framework is typically referred to as unmanaged code. This includes ap
Use WebSphere Federation Server Version 9.1 to integrate XML data
(Aakash Bordia, Eileen Lin, Ioana Ursu and Sebastian Hahnel) The new pureXML support available in WebSphere Federation Server Version 9.1 allows you to integrate both local and remote XML store data. You can also use the new SQL/XML and XQuery languages to query XML data in your new applications. Le
Installing Oracle E-Business Suite Release 12 with shared APPL_TOP on CFS
(Arnoud Roth) As soon as EBS Release 12 became available, I started with the installation, eager to find out what the differences were compared to 11i.
How to get Distinct Count in SSIS
(Marco Russo) Almost one month ago I made a post about a brand new Distinct component for SSIS made by Alberto Ferrari and freely available on SQLBI.EU.
XML in VB9 on Channel 9
The next version of VB .Net adds Xml as a built in data type using the new LINQ to XML API. As a built in data type, VB 9.0 provides the ability to create XML using XML Literals and to query XML documents using XML properties. This webcast contains a demo by David Schach, the lead developer in this