Shell Programming and Scripting

hi all

i have a view in the database with columns

prod_no,prod_nm, prod_code

using a shell script i should query this view and dump the data in a delimited flat file and send to another ftp server....


i also have to schedule this periodically using cron tab.

can you please help me with the code.

Thanks and Regards
Rajesh

If you always wnat to send the same files then you can set up a ~/.netrc file in the appropriate users home directory to send the files as per the web page linked to above. e.g.:

Code:

machine ftp.server.com login username password password
macdef init
binary
prompt
msend prod_*
quit

Replacing ftp.server.com with the name of your ftp server, username and password with the username and password of the ftp account on your ftp server.

Then create a crobtab as the user who is going to send the prod_* files from your end that simply runs "ftp ftp.server.com" again replacing ftp.server.com witht he name of your ftp server.

hi tony thanks for your response....

but am not having a ready made file with me.. i have a view in oracle database..

i have to query that view create a file containing the data that came out of the view..

then send the file to some ftpserver.

hope iam clear

regards
rajesh