Creating Yes/No Fields in SQL Queries
Hey, Ted:

I want to retrieve a list of customers using SQL. I know how to select the customers I want. What I don't know how to do is create some columns that are not stored in the database, but must be built from information in other files. For example, I want a column that tells whether or not the customer has an open (unfulfilled) order. I'd also like a column that tells if he has ever bought a certain line of product. There are no fields in the customer master file that store this information. Can you help? READ MORE >

A Few Excel Export to CSV Tips
by Michael Sansoterra

Comma separated variable (CSV) files are frequently used when exporting DB2 data for use with Microsoft Excel. However, because CSV files contain text without any additional formatting instructions, it can be somewhat time-consuming for users to format their worksheets whenever they get a new export. This tip will address a few of the shortcomings of using CSV files with Excel and present a few possible workarounds to make the lives of your Excel user community easier. READ MORE >