One of the most powerful capabilities at your disposal when using SQL*Loader is the ability to define a SQL expression that operates on a field being loaded. Instead of loading the contents of the field, SQL*Loader loads the results of the expression. Consider the following book price data  Fields and Datatypes:

You know that DB2 for z/OS Version 8 is where you really want to be. You've read all the articles and seen all the presentations describing the new features, functions, and other things V8 makes available to you. The list of cool stuff in DB2 V8 just goes on and on. You are also very much aware that Version 8 has not only been generally available (GA) now for well over 3 years, DB2 9 for z/OS has already been GA for 4 months.  

In most cases, SQL Server Optimizer generates optimal plans. It is impossible to compete with its internal knowledge of average disk access cost, record length or page fill ratio. But, there is one area where human expertise is always superior.

Partitioned tables are a new feature available in SQL Server version 2005, aimed mainly at improving the performance of large database systems. The feature is only available for enterprise and developer edition. For other editions you can get a similar functionality with a partitioned view.

This is the last installment of a four part article on SQL Server Reporting Services:     * Part 1, provided a step-by-step guide to basic report creation and     * Part 2 took a tour of some of the core SSRS features and functions that you'll need to develop dynamic reports     * Part 3 focused entirely on the built-in SSRS chart control.

This is Part 3 of a four-part article series on SQL Server Reporting Services 2005 (SSRS). Part 1 provided a step-by-step guide to basic report creation and Part 2 took a tour of some of the core SSRS features and functions that you'll need to develop dynamic reports. Here, we turn our attention to the chart control that ships with SSRS.