Try something like this:

Put these lines in a file named: filename.bat
del sql2.cmd
del sql1.txt
dir/b *.sql >> sql1.txt
for /f %%I in (sql1.txt) do echo @%%I >> sql2.cmd

Put this line in a file named: sql1.text
test1.sql



Now figure out where to put this in your .bat file for ftp



-----Original Message-----
From: Edwards, Ed
Sent: Thursday, August 05, 2004 6:01 AM
To: 'rajeev'; LazyDBA Discussion
Subject: RE: need script --Urgent
Importance: High



Windows

Put this line in a file and name it: ftp_files.bat
ftp -s:ftp_files.txt 10.10.3.28

Put these lines in a file and name it: ftp_files.txt
scott
tiger
prompt
binary
cd /
cd /oracle_backup
mget *.*
quit
exit

To run it type (at the command prompt): ftp_files
or
click on ftp_files.bat icon using Windows Explorer




-----Original Message-----
From: rajeev
[mailto:oracledba-ezmlmshield-x50651682.[Email address protected]
Sent: Thursday, August 05, 2004 5:44 AM
To: LazyDBA Discussion
Subject: need script --Urgent


hi gurus,
Could some one have a idea for windows,
I am new in scripting, i want to scan a folder for files,
one by one pick the files and ftp the specified location
at other server.
I want to make this for windows environment, i mean want to
make a batch file for that.
Please give yr suggestion.
Thaks & regards


----------------------------------------------------------
http://www.bhartitelesoft.com
Telecommunication and E-Commerce solutions for the future.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page