DOS Batch Problem

[burtguidry]

I use DOS batch commands to FTP information from the IBM ISeries mainframe to a PC and then open that information using Excel. This works fine until a user has loaded about 4 big files. Then it does not download the information. That user has to restart their computer before they do more files. I have tried a memory manager with no luck. It sounds almost like a buffer problem. Is there a DOS command to clear the buffer or is there another option someone can recommend I try? Thanks for any help.

[cat-bomb]

Could you post the batch?

[billrich]

I have not used excel. But excel has an import manager. 

Don't download 3 or 4 jobs to RAM and then try to have excel work correctly.

Download the files to the HDD and have excel import one job at a time.

How much free space on the HDD?  How much free RAM?

If you are low on HDD space save to a CD from the  IBM  mainframe

Good Luck

[burtguidry]

cat-bomb here is my batches:
@ECHO off
CD C:\2pc
if(%1)==(t) ftp  -i -s:ftptext.bat
if(%1)==(d) ftp -i  -w:9000 -s:rcvcsvfl.bat
if(%1)==(d) start excel.exe c:\2pc\AS400FLE.csv
if(%1)==(ut) ftp  -i -w:9000 -s:ftputext.bat
if(%1)==(uf) ftp  -i -w:9000 -s:upload.bat
exit

Open 192.168.0.1
QUSER
Z9876
cd qsys.lib/dist400d.lib/
get  FTPBINFO.file  c:\2pc\rcvcsvfl.bat
quit

OPEN 192.168.0.1
QUSER
Z9876
GET /FTPFILES/SA153448 c:\2pc\AS400FLE.csv (replace
QUIT

The first batch is my control batch, the second batch updates the next batch with what I want to download and the third batch does the actual download. This allows the user to download the information from the I Series and have it open in Excel. We do it this way so that we know who is downloading information and by opening in Excel the user does not have to go look for the file on there computer. If you can see something wrong or can think of a easier solution  it would be greatly appreciated.