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     [SOLVED] Extract the all data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Extract the all data
 Login/Join
 
Raghuraman K
Member
posted
Hi,

I have two table name is emp and pltdetail. i have extract all the data from emp and extract which is match in empcode from emp to pltdetail. I tried but i can't extract that data. Please tell me how to extract the data. see the below example.


Table names:

emp
empcode emploc
------- -------
AAAAAA newyork
BBBBBB DETROIT
CCCCCC washinton
DDDDDD michigo


Pltdetail
empcode pltcode
-------- --------
AAAAAA 87
BBBBBB 95



FOCUS code:


join empcode in emp to empcode in pltdetial as jo1

table file emp
print empcode emploc pltcode
end

Result below.

empcode emploc pltcode
------- ------- -------
AAAAAA newyork 87
BBBBBB DETROIT 95


But i need entire data from emp.

like below

empcode emploc pltcode
------- ------- -------
AAAAAA newyork 87
BBBBBB DETROIT 95
CCCCCC washinton
DDDDDD michigo

This message has been edited. Last edited by: Kerry,


Raghuraman K
 
Posts: 26 | Registered: March 16, 2007Report This Post
jimster06
Guru
posted Hide Post
Are you familiar with the ALL parameter?

As in SET ALL = ON ?

You have what is commonly referred to as a short path error.

Look at the documentation for this parameter.


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
Danny-SRL
Virtuoso
posted Hide Post
What are the tables? Sequential files? SQL tables? Focus files?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
jimster06
Guru
posted Hide Post
Please also update your signature with platform and version info.


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
Raghuraman K
Member
posted Hide Post
Daniel,

it is sequential file.


Raghuraman K
 
Posts: 26 | Registered: March 16, 2007Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Raghuraman,

Are you files sorted by empcode?

See my example which works the way you want:
  
-* File Raghuraman1.fex
SET HOLDLIST=PRINTONLY

-*Only 3 records here
TABLE FILE CAR
SUM SALES/I5S
BY COUNTRY
IF COUNTRY LE ITALY
ON TABLE HOLD AS H1
END

-* 5 records here
TABLE FILE CAR
COUNT CAR
BY COUNTRY
ON TABLE HOLD AS H2
END

-* All 5 records and the joined fields here
JOIN COUNTRY IN H2 TO COUNTRY IN H1 AS Z

TABLE FILE H2
PRINT *
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
TexasStingray
Master
posted Hide Post
As stated above just set the ALL option. You want a left-outer join and this will give it to you.




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
Raghuraman K
Member
posted Hide Post
I have tried all statements but still i am get the all data.


Raghuraman K
 
Posts: 26 | Registered: March 16, 2007Report This Post
TexasStingray
Master
posted Hide Post
quote:
But i need entire data from emp.

like below

empcode emploc pltcode
------- ------- -------
AAAAAA newyork 87
BBBBBB DETROIT 95
CCCCCC washinton
DDDDDD michigo


you said you wanted all the data

use this

SET ALL = ON

join empcode in emp to empcode in pltdetial as jo1

table file emp
print empcode emploc pltcode
end




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
Raghuraman K
Member
posted Hide Post
Still it not working. i tried below code.


SET ALL=ON
JOIN CONCERN IN PWR TO CONCERN IN PWRSP AS J01

TABLE FILE PWR
PRINT HISTORY LEAD_MODEL MODEL_YEAR_ENG
CAUSAL_FACTOR_1 CAUSAL_FACTOR_2 CAUSAL_FACTOR_3
plant product
ON TABLE SAVE AS CONIN
END


But i have received the below error.
(FOC1070) VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED


Raghuraman K
 
Posts: 26 | Registered: March 16, 2007Report This Post
BlueZone
Platinum Member
posted Hide Post
Like the error says ..... Files being JOIN'ed should be pre-sorted on the Join-field.

Please resort one/both of the file(s) on the CONCERN field to Hold files as applicable. Then execute the join on the Hold files.

Sandeep Mamidenna


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Waz
Expert
posted Hide Post
the safest method to fix this issue is to table the PWRSP data and hold as a FOCUS format file indexing CONCERN, it will then give you what you want.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Raghuraman K
Member
posted Hide Post
Yes Now it is working.
I have sorted both file and i have joined two file. Now it is working.

Thanks for all.


Raghuraman K
 
Posts: 26 | Registered: March 16, 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     [SOLVED] Extract the all data

Copyright © 1996-2020 Information Builders