Focal Point
[CLOSED] Help me out in finding the Master file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9287035766

February 27, 2014, 10:01 AM
Praveen Kumar
[CLOSED] Help me out in finding the Master file
Hi All,

I have mentioned the Focus Executable query below. Here, I have a table name called 'TGT_LOC_ALMT_VW' which is used in the procedue and a report is generated based on it.

TABLE FILE TGT_LOC_ALMT_VW
SUM MAX.LOAD_DTTM NOPRINT
PRINT
DST.LOCATION
WHERE EFF_STATUS = 'A';
WHERE TOTAL LOAD_DTTM EQ MAX.LOAD_DTTM
&WHERE_LOC
ON TABLE SAVE AS TLOC
END

My question here is, I am not able to find any corresponding Master file or Access file for this 'TGT_LOC_ALMT_VW' synonym.

What are all the different ways to find it?.

Please help me out in this.

This message has been edited. Last edited by: <Kathryn Henning>,


7.7.02, Windows Server 2008, All Formats
February 27, 2014, 10:53 AM
Tom Flynn
WHENCE TGT_LOC_ALMT_VW MASTER
-EXIT

If it's not found, a synonym needs to be created...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
March 02, 2014, 08:37 AM
Praveen Kumar
Hi Tom,

Can you kindly guide me where to execute this code to find out the synonym?.

Thank You.


7.7.02, Windows Server 2008, All Formats
March 03, 2014, 04:16 AM
Tony A
quote:
Can you kindly guide me where to execute this code to find out the synonym?.

If you are working in Dev Studio then use the help files to lookup WHENCE.

Also contact your local office to find out about training courses available in your area.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10