 |
|||||
|
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 |
| DEFINE and WHERE report limits | Login/Join |
| Platinum Member |
I'm running webfocus version 5.3 and am trying to run a script that incrementally adds a new parameter for purposes of gathering data, it goes something like so: DEFINE FILE CAR MYCARID/A8= IF(MAKE = 'CHEVROLET' AND MODEL = 'CAMARO' AND COLOR = 'RED') THEN '0808909001' ELSE IF(MAKE = 'CHEVROLET' AND MODEL = 'TRAILBLASER' AND COLOR = 'BLUE') THEN '0909090901' ELSE ... END TABLE FILE CAR MYCARID MAKE YEAR WHERE (MAKE = 'CHEVROLET' AND MODEL = 'CAMARO' AND COLOR = 'RED') OR (MAKE = 'CHEVROLET' AND MODEL = 'TRAILBLASER' AND COLOR = 'BLUE') OR ... END My question here is whether WebFOCUS actually has a limit on these sections. I found that after about 100 or so of these repeated find and define lines of code, the processing time almost triples. Is there an easier way to do this or is it pretty much downhill from here? I would use an external database file to reference these values but I am not sure how I can do something like that, my experiences with FILEDEF in WebFOCUS has not been all that great. Any suggestions? Thanks! | ||
|
| Platinum Member |
G, Why wouldn't you test for the values you DEFINEd using the WHERE statement in your TABLE request as; WHERE MYCARID EQ '0808909001' OR '0909090901' ??? See if your performance is still bad... Kevin WF 7.6.10 / WIN-AIX | |||
|
| Platinum Member |
I think I'll try it out. Performance-wise, does anyone know if its more efficient to write it out like this: WHERE MYCARD ID IN ('VALUE1','VALUE2'....'VALUE100') or WHERE (MYCARD EQ 'VALUE1') OR (MYCARD EQ 'VALUE2') ... OR (MYCARD EQ 'VALUE100') Thanks again! I hadn't thought about using the DEFINE'd values, but hopefully this'll shave off some time as is. | |||
|
| Guru |
You should always try to do your WHERE statements against database fields as opposed to DEFINEd fields. That way you are not evaluating the DEFINE for rows you will not ultimately keep. ttfn, kp Access to most releases from R52x, on multiple platforms. | |||
|
| Guru |
BTW... is the MYCARID broken down into sections or is each number random... I mean do some of the digits represent Chevrolet and some represent Blue, etc? ttfn, kp Access to most releases from R52x, on multiple platforms. | |||
|
| Platinum Member |
Well, that's just the thing, the code that gets put in can be completely random. So it can say "HelloWorld" and really have no relationship with MAKE or MODEL. That's where the connundrum rolls in because I can suddenly just say instead of putting 2007JaguarXtype, it can go to 2007HelloWorld. And after about 100 of those DEFINE...ELSE statements I wonder if it's taking a toll on the processing time... | |||
|
| 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 |