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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Join error
 Login/Join
 
<Lee Roper>
posted
I am trying to do a left outer join for a segment (SEGMENT_B) that requires a filedef to another segment (SEGMENT_A) that does not require a filedef. The host file will be SEGMENT_A. It is giving me the following error: (FOC1071) VALUE FOR JOIN 'TO' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED

I have no problems joining the files when I use SEGMENT_B as the host. It appears that I have the FILEDEF statement for SEGMENT_B in the wrong place, but every time I move, WebFocus doesn't recognize it.

Here's what I've written so far:

FILEDEF SEGMENT_B DISK /DATA/FILENAME.prn

JOIN SEGMENT_A.PIN IN SEGMENT_A TO SEGMENT_B.PIN IN SEGMENT_B AS J0

TABLE FILE BEN_ACT
PRINT
PIN
LNAME
END

Can someone tell me what I'm doing wrong?
 
Report This Post
Virtuoso
posted Hide Post
First, I will assume that you meant to type:
JOIN SEGMENT_A.PIN IN BEN_ACT TO SEGMENT_B.PIN IN SEGMENT_B AS J0

When you use a sequential file as the cross-ref, you have to ensure that the join field is sorted in the same order as the host. When the file is opened for reading, the pointer will only go from the top of the file to the bottom. If the PIN's are not in the same order, then the pointer has to go back up. WF cannot do that, subsequently the error.

If the SEGMENT_B file is not too big, you might want to hold it to a focus file with an index on PIN, and use the new file in the join.

FILEDEF SEGMENT_B DISK /DATA/FILENAME.prn

TABLE FILE SEGMENT_B
PRINT field1 field2 ... fieldn
BY PIN
ON TABLE HOLD AS TMPSEGF FORMAT FOCUS INDEX PIN
END

JOIN SEGMENT_A.PIN IN BEN_ACT TO TMPSEGF.PIN IN TMPSEGF AS J0

TABLE FILE BEN_ACT
PRINT
PIN
LNAME
END
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
<Lee Roper>
posted
Thanks for the response. However, because of the way my IS department configured the WF server, I can't use hold files. I have tried. Even the WebFocus tech support can't help.
 
Report This Post
Member
posted Hide Post
Can you hold a focus file with multiple indexes? For example, I have DIV-ID and ITEM-ID.


WebFOCUS 7.6.11, Windows XP, Excel, HTML, PDF
 
Posts: 25 | Location: Salt Lake City | Registered: June 03, 2008Report This Post
Expert
posted Hide Post
Lee,

Unless your IS department configured WebFOCUS without EDATEMP (and why would anyone do that?), there is no reason you cannot do what dhagen suggested. It is the perfect solution to your problem. The FOCUS hold file will be temporary and will go into EDATEAMP and disappear when your report is done.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
quote:
because of the way my IS department configured the WF server, I can't use hold files

I would get that one fixed first. This is MOST BASIC functionality. IF Techsupport can't help, then the problem is not being explained properly. You've either got a space allocation / disk addressing problem or a problem with user privileges and/or security.

Until that problem is fixed, you are EXTREMELY limited in your potential uses of WF.

On further thought, how would you create PDF or Excel files without being able to hold a file to disk. My understanding is that these are created on disk first in tempspace before being delivered to the final destination.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
Tee hee, Tom. That one's on me. I never even noticed the date. Darin got scammed as well. Razzer


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Member
posted Hide Post
GinnyJakes, Darin Lee and Tom Flynn,

Thank you for all of your input. I am able to index multiple fields for a hold.

ON TABLE HOLD AS HOLD11 FORMAT FOCUS INDEX ITEM_ID DIV_ID


WebFOCUS 7.6.11, Windows XP, Excel, HTML, PDF
 
Posts: 25 | Location: Salt Lake City | Registered: June 03, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders