The FOR XML clause is valid only in the SELECT statement and is subject to these limitations: FOR XML is not valid in subselections, whether it is in UPDATE, INSERT, or DELETE statements, a nested SELECT statement, or other statements (SELECT INTO, assignment).
Author: SSWUG Research
DB2 Basics: Fun with Dates and Times
(Paul Yip) This short article is intended for those who are new to DB2 UDB and wish to understand how to manipulate dates and times. Most people who have worked with other databases are pleasantly surprised by how easy it is in DB2 UDB.
And How Do You Expect Me to Audit SQL Server?
(Jeremy Kadlec) Is your organization faced with pending audits, resulting in long and tedious meetings to try to achieve compliance? Have you been hearing a foreign set of acronyms around the water cooler like HIPAA, SOX, GLBA and SAS 70? Have these new sets of requirements been causing consternatio
XSLT Reflection
(Jirka Kosek) Many modern programming languages contain a special interface called reflection. Reflection can be used to programmatically read, modifying, and create code in a particular language. Because the main purpose of XSLT is to transform XML documents, and because a XSLT stylesheet is expres
Leaving the History Behind with Oracle’s Fine Grained Access Control
(Marin Komadina) Oracle has not solved the problem of exporting all but a few larger tables from a user schema thus far. This leaves DBAs to find their own workarounds when necessary. This article covers the three most used solutions. – Full export – Data dictionary view modification – Fine
Exporting Access schema using XML
(Susan Harkins) When it comes to sharing, applications often act more like squabbling children than professional tools of the trade. Sometimes the solution is to find a third application that’s compatible to both formats. Unfortunately, there isn’t always a compatible format available. The good news
IBM releases first visual editor for DB2 data mining
IBM announced four new technologies that will enable developers to more easily deploy and manage applications based on DB2 Universal Database. These new DB2 developments are designed to ease development expertise and shorten the time and costs associated with implementing new applications.
A Primer on Using DB2 with .NET
(Chip Irek) Working with DB2, from a .NET application developer’s perspective, is just like working with any other relational database. One can find endless examples of how to perform databases tasks (from the mundane to the interesting) for Microsoft SQL Server and Oracle, but there is not as much
DB2 SQL Procedural Language: Using Flow of Control Statements
(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip) Loops allow you to execute a set of statements repeatedly until a certain condition is reached. The loop terminating condition may be defined at the beginning, in the middle, or at the end of the lo
Practical .NET SOAP
(Richard Mansfield) Microsoft’s .NET technology rests on XML and employs it for Internet communication (including Web services), data storage, and many other purposes. .NET contains many functions that translate various kinds of objects—including database tables—to and from XML formats.