Paul Zikopoulos

So far in this series about the IBM Data Studio Developer integrated development environment (IDE) that’s available with DB2 Version 9.5 (DB2 9.5), I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2) to some of the features […]

So far in this series about the IBM Data Studio integrated development environment (IDE) that’s available with DB2 Version 9.5 (DB2 9.5), I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2) to some of the features available […]

So far, in this series about the IBM Data Studio integrated development environment (IDE) that’s available with DB2 Version 9.5 (DB2 9.5), I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2) to some of the features available […]

So far in this series about the IBM Data Studio integrated development environment (IDE) that’s new with DB2 9.5, I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2) to some of the features available in the Database […]

At the IBM Information Management Information on Demand (IOD) conference in Las Vegas in October 2007, IBM made a number of major announcements, which included the christening of the DB2 Viper 2 beta as DB2 Version 9.5 (DB2 9.5), and the introduction of a new toolset for IBM data servers (DB2 for Linux, UNIX, and […]

As I’ve been introducing you to the IBM Data Studio integrated development environment (IDE) that’s new with DB2 9.5, I’ve shown you how to set up database connection objects and the actions that you can perform on them. In this article, I want to delve deeper into the overview diagrams that I introduced you to […]

Connected Database Object Options from the Database Explorer View In this new series, we are exploring the integrated development environment (IDE) of IBM Data Studio (formerly known as IBM Data Server Developer Workbench during the open beta), which is new with DB2 9.5 (formerly known as DB2 Viper 2). In Part 1 of this series, […]

Part 1: An Introduction to the Database Explorer If you use IBM DB2 9 (DB2 9) to power up your business, you’re likely aware of the Eclipse-based DB2 Developer Workbench (DB2 DWB). This toolset delivered enormous productivity to the application development life cycle. About this tool, builder.au (an organization that pitches themselves as “by developers […]

In my previous article called DB2 9 and Microsoft Excel 2007: Getting the Data DB2 9, I showed you how easy it is to get data from an IBM DB2 9 data server into your Excel 2007 worksheets. I also showed you some of the neat Excel 2007 capabilities to ‘dress-up’ your data. In this […]

In my last two articles on Microsoft Excel 2007 (Excel 2007) and DB2 I showed you how to get DB2 data into your worksheets and work with that data with some of the new advanced and very powerful features that are new in Excel 2007; at the same time, I’ve been introducing you to the […]

In my last article, I showed you how to get DB2 data into your Microsoft Excel 2007 (Excel 2007) worksheets. In addition, I showed you some nice formatting capabilities in Excel 2007 and how to apply them to your DB2 data. In this article, I want to show you some additional advanced features, and some […]

Without a doubt, Microsoft Excel, is the world’s most ubiquitous reporting and data analysis tool. Quite often I see clients export massive amounts of data from their enterprise systems into another data server (guess which one) for the sole purpose of supporting Excel reporting. The main problems associated with this approach are as follows: 1.  […]