Focal Point
McGuyver Techniques with Examples.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7431005342

August 24, 2007, 04:02 AM
kalyanswarna
McGuyver Techniques with Examples.
Hi All,
i am looking for Examples for all McGuyver Techniques. i knew that this tech were availble in Focal point under Tips and Tech but the thing is here all tech are explained usind Mainframe focus and it's very difficult to understand.
please let me know if anyone having Examples with CAR in WebFOCUS for all these tech.

Thanks,
Kalyan.S
kalyanswarna@gmail.com
August 24, 2007, 04:07 PM
Leah
This gives an example of how you can multiply the number of occurances, you could then do different things based on the value of counter:
Note if the hold file with the counter is not created as an indexed focus file the world does not multiply the data and weird things occur.

DEFINE FILE CAR
BLANK/A1 WITH MODEL = ' ';
COUNTER/I1 WITH MODEL = COUNTER + 1;
END
TABLE FILE CAR
PRINT
COUNTER
BY BLANK
WHERE RECORDLIMIT EQ 5
ON TABLE HOLD AS HOLD1 FORMAT FOCUS INDEX BLANK
END
JOIN BLANK WITH MODEL IN CAR TO ALL BLANK IN HOLD1 AS J1
DEFINE FILE CAR
BLANK/A1 WITH MODEL = ' ';
END
TABLE FILE CAR
PRINT *
BY COUNTER
END


Leah
August 25, 2007, 03:53 PM
GCohen
See the Tech Doc Link
http://techsupport.informationbuilders.com/bestpractices/macgyver/toc.html


Release 7.6.9
Windows
HTML
August 27, 2007, 09:19 AM
jgelona
I've still got that issue of the Systems Journal. I reference that issue more than any other.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.