I have one MASSIVE fex I run each night which, in turn, runs about 50+ other jobs. It has become so big that I'm running out of memory.

Is there some way I can clear out all the temp files I don't need and free up memory so the job can finish? I know the simple solution is to crate two jobs to run each night but I'd really like to keep it as one master program.

Marc

You could run an OS command to delete all the files in the current agent's directory between each step - determine the agent's directory with this command:

-SET &TEMPDIR = TEMPPATH(60,'A60');

This MASSIVE fex does sound like soemthing that should be broken dowsn and run in steps via ReportCaster.

I thought this would work, but it looks like it doesn't - the agent seems to get stuck at the DOS DEL command. So I will not recommend doing this.

-SET &ECHO=ALL;
TABLE FILE CAR
PRINT *
ON TABLE HOLD AS H001
END
-RUN

-*-- DETERMINE THE AGENT'S TEMP DIRECTORY ---
-SET &TEMPDIR = TEMPPATH(60,'A60');

-*-- DELETE THE TEMPORARY FILES IN THE TEMP DIRECTORY ---
DOS DEL &TEMPDIR.EVAL\*.FTM
DOS DEL &TEMPDIR.EVAL\*.MAS
-RUN

TABLE FILE CAR
PRINT *
ON TABLE HOLD AS H002
END
-RUN

Francis,

Your working directory is the temp directory, so you do not need to know what it is called. Do the following instead:

-SET &ECHO=ALL;
TABLE FILE CAR
PRINT *
ON TABLE HOLD AS H001
END
-RUN

-*-- DELETE THE TEMPORARY FILES IN THE TEMP DIRECTORY ---
!del *.FTM
!del *.MAS
-RUN

d,

Thanks for that. What is !del by the way - DOS or platform independent?

Cheers,

The bang (!) is the platform agnostic way of making a call to the OS. "del" is delete. If I was on unix, I would do it as !rm *.mas (I think).

Thanks for the help, everyone. But I'm on a VAX (please don't laugh!) so is there something different I need to do?

And that command isn't going to remove any files other than MINE in a shared environment, will it?

Marc

Gray, I thought it was YOUR temp files that you were trying to cleanup? So, shouldn't this actually help you?

Oh please let me laugh...I learned FOCUS on a VAX in the early 90's. Don't remember commands...

Marc, the delete will clean up the files in the current agent's temp directory. If 500 people are running the same program, each execution of the program will have an individual agent, that agent's files will get cleaned up.

It appears the VAX delete command syntax is something like this:

$DEL MYFILE.TXT;4,

so try !$DEL MYFILE.TXT;4 in WebFOCUS.

To be release agnostic when deleting or moving files in the WebFOCUS environment, there is a series of APP commands documented in the Server Configuration manual for your platform.

You would be interested in the APP DELETEF command.

This is doc copied from the manual for 7.6.
APP DELETEF
The APP DELETEF command deletes a component in an application.
Syntax: How to Delete an Application Component Manually
APP DELETEF appname filename filetype
where:
appname
Is the application from which the component is being deleted.
filename1
Is the component to be deleted.
filetype
Is the component type of the file to be deleted.
For a full list of the types of files you can copy with APP commands, see Designating File
Types for APP Commands on page 5-38.

This is the list of filetypes:

Note: This list reflects file types supported across all IBI products and release levels.
Particular file types may not be supported in particular releases or with every product.
Filetype File Extension
MASTER .mas
FOCSQL .acx
OMI .omi
HLI .hli
FOCEXEC .fex
EDAPROF .prf
MNTPAINT .mpt
EDANLS .nls
ERRORS .err
MAINTAIN .mnt
WINFORMS .wfm
FOCCOMP .fcm
FOCSTYLE .sty
FOCFTMAP .fmp
AFM .afm
HTML .htm
TXT .txt
PS .ps
GIF .gif
TDL .tdl
BMP .bmp
EXCEL .xls
ADR .adr
BST .bst
EPS .eps

The APP commands are great and I wish more folks would use them instead of operating system commands.

You can also find the doc in Dev Studio help.

Would be lovely if you could use the APP DELETEF command to delete more than one file at a time, something like
APP DELETEF demo * ftm
or
APP DELETEF demo m* ftm

but I don't think that's possible. As well, the command only works on an APP folder.

I've got the APP DELETEF commands to delete Focus files, and master files. I've never gotten it to delete an ftm (or pdf or xls or other hold file type).
I'm not quite sure what I'm doing wrong there, so I end up having to use the operating system delete command.
I don't quite understand why hold files (of any type) aren't in the list, since that is the file type I nearly always want to delete.

These worked for me:

APP DELETEF TEMP BOOK1 EXCEL
APP DELETEF TEMP TEMP33 FOCEXEC
APP DELETEF TEMP 'COPY OF OUTLINE' TXT
APP DELETEF TEMP PDF1 PDF

This did not:

APP DELETEF TEMP * EXCEL

It appears that FOCTEMP didn't make it into that list. Try that for .ftm files.

APP DELETEF TEMP HOLD FOCTEMP

Thanks for the all the suggestion, folks. I just had the time to do some testing and put this into a fex in the middle:

00477 VMS DELETE FOC$TMP:*.FTM;*
00478 VMS DELETE FOC$TMP:*.MAS;*

Remember, I'm on VAX. (Once more, STOP LAUGHING!)

It didn't delete anything. Our temp area is set up as FOC$TMP (no E) and I figured that's where the files are because that's where I have to copy them from to save them in my area.

And, yes, I used -RUN before and after just to make sure it would happen where I wanted it to.

*sigh*

Marc

I'm going to guess that VAX does not recognize what FOC$TMP is seeing as that's a WebFocus thing. Try this instead:

-SET &TEMPPATH=TEMPPATH(80,'A80');
-SET &FULLPATH = &TEMPPATH || ':*.FTM;*';

VMS DELETE &FULLPATH

If your path names can be longer than 80 characters, adjust that accordingly.