[CLOSED] HYYWD example

October 24, 2011, 03:43 PM

Hi,

Has any one used HYYWD function before?
I tried using it on one of my timestamp column in DB2 UDB, but it fails with the following error.

(FOC263) EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: HYYWD

I tried using the instruction based on following http://documentation.informati.../source/topic111.htm

My Code:

  
DEFINE FILE ABC
WEEKNUM/A10=HYYWD(TIMESTAMP_COL,'A10');
END 
               
TABLE FILE ABC
PRINT 
	WEEKNUM
WHERE READLIMIT EQ 10
END

Best Regards,

Jimmy Pang

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

October 24, 2011, 05:05 PM

Waz

You may have to pass this on to Techsupport.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

October 24, 2011, 05:17 PM

Francis Mariani

This works in v7.7.03:

TABLE FILE CAR
PRINT
COMPUTE DTTM1/HYYMD=DT(&YYMD 12:00AM);
COMPUTE DTTM2/A10 = HYYWD(DTTM1, 'A10');

BY COUNTRY
END

Make sure this function is available for the release of the reporting server you're running on.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

October 24, 2011, 05:28 PM

Waz

Francis' code works in 7.6.5 and 7.6.9.

Perhaps the install is bad ?

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 01, 2011, 03:28 PM

fatboyjim

Thanks for all your replies.

I actually used the following to extract the week component.

  
WEEK_COMPONENT/A10 = HNAME(CREATE_DATE, 'WEEK', 'A10');

Thanks again.

Best Regards,

Jimmy Pang