How to combine to flat files which are there in remote server ?

srinivasaraju.m · #1 (**permalink**) 08-01-2006

I have to write a script in informatica, which is used to combine two remote flat files

inquirer · #2 (**permalink**) 08-04-2006

file transfer the file using ftp then perform cat command to combine files

Code:

ftp -ivn << eof
open <ip address>
user <username> <password>
binary
get file1
bye
eof

cat file1 file2 > outfile

srinivasaraju.m · #3 (**permalink**) 08-04-2006

Hi

Thanks.

Mean while i tried with the following script. Please let me know ur comments on this.

Code:

FTPSVR=IP address
FTPUSR=username
FTPPWD=password
FTPDIR=/dir path
export FTPSRV FTPUSR FTPPWD FTPDIR

ftp -n $FTPSVR << !
quote user $FTPUSR
quote pass $FTPPWD
cd $FTPDIR
lcd /dir name

get filename1
get filename2

bye


The second script as,

FTPSVR=IP address
FTPUSR=username
FTPPWD=password
FTPDIR=/dir path
export FTPSRV FTPUSR FTPPWD FTPDIR


cd /tmp

cat filename1  filename2 > filename3

ftp -n $FTPSVR << !
quote user $FTPUSR
quote pass $FTPPWD
cd $FTPDIR
lcd /dir name
put filename3
bye

Dhruva · #4 (**permalink**) 08-04-2006

As in your first post you said you need to combine two flat files residing at remote host.that can be done with this script

Code:

#this script login to remote server and execute the command there the log file will be
#session_output
( echo "user"
  sleep 2
  echo "password"
  sleep 2
  echo "cd /dir_path"
  sleep 2
  echo "cat test11.txt test12.txt>>try.txt"
  sleep 2
  echo "logout"
) | telnet ip_address > session_output

Do you need to ftp also??

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
listing files on remote server	vasuarjula	AIX	3	06-02-2008 03:23 PM
rename files in remote server via ftp	dineshr85	Shell Programming and Scripting	4	02-20-2008 12:30 PM
delete files on a remote server	bond_bhai	UNIX for Advanced & Expert Users	1	07-27-2007 07:19 AM
FTP multiple files from remote server to local server	berlin_germany	Shell Programming and Scripting	2	12-20-2006 03:24 AM
copying files to a remote aix server using tar!	system-admin	AIX	2	11-17-2006 03:30 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by