You can store the Data Transformation Services (DTS) package in one of three places. The following code samples describe the three methods to obtain a list of packages for each storage method.
Author: SSWUG Research
Constraints and Triggers
Constraints are declarations of conditions about the database that must remain true. These include attributed-based, tuple-based, key, and referential integrity constraints. The system checks for the violation of the constraints on actions that may cause a violation, and aborts the action accordingl
Connecting to a data source using the DriverManager interface with the DB2 Universal JDBC Driver
A JDBC application can establish a connection to a data source using the JDBC DriverManager interface, which is part of the java.sql package. The Java application first loads the JDBC driver by invoking the Class.forName method. After the application loads the driver, it connects to a database s
Writing Better SQL Using Regular Expressions
A new feature of Oracle Database 10g vastly improves your ability to search and manipulate character data. (Alice Rischert) This feature, regular expressions, is a notation for describing textual patterns. It has long been available in many programming languages and a number of UNIX utilities. O
SQL Server Stored Procedure Basics
(Ken Henderson) Working from the assumption that the human brain learns by associating new data with what it already knows, we’ll spend this chapter building a base framework onto which we can assemble the knowledge conveyed by the remainder of the book. We’ll touch on the topics covered in the
Disciplined PL/SQL
(Steven Feuerstein) I have been writing PL/SQL code since 1990. This means I have churned out tens of thousands of lines of software, and most of it, I am certain, was poorly written and difficult to maintain. Fortunately, I have discovered that it is never too late to find—and follow—new paths
Iterate Through a Result Set by Using Transact-SQL
This article describes various methods that you can use to simulate a cursor-like FETCH-NEXT logic in a stored procedure, trigger, or Transact-SQL batch.
Document-Centric Software Development
(Steve Bailey and Allan Jones) At the heart of any software program lies data, and in the case of Web services and service-oriented solutions this is presented to the underlying software as XML documents. The representation and handling of these documents within the software is a major challenge wit
Learning to Share: Declared Global Temporary Tables
(Paul Yip) This article explains how to use declared global temporary tables in DB2 Universal Database. This is a useful technique for sharing data between applications and stored procedures.
What’s New and Cool in SQL Server
(Peter W. DeBetta) Sure, SQL Server has lots of features that make it easy to manage and administer. Sure, it’s a world-class relational database management system. Sure, Transact-SQL (T-SQL) is an easy-to-learn language. Yet despite these and other facts, many developers only have a cursory knowled