Dear All,

I am actually an Oracle DBA, trying my hand on some of the shell scripting, to ensure that some of the manual tasks my developers do, are removed from their hectic responsibilities.

They generate a file (a flat file of encoding type ANSI) through Oracle (which is based on a HP Unix box) on a NAS Server running on windows, so I pick it from there, load it onto Linux convert the char-set to UTF8 and push it back to the NAS, so that they can have it as UTF8 as desired.

If not this, the developers have to open each file in Windows manually and "save-as" UTF8 encoding, and the files are huge and in huge number

Everything in my shell code works in bits (individually), except for the main connection, how do I connect from my Linux to HP Unix using ftp and mput, mget and delete files.

for instance,

My red hat linux box is having this code

ftp -vnd "11.11.11.11" <<++ 1>>readme.log 2>&1
user "username" "password"
prompt off
binary
prompt
lcd /backup/data
mget *
find /backup/data/ -name '*'\.\txt -type f -print|while read FILENAME
do
ls -altr "${FILENAME}" >> /backup/data/files.log
iconv -f windows-1256 -t UTF-8 "${FILENAME}" > "${FILENAME%.txt}_utf8.txt"
done
bye

But my connection is hanging for endless feeds from user, leave everything else coming after it.

Kindly advise.

Roshan Nair

Hi -

1. I'm confused about several things in the snippet you gave. For example, if you use a "here document" (like "ftp << EOF"), then I would expect to see a corresponding "EOF" at the end of the file. Here's what I mean about "here documents" (pun intended ;-)):
http://tldp.org/LDP/abs/html/here-docs.html

2. Here are two simple examples of working FTP scripts:
http://www.computing.net/answers/uni...hpux/7009.html

Each different ftp client supports different options, and has different limitations. For example, "ftp" on Solaris might behave quite differently from "ftp" on HP-UX.

3. Finally, perhaps you might not need to script anything at all. Have you considered NFS-mounting the NAS on HP-UX (or using Samba to mount a Windows share on HP-UX)? Just a thought...

'Hope that helps .. PSM

Hi Paul,

Sorry for the ambiguity. My purpose is to create a shell script on a RHAS box, which will run regularly and connect to a HP Unix Source through FTP and get files from there. I saw the links, but maybe because of me a "newnewbie" to the Linux world, it did not work for me. Should I be creating a file "conn.sh", which would pull commands from ftp_commands.lst. A similar thing in windows worked for me, but not here I guess.

***************************************************
[oracle@shamilrep scripts]$ cat conn.sh
ftp -i < /oracle/scripts/ftp_commands.lst
[oracle@shamilrep scripts]$ cat ftp_commands.lst
11.11.11.11 <<!
user username password
cd /data/checkup
binary
prompt
lcd /backup/Oracle-Backup/EIM_data_extract
mget *
bye

***************************************************

-Rgds,
Roshan