(kolliparachandra) XSLT supports the entire XPath function library as well as several XSLT-specific functions that all implementations are required to support. If a function expects an argument of a specific type and an object of a different type is used, it’s implicitly coerced as if by calling th
Other News
Select TOP With TIES in SQL Server
(Suprotim Agarwal) The SQL Server TOP Expression returns only the first set of rows that is either a number or a percent of rows. If you want additional rows to be returned from the base result set if duplicate values exists in the qualified set of results, then use TOP..WITH TIES as shown in the ex
DB2 for z/OS Events & Resources
(Susan Visser) I’ve been seeing many upcoming events for the DB2 for z/OS product and decided to summarize in this post.
DB2 for z/OS: CATMAINT and Concurrency
(Robert Catterall) In the years since mainframe DB2 data sharing was introduced with DB2 for z/OS Version 4 (mid-1990s), I’ve done a lot of presenting and writing about the technology (e.g., a blog entry from a couple of years ago that provided an overview of the topic).
IBM Cognos Proven Practices: Using Active Report Variables in Cognos 10
A demonstration of enabling the ability to view variables for Active Reports and monitor their behavior in a working report.
How to Identify Bad Queries in MySQL
(Baron Schwartz) Finding bad queries is a big part of optimization. A scientific optimization process can be simplified to “can anything be improved for less than it costs not to improve it? – if not, we’re done.”
Adding Child Controls to a ComboBox Items in Silverlight using C#
(Mahesh Chand) I am building a Project Survival Forecaster application in Silverlight 4 that forecasts the chances of surviving a software project. In this application, I need a ComboBox control to host other child controls.
JRUBY example using UCP (Oracle Connection Pool)
(Pas Apicella) The Oracle Universal Connection Pool (UCP) for JDBC is a full-featured connection pool for managing database connections not only for Oracle but also for other non Oracle databases.
SQL Profiles Disable Automatic Dynamic Sampling
(Kerry Osborne) I had an interesting email exchange with a fellow Oracle practitioner, Bryan Grenn, about differences between SQL Profiles and Baselines last week. Basically Bryan observed that SQL Profiles appeared to disable Dynamic Sampling on Global Temporary Tables while Baselines did not.
ADF 11g : Log Data Manipulation
(Luc Bors) Today I had a request to implement a generic logging mechanism for all changes of data (DML) in an ADF application. The log needs to be persisted in a database table. This application uses ADF-Business Components and an Oracle Database. My first idea was to use database triggers for all t