Re: Normalize DB record using SQL

[Jeff Young <cooljeff913@xxxxxxxxx>]

Thanks Dennis.

 
Jeff Young 
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3 
  
 






________________________________
From: Dennis Lovelady <iseries@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Fri, June 4, 2010 10:18:35 AM
Subject: RE: Normalize DB record using SQL

Actually I didn't think that quite through.  This is better:

SELECT KEYA, KEYB, KEYC, 01 as MTHNBR, JANUARY FROM MYTABLE
UNION
SELECT KEYA, KEYB, KEYC, 02 as MTHNBR, FEBRUARY FROM MYTABLE
UNION
...

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"April 1. This is the day upon which we are reminded of what we are on the
other three hundred sixty-four."
        -- Mark Twain 


> > I have a file with fields for each month of the year, and would like
> to
> > create a view that would give me one record for each month using SQL.
> >
> >
> > Can someone give me an example of how to do this?