Home » Infrastructure » Unix » Batch file....
Batch file.... [message #185544] Wed, 02 August 2006 04:34 Go to next message
sunidhi
Messages: 36
Registered: January 2006
Location: New Delhi
Member
Hi all,

Hope doing well.

I m using ORacle 7.3 on HP-UX (10.3) Platform.

I want to run batch file from Windows to get specific file from specific directory.

How can I do that ?

Please Help me !

regards

Sunidhi
Re: Batch file.... [message #185545 is a reply to message #185544] Wed, 02 August 2006 05:07 Go to previous messageGo to next message
vivekpatil
Messages: 3
Registered: April 2006
Location: mumbai
Junior Member

Hi,
1> Create one batch file with following text:

sqlplusw scott/tiger@server @c:\abc.txt


2> In C:\ create file abc.txt with following text :

set serveroutput on
spool c:\abcoutput.txt
select * from emp;
/
spool off
exit

save it.

3> Now run the batch file & check the output file c:\abcoutput.txt


Regards,

Vivek.
Re: Batch file.... [message #185566 is a reply to message #185545] Wed, 02 August 2006 06:31 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Windows to get specific file from specific directory.
If this is to do something with OS level file transfer,
look into ftp/sftp/scp concepts.
Previous Topic: FTP a file through UNIX script.--URGENT
Next Topic: Craete Mainframe GDG with RECL = 1460 thru UNIX
Goto Forum:
  


Current Time: Thu Mar 28 08:39:55 CDT 2024