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 TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
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.
We are trying to figure out exactly how, when and where EDAGET and EDAPUT are used and exactly the syntax.
From what we have been able to find out so far is that they are for "internal use" and only reside on the server. Does this mean that it varies by installation and it may not be available to everyone?
IBIers, is there specific documentation on these? And, are they commands or fexes?
And what release of WebFOCUS did they initially become available?
Thanks in Advance, VivianThis message has been edited. Last edited by: Vivian,
Vivian Perlmutter Aviter, Inc.
WebFOCUS Keysheet Rel. 8.0.2 (Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2 Focus since 1982 WebFOCUS since the beginning Vivian@aviter.com
They seem to be commands, same as FILEDEF or DEFINE, executed on the webfocus agent.
EDAPUT (which reads lines of code from the input stream and stores them as temp or permanent files) is used by MR to load resolved fex code onto the WFRS agent.
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005
Thanks for the replies. This provides some insight into the commands. You would think (hope) that IBI would provide the definitive documentation on these 2 gems. Maybe there is some somewhere...
Vivian
Vivian Perlmutter Aviter, Inc.
WebFOCUS Keysheet Rel. 8.0.2 (Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2 Focus since 1982 WebFOCUS since the beginning Vivian@aviter.com
ex edaget.... leading us to think of it as a fex and not a command...but I suppose you can execute a command that way.
I was thinking of
EX -LINESlineCount EDAPUT,...
where "EX -lines" is obviously a keyword phrase. (I suppose, once someone decided on the "-lines" syntax to signal special stacking for edaput, they added "EX" before it to prevent "-lines" from being taken as a dialog manager directive)
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005
They are just file management commands (not fexes). The PUT creates physical or memory based files, or can append to existing physical or memory based files. The GET is nothing more than a file retrieval command. Both of these commands were part of the EDA technology since version 2 (15-18 years ago). The GET was updated around version 4 (12 or so years ago) to allow binary retrievals.
I use the put for quick testing scenarios where I want to create quick content. I don't normally put it into production applications. That being said, it has come in very handy for very very specific scenarios: For example, a client had an ERP that would use a memory based XML document to manage all data changes until the data was to be committed. They wanted WF to build a PDF report of all the changes before they sent the XML object to the engine for processing. The problem is that there wasn't a physical file. We had them consume a web service for the adhoc_fex, and wrap the XML document with the EDAPUT then -INCLUDE the report at the end. That was a 10 minute solution that would have been very difficult multi-step execution without the EDAPUT.
EDAGET is just a convenient - and high performance - way to move files from the WFRS to a requester. For example, during the overnight runs, generate all the static drop down lists using ON TABLE HOLD AS xxx FORMAT XML into an application space. In the HTML file, rather than query the dimension table for the possible values, just use the EDAGET to retrieve the XML document. The drop down load will go from seconds to sub-seconds without breaking a sweat. The EDAGET also works fabulously for moving images from the WFRS to a browser in a split tier environment.
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
file-type - same as those defined by Waz (FEX/FTM/JPG/PNG ...) app - application space name (including foccache) filename - only the name, no extension content-type: T - text (xml/ftm ...) B - binary (png/jpg/gif ...) H - hex (havent found a need for this one yet)
By the way, this is not official. This is just the stuff I was able to put from old doc and some custom traces I built a long time ago.
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
Originally posted by dhagen: EDAGET is just a convenient - and high performance - way to move files from the WFRS to a requester. For example, during the overnight runs, generate all the static drop down lists using ON TABLE HOLD AS xxx FORMAT XML into an application space. In the HTML file, rather than query the dimension table for the possible values, just use the EDAGET to retrieve the XML document. The drop down load will go from seconds to sub-seconds without breaking a sweat. The EDAGET also works fabulously for moving images from the WFRS to a browser in a split tier environment.
Hi dhagen – Do you have a specific example of how to set this up? I would like to get faster performance for a particular control that I have that has over 9,000 records. This control is a single source tree control displaying a product hierarchy. I have created the XML as you mentioned and I have created a fex that execs the EDAGET and that works fine, but I question of how you link the fex to the HTML or do you actually insert the “EX EDAGET xml,baseapp/baseprod,t” into the HTML somewhere? If I link the fex that execs the EDAGET dynamically in the HTML Composer control property it doesn’t work for me. It locks up Developer Studio.
Reduce your XML document to 100 or so records and see if you have the same problem. 9K records is a s**t load of records to put into a web object. DS is probably not hanging, rather it is probably processing the response. If the response is working, then it will be trying to iterate through the response one element at a time. I've personally never seen any answer set > 2K process without a JS warning from the browser.
EDAGET may not be the answer here. You might want to look at a better way to manage such a large response set. There are many threads on this forum that talk about that. An example might be build a type-ahead input box and retrieve the first 20 LIKE matches.
But, to get back to your question: If you have the XML and a procedure to execute the command, then all you have to do is reference the FEX in object properties. I cannot remember what the option was in 7703, but I believe it was a radio button that states "Stored Procedure".
One more thing, the XML and T in your example should be in CAPS.
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott