 |
|||||
|
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. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] How does EVAL function | Login/Join |
| Gold member |
All, Could anyone explain me the process flow of this code. -SET &TABLE=SUM&CAR.EVAL; -IF &CAR NE TOYOTA THEN GOTO LABEL; -SET &TABLE=TOTAL&CAR.EVAL; TABLE FILE SUM&CAR.EVAL SUM SALES BY &CAR ON TABLE HOLD AS &TABLE END JOIN &CAR IN &TABLE TO ALL &CAR IN SUM&CAR END -LABELThis message has been edited. Last edited by: Kerry, In Focus since 2008 WebFOCUS 8.2.0.1 Windows 7 - IE,Chrome,Firefox Excel, PDF, HTML, AHTML, XML JavaScript, jQuery, D3.js, Highcharts | ||
|
| Expert |
This seems to be only part of the complete code... So I can only give part of the answer. Apparently, &CAR has beet -SET prior to what we see here (We'll use 'FORD'). Seein g that 'FORD" is not 'TOYOTA" (and why should it be?) Then the fex branches to "LABEL" (which is a bad name, imho, for a "LABEL". But, if &CAR was 'TOYOTA' then it would fall thru and do the "-SET &TABLE=TOTAL&CAR.EVAL;" which eqautes to &TABLE being -SET to 'TOTALTOYOTA'. The .EVAL evaluates the variable before the line is interpreted... ending up with TABLE FILE SUMTOYOTA SUM SALES BY &CAR ON TABLE HOLD AS TOYOTA END JOIN TOYOTA IN TOTALTOYOTA TO ALL TOYOTA IN SUMTOYOTA AS JOIN1 -* I added the JOIN1 -* No need for this extraneous "END" -LABEL -*-*-* continues on with processing..... or, at least that's what I think... | |||
|
| Virtuoso |
Syntactically correct code would be for instance: -SET &TABLEsum='SUM&CAR.EVAL'; -IF &CAR NE 'TOYOTA' THEN GOTO :LABEL; -SET &TABLEtot='TOTAL&CAR.EVAL'; TABLE FILE &TABLEsum SUM SALES BY &CAR ON TABLE HOLD AS &TABLEtot END JOIN &CAR IN &TABLEtot TO ALL &CAR IN &TABLEsum AS J1 -:LABEL It is a wise thing to keep strings strings. So enclose them in single quotes. To prevent DM to place the &CAR in the string as is, expand it with .EVAL. Otherwise the variable &TABLEsum would have the value 'SUM&CAR', with .EVAL it will be set to 'SUMFORD' (to go with Doug's example). And I agree with Doug, naming a label LABEL is not such a good idea. I make it a rule for myself to start a label (any label) with a colon ( : ). But that's my own private naming convention... GamP
| |||||||||
| ||||||||||
| Expert |
From memory, its been a while, this is all explained in the FOCUS training courses. The interesting thing here is why use EVAL in a -SET. You can use -SET &TABLE='SUM'|&CAR; The same is achieved with -IF &CAR NE TOYOTA THEN GOTO LABEL; TABLE FILE SUM&CAR SUM SALES BY &CAR ON TABLE HOLD AS TABLE&CAR END JOIN &CAR IN TABLE&CAR TO ALL &CAR IN SUM&CAR END -LABEL Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
Well put guys... This seems to be some incomplete code (which was presented) So, I just went with that... You both pointed out some "cleaner" (Best Proactices) code which nsk110483 and all others can benefit... nsk110483 : What do you think? Did we answer this for you? Or, would you like some more, generously offered, insight? | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |