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 2 3 4 5 
Go
Search
Tools
Search Results: (91 matches) New Search Login/Join 

Discussion Topic  RE: [SOLVED] Not IN Sub-query (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
(Attached is the code that I'm trying to write in focus. Look at the Where pidm_key NOT IN the the c......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Not IN Sub-query (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Good morning, I am trying to write a query that will compare results to a sub-query. In sql I would......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Where clause in a focus file (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Thanks so much Francis...you are right....the field was not null but blank. I used the code for blan......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Where clause in a focus file (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Also, I tried pulling the same query by joining two oracle tables and it didn't work which is why i ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Where clause in a focus file (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Can someone please help me? I have joined two focus files and now want to extract data with paramete......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
show off...how about keep my job ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Thanks Tom...it's the same info i've been reading. Most of it gives syntax examples. I guess I have ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
OK guys...i'm sorry i found the webfocus technical documentation on the webfocus website. so i'm rea......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Hi j.g.... Where is this documentation? I'm using the help in Dev Studio. Is there something else I......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Hi GeraldCohen, Your suggestion makes a lot of sense. Since yesterday I've been fighting with the m......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
thanks for your patience....i've already started the match....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Hi Prarie...I tried the 2nd suggestion. I changed the single instance to multiple and change the joi......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
OK I tried the Set MULTIPATH...both simple and compound....no luck. I'll read up more on the match f......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Sorry I stepped out to lunch. GinnyJakes...I will try the Set Multipath. mgrackin it's interesting ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
FILENAME=AT_AR_BALANCE_BY_ENTITY, SUFFIX=SQLORA , $ SEGMENT=AT_AR_BALANCE_BY_ENTITY, SEGTYPE=S0, ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
SET ALL = ON JOIN LEFT_OUTER AT_AR_BALANCE_BY_ENTITY.AT_AR_BALANCE_BY_ENTITY.PIDM_KEY IN AT_AR_BAL......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
I've reviewed the ALL setting. I added the setting to the procedure, ran the report and got the same......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Thanks that's exactly what I'm doing...reading up on the set tool....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
No I haven't...where would i do that? Do i use the set icon (picture of light switch)? Hate to sound......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by kitten
Wow....who knew a join could be so complicated. I have been trying to pull this report since Monday ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2 3 4 5  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders