(Marcin Policht) In our previous two articles of this series, we discussed auditing and security related aspects of SQL Server 2000 Data Transformation Services. Now, we will combine these topics by presenting DTS Meta Data Services, which provides the ability to audit creation, execution, and modif
Author: SSWUG Research
The End Is in Sight for Paper-Intensive Transactions
(Bruce Silver) For 30 years, a few strident voices have warned us that the world is running out of oil. With low energy prices, it used to be easy for some to dismiss them as tree-hugging cranks, but now with oil costing more than $40 per barrel and rising, maybe their dire predictions are finally c
ODBC support for Cloudscape
(Susan L. Cline) ODBC support is available for the Cloudscape 10.0 GA and Derby databases as an IBM DB2 Run-Time client. This article discusses supported platforms, system requirements and information about where to download the free driver.
Replicate data in the fast lane
Q replication is a new, high-speed technology for moving transactions between DB2 databases. It’s a highlight of the just-released DB2 Information Integrator Version 8.2. One of the reasons Q replication is so fast is that it uses the powerful business integration product WebSphere MQ to zoom data a
Principles of XML design: Considering container elements
(Uche Ogbuji) A critical issue in designing XML formats is figuring out how to arrange elements and represent relationships between them. Element design works best when it naturally corresponds to how people think about the concepts that each element represents. This article discusses best pract
SQL Server 2005 Data Transformation Services (DTS) – A First Look
(Srinivas Sampath) Before we begin the discovery of this new tool, there is one word that can immediately describe it: WOW!! That is the first reaction I had when I started playing around with DTS. Its a totally different beast in SQL Server 2005 and is a lot better than the SQL Server 2000 coun
Enabling the Commit Button in an ADF Application
(Duncan Mills) A confused ADF user has a problem with the commit button in a ADF BC bound JSP Page. Dragging the Commit operation from the Data Control Palette onto the page creates the button to trigger the event OK but when you run the page the button is disabled… Why? and how can you make the c
Data on the Outside vs. Data on the Inside
(Pat Helland) This article explores Service Oriented Architecture, and the differences between data inside and data outside the service boundary. Additionally, it examines the strengths and weaknesses of objects, SQL, and XML as different representations of data, and compares and contrasts these mod
XMP Lowdown
(Bob DuCharme) The Extensible Metadata Platform (XMP) is a specification describing RDF-based data and storage models for metadata about documents in any format. The specification includes information about embedding XMP in text files such as HTML and SVG/XML; image formats such as JPEG, TIFF, and G
Data extractor for a flat record
(Kevin Nilson) This subprocedure extracts data from a flat record (no dds), tab delimited, comma delimited, etc. It uses the field delimiting character and the positional number in the record to identify the desired data. So if I wanted to get the data from the ninth field of and EDI document, I wou