Focal Point Banner


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.


Focal Point    Focal Point Forums    Search    Search Results
Page 1 ... 11 12 13 14 15 16 17 ... 61
Go
Search
Tools
Search Results: (1213 matches) New Search Login/Join 

Discussion Topic  RE: [CLOSED] Compare the record counts of two hold files within a focexec (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If the HOLD files contain just record counts, use SAVE instead of HOLD. Then: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Very basic column-value based color styling does not work (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Maybe be a bug - seems to work if I remove the COMPUTE or move the COMPUTE below SALES after the SUM......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Format Date as MD (9/12 for Today) (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Another option is to convert the date to a date-time field. Date-time fields have a few more format......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Format Date as MD (9/12 for Today) (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If you don't mind an alpha output format, function DATETRAN may do the trick: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] VBAR border (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Comparing text fields in two files (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Take a look at the SOUNDEX function to see if it might be helpful....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] previous month in master file (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Or this.... ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Convert time portion of DateTime field to alphanumeric HHMMSS format (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Function HPART or function HNAME may also work....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] ACROSSTITLE title styling in 7703 when SET ACROSSTITLE = SIDE (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Seems to be a problem/bug with EXL2K. It works correctly with FORMAT EXL07....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Full-time Job Opportunity in Seattle (in Events, Job Postings, Miscellaneous Announcements) by Dan Satchell
Job Description: BI WebFOCUS Developer Systems Analyst Programmer IV Clinical Decision Support Seat......
Focal Point > Focal Point Forums > Events, Job Postings, Miscellaneous Announcements

Discussion Topic  RE: <solved> how to get missing data to print (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
One final suggestion is to use: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: <solved> how to get missing data to print (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You could try PRINTing the records to a HOLD file. PRINT might extract all of the records (includin......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: <solved> how to get missing data to print (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Is the db2 source a single table or a view? You can check your db2 adapter parameter settings with ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: <solved> how to get missing data to print (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
SET ALL = ON ?...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Date Values lose Null Value when Format Specified and Passed to Hold Table (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If sorting by the date is necessary, besides Francis' excellent DEFINE solution, you could also use ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Date Values lose Null Value when Format Specified and Passed to Hold Table (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I seem to remember that you cannot dynamically re-format fields used in BY phrases. Although an err......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Date Values lose Null Value when Format Specified and Passed to Hold Table (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Maybe I am not understanding the issue, but in the following code null values are preserved (using W......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Help, difference between two times? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
HDIFF can return date-time differences down to the nanosecond level. Simple division math can tranl......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: "[SOLVED]"Many-to-Many merge with Match File? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If you scroll back to your original post (after login), there should be an icon in the lower right h......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: "[SOLVED]"Many-to-Many merge with Match File? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
@ Mark - As you may already know, use of the SUM verb instead of PRINT is the method by which one-to......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 11 12 13 14 15 16 17 ... 61 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders