RE: dynamically store a rolling six years of data in a table andhavemeaningful column field names and descriptions that canchangeyear-to-year?

[<elehti@xxxxxxxxxxxxxxxxxx>]

Bill,
Your recommendation to do an SQL Select with Case statements is great
and I thank you.
 
Your observation made me give myself a dope slap because I had forgotten
that I have previously used STRQMQRY with output parms to create files
with descriptive column names, shown here:

STRQMQRY   QMQRY(F55PROFE) OUTPUT(*OUTFILE) +      
             OUTFILE(PLAN/F55PROFE) SETVAR((BEGIN +
             &PSOPT1) (END &PSOPT2))               

The QMQRY logic is:
SELECT
TDAC05,TDELNM,SDADDJ,SDDOCO,SDDCTO,SDAN8,TDMNNS,TDCTYS,TDADDO,TDADZO,

SUM(CASE WHEN SDSRP1='HDW' THEN SDAEXP * 0.01 ELSE 0 END)

AS WoodGateHdw,

SUM(CASE WHEN SDSRP1='HDW' THEN TD$PXP   ELSE 0 END)

AS WoodGateHdw_Profit,

SUM(CASE WHEN SDSRP1='QR ' THEN SDAEXP * 0.01 ELSE 0 END)

AS  QuickRok,

 { and many more SUM AS statements omitted here}

FROM F42119J9  WHERE SDADDJ  BETWEEN &BEGIN   AND &END

AND SDKTLN=0

AND SDDCTO IN('SO', 'SC','SP')

AND SDLNTY IN('P','S','C')

AND SDMCU NOT IN('         350','        2000')

AND SDTORG  NOT IN('LMITCHELL',  'JMCINTYRE' )

 GROUP BY TDAC05,TDELNM,SDADDJ,SDDOCO,SDDCTO,SDADDJ,SDDOCO,SDDCTO,SDAN8,

          TDMNNS,TDCTYS,TDADDO,TDADZO

ORDER  BY TDAC05,TDELNM,SDADDJ,SDDOCO,SDDCTO,SDADDJ,SDDOCO,SDDCTO,SDAN8,

          TDMNNS,TDCTYS,TDADDO,TDADZO