I am new to WebFOCUS and not sure how it can use a self-contained subquery to pass a single value. Below is my sample code. Any help would be appreciated.
DEFINE FILE TableOne
CRDATE/YYMD = HDATE(CalendarDate, 'YYMD');
TABLE FILE TableOne
WHERE CalendarDay EQ &YYMD
ON TABLE HOLD AS CRWEEK
TABLE FILE TableTwo
WHERE CalendarWeek EQ CRWEEK.CalendarWeekThis message has been edited. Last edited by: <Emily McAllister>,
Windows, All Outputs
WHERE CalendarWeek IN FILE CRWEEK;
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
Wep probably has guessed it right, but I find your code confusing. Your DEFINE creates a new filed called CRDATE that you don't explicitly reference in your table, so I'm wondering why you included the DEFINE in your example.
In your first TABLE you don't have a VERB or OBJECTS so it's tough to figure out what the intention is - what you will get are some values that have CalendarDay equal to today.
The second TABLE references CalendarWeek. Is this a database field?
Finally, since the first TABLE will just give you back today's date, why not just plug in &YYMD in the second table?
WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
|Powered by Social Strata|