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     join sql passthrough files

Read-Only Read-Only Topic
Go
Search
Notify
Tools
join sql passthrough files
 Login/Join
 
Christine
Member
posted
I am trying to join a saved sql passthrough file to another file and I keep getting this error
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: FADOO6SQ
The file exists because I can print it but when I save it I can't do a join. here is the code.
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS FAD006SQ FORMAT ALPHA
END

Any help greatly appreciated.
 
Posts: 5 | Registered: May 11, 2006Report This Post
KevinG
Platinum Member
posted Hide Post
Christine,

By default, HOLD files are saved in the WF agent temp directory. They are available to that report for the duration of your session with that agent. Check into FILEDEF, which looks something like this;

FILEDEF holdname disk C:\ibi\baseapp

You should be able to JOIN within the same fex with out the FILEDEF.

Kevin


WF 7.6.10 / WIN-AIX
 
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005Report This Post
Leah
Virtuoso
posted Hide Post
By 'save' do you mean you say 'on table save as' to create a flat file. If the file is saved not held, you would need to tell FOCUS what the master file definition was. The HOLD option generates the MFD for you temporarily so you can do the joins. So I guess it's a matter of what you're trying to do with the output of the SQL passthrough. Does it need to be 'saved' or just 'held' to do further reporting and you are finished with it when the report has run.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
TexasStingray
Master
posted Hide Post
Christine

It soulds like you are doing you process as a multiple step process. Can you do you process as a one step. 

SQL.....
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS FAD006SQ_1 FORMAT ALPHA
END
SQL....
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS FAD006SQ_2 FORMAT ALPHA
END

JOIN ... IN FAD006SQ_1 TO ... IN FAD006SQ_2 AS Jx


If you cannot then try using APP HOLD xxx where xxx is the directory you want the DATA FILE and the MASTER FILE stored in then you will have to issue FILEDEF commands to both files so WebFOCUS can find the data and the xxx path will have to be your the app path.

Hope this helps




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
Christine
Member
posted Hide Post
Thank you all very much. I finally got a sample report to come back and can now expand it to the real one. Part of the problem was the order of which table I was joining to which.
 
Posts: 5 | Registered: May 11, 2006Report 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     join sql passthrough files

Copyright © 1996-2020 Information Builders