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     Rebuild/Reorg Utility to Add Fields to .FOC Files

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Rebuild/Reorg Utility to Add Fields to .FOC Files
 Login/Join
 
Gold member
posted
When I use the Rebuild/Reorg Utility to add fields to my .FOC file, the file from the Load step is in a temporary directory "C:\ibi\DEVSTU~1\SRV76\...\ACTIVIT2.FOC". It is ignoring my FILEDEF. How do I get the file to go in my C:\IBI\APPS\.. Directory?

My JCL:

-SET &ECHO=ALL;
? FDT ACTIVIT2
SET REBUILDMSG = 50000
REBUILD
REORG
DUMP
ACTIVIT2
NO
? FDT ACTIVIT2
COPY C:\IBI\APPS\AJLMAINMENU\ACTIVITN.MAS C:\IBI\APPS\AJLMAINMENU\ACTIVIT2.MAS
ERASE C:\IBI\APPS\AJLMAINMENU\ACTIVIT2.FOC
FILEDEF ACTIVIT2 DISK C:\IBI\APPS\AJLMAINMENU\ACTIVIT2.FOC
? FDT ACTIVIT2
REBUILD
REORG
LOAD
ACTIVIT2
? FDT ACTIVIT2

This is the Runlog:

0 DIRECTORY:C:\ibi\apps\ajlmainmenu\activit2.foc ON 06/18/2008 AT 08.33.55
DATE/TIME OF LAST CHANGE: 06/18/2008 08.33.55
0 SEGNAME LENGTH PARENT START END PAGES LINKS TYPE
1 ACTACCT 182 1 14111 1118 3
2 ACTDETL 77 1 2 14118 8578 2
3 PARTNO 70 1 3 14117 1760 3
4 RDNO 24 3 4 14119 1652 2
LOGACCT 5 11705 12 NEW
ASEQNO 6 13791 21 NEW
ITEMNO 7 13922 292 NEW
PART 8 14081 221 NEW
RDDATE 9 14097 204 NEW
RDNO 10 14089 261 NEW
Enter option
1. REBUILD (Optimize the database structure)
2. REORG (Alter the database structure)
3. INDEX (Build/modify the database index)
4. EXTERNAL INDEX (Build/modify an external index database)
5. CHECK (Check the database structure)
6. TIMESTAMP (Change the database timestamp)
7. DATE NEW (Convert old date formats to smartdate formats)
8. MDINDEX (Build/modify a multidimensional index)
REORG
ENTER THE REORG PHASE (DUMP OR LOAD)
Enter option
1. DUMP (DUMP contents of the database)
2. LOAD (LOAD data into the database)
DUMP
ENTER NAME OF FOCUS/FUSION FILE
ANY RECORD SELECTION TESTS? (YES/NO)
STARTING..
REFERENCE..AT SEGMENT 50000
REFERENCE..AT SEGMENT 100000
REFERENCE..AT SEGMENT 150000
REFERENCE..AT SEGMENT 200000
NUMBER OF SEGMENTS RETRIEVED= 200419
1 file(s) copied.
Enter option
1. REBUILD (Optimize the database structure)
2. REORG (Alter the database structure)
3. INDEX (Build/modify the database index)
4. EXTERNAL INDEX (Build/modify an external index database)
5. CHECK (Check the database structure)
6. TIMESTAMP (Change the database timestamp)
7. DATE NEW (Convert old date formats to smartdate formats)
8. MDINDEX (Build/modify a multidimensional index)
REORG
ENTER THE REORG PHASE (DUMP OR LOAD)
Enter option
1. DUMP (DUMP contents of the database)
2. LOAD (LOAD data into the database)
LOAD
ENTER NAME OF FOCUS/FUSION FILE
STARTING..
REFERENCE..AT SEGMENT 50000
REFERENCE..AT SEGMENT 100000
REFERENCE..AT SEGMENT 150000
REFERENCE..AT SEGMENT 200000
NUMBER OF SEGMENTS INPUT= 200419
0 DIRECTORY:C:\ibi\DEVSTU~1\srv76\...\activit2.foc ON 06/18/2008 AT 08.34.17
DATE/TIME OF LAST CHANGE: 06/18/2008 08.34.17
0 SEGNAME LENGTH PARENT START END PAGES LINKS TYPE
1 ACTACCT 182 1 14070 1117 3
2 ACTDETL 82 1 2 14085 8577 2
3 PARTNO 70 1 3 14080 1732 3
4 RDNO 24 3 4 14082 1651 2
LOGACCT 5 13561 12 NEW
ASEQNO 6 13170 20 NEW
ITEMNO 7 14034 289 NEW
PART 8 13837 226 NEW
RDDATE 9 14083 201 NEW
RDNO 10 14081 260 NEW



Thanks, Kent


Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE
 
Posts: 63 | Location: Ft. Wayne, IN | Registered: February 20, 2007Report This Post
Virtuoso
posted Hide Post
Kent,

FILEDEF is meant for fix format files, such as .ftm, .txt.
If you need to address a focus file that is in another directory, use the USE statement.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Expert
posted Hide Post
Have you tried setting APP HOLD {app name}

Oops

GamP is right, use USE
USE
{app}/ACTIVIT2.FOC NEW
END


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
Gold member
posted Hide Post
Thanks for the quick response. That is what I needed.

Kent


Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE
 
Posts: 63 | Location: Ft. Wayne, IN | Registered: February 20, 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     Rebuild/Reorg Utility to Add Fields to .FOC Files

Copyright © 1996-2020 Information Builders