(Jim Clune) This is the second of two parts of a discussion on minimizing weaknesses in transport layer security (TLS) for Web services. The first part discussed the ways certificate management, man-in-the-middle attacks, and XML attacks can compromise TLS in Web services applications. The discussio
Other News
Constraints and Triggers
The DB2 DBMS offers a useful suite of methods to ensure data consistency. Primary key constraints forbid duplicate values in one or more columns of a table. Foreign key constraints ensure consistency of tuple (row) references across tables. Table check constraints are conditions that are defined
OTL/DB2-CLI and bulk operations with DB2’s CLOB
This example demonstrates simple INSERT and SELECT with DB2’s CLOB data type being done in bulk (buffer size > 1). This example can be easily modified to make it work with DB2’s BLOB by changing the “CLOB” data type in the table to “BLOB”, and by replacing “varchar_long” with “raw_long”.
XML-ify your stored procedures
(Jimmy Nilsson) Since I’m a geek I love to use new technology. When XML was quite new a couple of years ago, I used it as the file format in a project for a customer of mine. Hey, I know what you think, but my customer actually thought – and still thinks – it was a good solution to use […]
Server Explorer for Oracle Databases
Oracle databases display some differences in Server Explorer. For example, when you add a connection to an Oracle database, you will see these folders: Database Diagrams, Tables, Synonyms, Views, Stored Procedures, Functions, Package Specifications, and Package Bodies. The following topics briefly d
Binary Killed the XML Star?
There are at least two kinds of topics of permanent conversation in the XML development community: formally settled, and formally unsettled. In other words, members of the XML development community are perpetually discussing, on the one hand, issues which have been, more or less, formally settled by
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
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.
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
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.