(Ben Forta) In this lesson, you will learn how to use the SELECT statement’s ORDER BY clause to sort retrieved data as needed.
Other News
Recursion in DB2 V8, V8, V8…
(Craig S. Mullins) One of the most intriguing new features of DB2 for z/OS V8 is the ability to code recursive SQL. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of recursion is to think about a mirror that is reflected into another mirror and when
Using the Java CachedRowSet implementation with DB2 UDB
(Kulvir Singh Bhogal) Cached Row Sets are a new offering of Java 1.5 emerging from the efforts of JSR114. This new capability enables you to have a serializable disconnected object. This means you can connect to the database, grab your data in the form of a result set, release the connection and man
Web Services Integration Patterns, Part 1
(Massimiliano Bigatti) A few months ago I was working on a Java application for the banking industry. There were a bunch of hosted services that we had to integrate in our software. We had to use web services, since the SOAP protocol was the bank’s standard way to access legacy data, throughout CICS
FIX: The merge replication agent stops responding when you perform merge replication between a SQL Server database and a SQL Server CE database by using a custom conflict resolver
When you perform merge replication between a Microsoft SQL Server 2000 database and a Microsoft SQL Server 2000 Windows CE Edition version 2.0 (SQL Server CE) database that is running on a handheld device such as a Pocket PC, the merge replication agent may stop responding in the following situation
Capture Replication Statistics in AdminDB :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 2000 and later Description:
IBM To Provide Multilevel Security on the zSeries
(Mary E. Moore) Multilevel security (MLS) addresses government requirements for highly secure data that can be shared between agencies. The eServer zSeries is the first IBM platform to provide multilevel security with new security features in DB2 UDB for z/OS V8 and z/OS V1.5. This technology en
Convert AS/400 Data into XML
(Tahir Malik) XML has become the Internet standard in data representation. XML can not only be transported over HTTP, but it can also go through firewalls, making this markup language quite fluid. XML Web Services, as its name suggests, is highly dependent upon XML.
All for One and One for All – Introducing Unicode (Part 2)
(Sarah Ellis) In the last issue we gave an introduction to Unicode and the Version 8 enhancements in this area, including the conversion of the DB2 Catalog to Unicode and Unicode parsing. As stated previously, these enhancements will impact everyone to some degree so in this, the second half of the
Support WebCast: Programming the SQLXML Managed Classes
The objective of this session is to introduce the basics (and the architecture) of executing SQLXML queries in Microsoft .NET applications by using SQLXML Managed Classes. Code examples will be presented to illustrate how to execute different types of SQLXML queries (including FOR XML AUTO, Template