DOS script for Unix database

[Ultdrake]

I want tranfer a .sql file create by a perl on DOS script to unix and execute him on oracle database.

The transfer, the creation of .sql file and the execution on the database must be do by the same perl on DOS script.

I know it's a multi part question, but the most important part is execute .sql file on unix by perl on DOS script

thanks a lot,
Fred

 

[sampsonr]

This is a pretty large task. The steps I see are:

1. Create the sql file on DOS. I assume you already have a way to do this.

2. Get the sql file to the Unix machine. Is this necessary, can't you just execute the query on the DOS machine using SQLPlus? If not, the choices I see are to FTP the file over using a command file for the FTP program, or to have a disk partition shared between the DOS and Unix machines if that's possible.

3. Execute the query on the Unix machine. You'll need some kind of daemon process on the Unix machine that runs continually. Whenever it detects that a new query file has been created, it executes the query.

 

[Ultdrake]

it's clear and simple... thanks...