01-24-2008
3,
0
Join Date: Jan 2008
Last Activity: 29 July 2011, 3:30 PM EDT
Posts: 3
Thanks Given: 0
Thanked 0 Times in 0 Posts
help with script
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