(Deborah Kurata) There are some pieces of code that you write over and over again. Some of these pieces make sense as standard components or standard methods, such as logging or validation. Other pieces are more unique and cannot easily be made into standard methods, like Property procedures, For lo
Author: SSWUG Research
Seattle Movie Finder: An AJAX- and REST-Powered Virtual Earth Mashup
(Dare Obasanjo) I am a big fan of movies, especially summer blockbusters. Last summer I saw Fantastic Four, War of the Worlds, Batman Begins and Mr. and Mrs. Smith. Every Friday I visit sites like MSN Movies and IMDB to learn what new movies are available in my neighborhood and in what theaters they
Stored Procedures, UDFs and Triggers—Common Logic or Common Problem?
DB2 Stored Procedures, user-defined functions, and triggers are becoming more prevalent on the mainframe, and can be part of a valuable implementation strategy. Use of these advanced database objects dramatically extends the capabilities of the database, and can be a performance benefit—or a perform
How To Receive Data from a Single Table, continued
(Bryan Sylverson) Figure 3-7 introduces you to functions and illustrates how you use them in column specifications. A function performs an operation and returns a value. For now, don’t worry about the details of how the functions shown here work. You’ll learn more about all of these functions in cha
Get off to a fast start with DB2 Viper
(C. M. Saracco) You’ve probably heard the buzz about DB2’s new Viper release — IBM’s first database management system to support both tabular (SQL-based) and hierarchical (XML-based) data structures. If you’re curious about DB2’s new “native” support for XML and want to get off to a fast start, you
XML Schema 1.1 Part 2: Datatypes
XML Schema: Datatypes is part 2 of the specification of the XML Schema language. It defines facilities for defining datatypes to be used in XML Schemas as well as other XML specifications. The datatype language, which is itself represented in XML, provides a superset of the capabilities found in XML
Need some XML authoring/editing help? Get a little Oxygen…
(Ed Tittel) As I write this tip, I’m nearing the midpoint of a two-week stint at the TechTarget Expert Answer Center, where I’m blogging daily and answering member questions about—you guessed it—XML topics, tools, and technologies. This tip is an expanded version of a blog I wrote on February 15, 20
SSIS: SELECT *… or select from a dropdown in an OLE DB Source component?
(Jamie Thomson) The OLE DB Source component allows a number of methods for extracting data from an OLE DB Source. The two most obvious are: 1) Write a SQL statement to extract data 2) Select a required table from a drop down box.
Data Joins
When studying relationships, we reviewed techniques of making data from one table available to the records of another table. This demonstrated to reduce data duplication and mistakes. Another issue that involves the combination of tables consists of creating records from more than one table and maki
Try/Catch Block in SQL Server 2005
(Gregory A. Larsen) Server 2005 now supports a more programmable error trapping convention in T-SQL code. This error handling is known as the TRY/CATCH block. The TRY/CATCH block allows T-SQL to handling errors like other programming languages, such as Microsoft Visual C# and C++. In addition to the