As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
In what order does WebFocus evaluate alphanumeric type data for the min and max function? I can't seem to find something like:
Why? I have 4 columns of data
Program Title (no null/missing, A62V) Honours (most null or missing, A30V) Major1 (some null or missing, A30V) Ext_Minor (most null or missing, A30V)
AREA_OF_STUDY/A62V = IF HONOURS NE '' OR HONOURS IS NOT MISSING THEN HONOURS ELSE IF MAJOR1 NE '' OR MAJOR1 IS NOT MISSING THEN MAJOR1 ELSE IF EXT_MINOR NE '' OR EXT_MINOR IS NOT MISSING THEN EXT_MINOR ELSE PROGRAM_TITLE
HONOURS/A30V = IF LFOS EQ 'Honours' THEN FOS_DESC MAJOR1/A30V = IF LFOS EQ 'Major' THEN FOS_DESC EXT_MINOR/A30V = IF LFOS EQ 'Extended Minor' THEN FOS_DESC
I get way, way more blanks than I should this way. Any suggestions?This message has been edited. Last edited by: <Kathryn Henning>,
WebFocus 8.104 Windows 7 Entreprise, SP1
Posts: 82 | Location: Abbotsford BC | Registered: March 15, 2010
sometimes it has to do with the db you're using; so do something like this. take 1 record, 1 you know has some things missing and some not, and test it carefully. DEFINE FILE THING switch1/I1 = IF HONOURS IS MISSING THEN 0 ELSE 1; switch2/I2 = IF MAJOR IS MISING THEN 0 ELSE 1; ...etc END TABLE FILE THING PRINT switch1 switch2 switch3 switch4 HONOURS MAJOR EXT_MINOR PROGRAM_TITLE IF RECORDLIMIT IS 1 (or whatever filter gets you the single record you've chosen to evaluate). This way you'll see exactly how you're evaluating your records. Maybe EQ '' will do it, but that won't work in 77 so just fyi. Lots of things you can try. ARGLEN of each value is another one, if you're really stumped.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003