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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Multi feild Join between a Hold file and Oracle table

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Multi feild Join between a Hold file and Oracle table
 Login/Join
 
Member
posted
Hi all,

we have a requirement where in we have to join hold file with Oracle table with multiple keys. is it possible to achieve this?

Thanks
Aparna
 
Posts: 3 | Registered: October 26, 2006Report This Post
Virtuoso
posted Hide Post
This should be possible.

To join to the Oracle table use the syntax:
JOIN
field1 AND field2 AND field3 IN HOLDFILE
TO field1 AND field2 AND field3 in oracletable
END


To join from the Oracle table use the syntax:
JOIN
field1 AND field2 AND field3 in oracletable
TO field1 AND field2 AND field3 IN HOLDFILE
END

the main difference is when you join to a HOLD file the fields you join to have to be in the sequence of the output from the Oracle request, that is, used as sort fields. Otherwise you will get an OUT OF SEQUENCE error.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Virtuoso
posted Hide Post
I agree with Alan, of course depending on where your hold file resides and where your oracle table resides may cause some performance issues. I join hold files back to DB2 tables all the time, but if the hold file is large number of records, I will often pull the DB2 data from the table with a separate request, create a hold file then join the two hold files.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Virtuoso
posted Hide Post
Very true Leah, a lot of records will give performance issues and dragging data back with a seperate request can be worthwhile.

You can join multiple field from hold to hold, sequence again permitting.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Multi feild Join between a Hold file and Oracle table

Copyright © 1996-2020 Information Builders