Hi,

I am completley new to Unix and shell scripts. I need to write a script that does the following:

selects 2 values from a table on an oracle database (directory structure)
ftps a .csv file from a Win server to a Unix server (directories from above sql)
changes directory
uses a utility called mload to upload data

I know how to write the select statement but do I write it in my script or do I write a separate sql script that I call from my shell script? if so, how do I pass the values I retrieve from the database back to the calling shell script.

I am also unclear on how to use ftp in my script to ftp the csv file.

The rest I know how to do.

If someone could give me some hints, point me in the right direction, or point me to some samples, I would greatly appreciate it.

thanks,
KKC