Multiformat SQL Data Sets
Hey, Ted:

DDS-defined logical files can have multiple record formats, each one of them coming from different physical files of different types of data. I would like to do the same sort of thing in SQL. That is, I want to retrieve all the records from one file followed by all the records from a second file, grouped by one or more common key fields. This is not a join, and it doesn't seem like a union either, because the two data sets are so different. Am I trying to do the impossible? READ MORE >

Build Pivot Tables over DB2 Data
Hey, Ted:

If you already know about these, then just hit the ol' delete key on the message. I learned how to do this today. SQL is great for going 'down the page.' It's when they want data summed across that it gets to be a real kludge! Pivot tables are the answer. READ MORE >