Rational Common Reporting provides an XML ODBC driver, and a starter set of ODBC data sources. The XML ODBC driver uses the configuration file provided by the XML Data Configuration tool to transform the XML data into relational form, which is what the Rational Common Reporting Report Server components expect. You can then use the XML ODBC driver at run time to access that XML data from the Rational Common Reporting Report Server for operational (or live) reports.
The ODBC driver has limited SQL support. Simple column select and where commands are possible, such as:
SELECT *|column1[,column2…] FROM["catalog".]"schema"."table" [WHERE FilteringExpression] [WITH pagesize=xxx].
You can use the SELECT command with the * character for a wildcard search from a single table. Use the WHERE clause only to compare with a constant value. You can use a simple filtering expression, such as [modifiedsince=xxx [AND]] column1 =|<|> value [AND|OR ...]. Here modifiedsince is a special parameter. If you are using a Rational Common Reporting Data Service that supports delta load, you can pass a timestamp in standard internet date time format as value for this parameter in the SQL to retrieve data which has been modified after the specified time only. To fetch data page by page, use the WITH clause and specify a number for the page size.