Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] DECODE for Month Order
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] DECODE for Month Order
 Login/Join
 
Gold member
posted
I need to list the year in month order, not alphabetical order. Here is what I have but it does not order correctly. Any suggestions?

DEFINE FILE METRIC_DATA_HOURS
MO/A12=DECODE MONTH
(January January
February February
March March
April April
May May
June June
July July
August August
September September
October October
November November
December December );
END
TABLE FILE METRIC_DATA_HOURS
PRINT
DST.MO
BY MO
ON TABLE PCHOLD FORMAT XML
END


Thanks,
Denise

This message has been edited. Last edited by: DMA,


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi Densie,

can you remove BY MO statement from the TABLE file METRIC_DATA_HOURS, because you are using BY MO it is sorting with alphabetical order.

try that once. It should work...

Regards,
Anmol


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
 
Posts: 72 | Registered: June 30, 2009Reply With QuoteReport This Post
Gold member
posted Hide Post
Anmol,

I have removed the BY MO statement and it still sorts alphabetically.

Thanks,
Denise


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
DEFINE FILE METRIC_DATA_HOURS
MO_SORT/A2=DECODE MONTH (
'January'   '01'
'February'  '02
'March'     '03'
'April'     '04'
'May'       '05'
'June'      '06' 
'July'      '07'
'August'    '08'
'September' '09'
'October'   '10'
'November'  '11'
'December'  '12' );
END
TABLE FILE METRIC_DATA_HOURS
SUM
  DST.MONTH
BY MO_SORT
ON TABLE PCHOLD FORMAT XML
END
 


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1956 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Tom,

Thanks so much for your input, works perfectly.

Denise


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] DECODE for Month Order

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.