Guest Posted December 29, 2020 Share Posted December 29, 2020 There is also the manual Using Funcitons which has a lot of the same information but different information too. Some of the functions may not be available in your release if it is not the latest. Running the following code in your environment shows what functions are available on your release, and basic usage documentation. (click the + to expand a section). SET EXPANDBYROWTREE=ON,SHOWBLANKS=ON DEFINE FILE SYSSQLOP FUNCTION_DESC/A999 = EDIT(FUNCTION,'99999999999999999999') | EDIT(FUNCTION_TYPE,'99999999999999999999') | FUNCTION_DESC; FUNCPARM_DESC/A999 = DIGITS(FUNPARM_IND,2) |' '| EDIT(FUNPARM,'9999999999999999999') | EDIT(FUNPARM_TYPE,'99999999999999999999') | FUNPARM_DESC; FUNPVAL_DESC2/A999 = DIGITS(FUNPVAL_IND,2) |' '| EDIT(FUNPVAL,'99999999999999999999') |FUNPVAL_DESC ; END TABLE FILE SYSSQLOP "Function Reference" SUM CATEGORY NOPRINT BY CATEGORY AS '' BY FUNCTION_DESC AS '' BY FUNCPARM_DESC AS '' BY FUNPVAL_DESC2 AS '' WHERE SUFFIX GT 'EDA' ON TABLE ON TABLE NOTOTAL ON TABLE SET STYLE * TYPE=REPORT, FONT=CONSOLAS,$ TYPE=HEADING, JUSTIFY=LEFT, FONT=ARIAL, SIZE=14,$ END Link to comment Share on other sites More sharing options...
NYCBabak . Posted December 29, 2020 Author Share Posted December 29, 2020 I discovered this little gem by accident. It contains everything you wanted to know about WebFOCUS functions and were afraid to ask. I thought I share the link as its a comprehensive list of functions, including the new simplified conversion (character, date and numeric) functions as well as forecasting, statistical and analytic functions (e.g.Correlation and Kmeans Cluster). webfocusinfocenter.informationbuilders.com dmfunc_8207.pdf 4.97 MB Link to comment Share on other sites More sharing options...
Charles Morris 2 Posted December 31, 2020 Share Posted December 31, 2020 The Functions manual(s) have been 1 of my go-to references for many yrs and one I always told customers to download. David, I was never aware there was a way to generate the information via a fex - thx for this! Link to comment Share on other sites More sharing options...
Toby Mills Posted January 4, 2021 Share Posted January 4, 2021 Thanks @nycbabak and @david.beagan! I sat out of development for so long just doing troubleshooting that I appear to have fallen behind. Theres a lot more going on here. Ill need to go read more to see whats what. As the Dude would say Im not privy to all the new shtuff. Im so old that I remember the skinny but tall functions manual from the 1980s. I kind wish I handnt thrown all my old manuals away just for nostalgia. Thanks again. Toby Link to comment Share on other sites More sharing options...
Naeem Sufi 3 Posted January 14, 2021 Share Posted January 14, 2021 Same for me Toby you helped me convert from WF 7.6.11 to WebFocus 8, and if you remember converting that large RC repository The tools you showed me at that time were very helpful , now I am looking into upgrading to 8.2.7 I am new to myIBI and if you can point me to threads where 8.1.5->8.2.7 topics are discussed that will be very helpful Thanks Again Naeem Link to comment Share on other sites More sharing options...
NYCBabak . Posted January 14, 2021 Author Share Posted January 14, 2021 Theres a migration utility for 8.1 to 8.2 upgrades. https://webfocusinfocenter.informationbuilders.com/wfappent/TL4s/TL_install/source/migrate_cfg_8203.htm Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now