SERVER="Server_NAME"
USER="i am user"
PASSWD="mypassword"
ftp -in $SERVER<<EOF
user $USER $PASSWD
mkdir Chanakya #To create directory with my name in $HOME
ls > list
put list
bye
<<EOF
-Chanakya
i noticed some errors in your script.
Code:
USER="i am user"
this is incorrect. the username should be one word and no spaces allowed. if your real user has space the first word will be used as username and th next word after the space will be used as password. that can be a reason for the "Please login with USER and PASS" error. the script was not able to log in so therefore can not create your cirectory. it is also good to check the permission of the folder so you can verify if you have rights to create a directory.
Code:
mkdir Chanakya #To create directory with my name in $HOME
hash can be used in shell script except in this case. since you are inside the ftp prompt. remove it.
Hello. Can someone please help, or give me any advice. The company I work for has a unix machine and works over the com port rather than IP. We need to retrieve some files from it onto another unix machine and we are trying to get an ftp program to work, does anyone know any ftp programs that... (1 Reply)
Hi all,
I am trying to write a script to connect to remote host and ftp some files there.
The problem i am facing is,I dont know how to specify username and password for remote host through scripting.
and even if i am able to connect to remote host,then how should i execute
commands like mput... (17 Replies)
Hello. I'm new to Unix. I've got a SUN Ultra 10 running Solaris 5.7 and I'm trying to FTP to it from my XP PC. My PC has an IP address of 10.0.0.3 and a Subnet of 255.255.255.0. I'm connected to the Sun machine with a crossover cable. I type "ifconfig hme0 10.0.0.5" in a shell window (as... (3 Replies)
Hi,
I want to connect to a remote machine using FTP, check for the size of a file there. If it is 0 bytes, then there is no need to ftp else i have to ftp the file. Any help will be highly appreciated. (7 Replies)
Hi All,
I'm trying to write script to ftp some files and then need to remove these files from server.
Is there any way to keep the condition that the file should be removed only after successfully transfered to the destinatino server?
If in case, the file isn't been transferd, it should not be... (5 Replies)
Hi,
Request Unix gurus to kindly share a script which FTPs multiple files from Unix to a Mainframe GDG.
The script should check for oldest file named as 'abc*.txt' in a directory '/dir/child'. FTP that file to MF, then remove the file from unix and then look for the next oldest file to be... (1 Reply)
Hi All,
I have been trying to FTP some data files from Windows directory to a UNIX server. The txt file in the windows contails the following data:
"111~XYZ~1~Contact person’s phone number~COMMENTS~~~~"
but the same line is appearing as
"111~XYZ~1~Contact person^Òs phone number~COMMENTS~~~~"... (8 Replies)
i want to sftp a .zip file.when i am doing get abc.zip thenabc.zip is getting copied to my home folder.
but on clicking abc.zip on my home folder to open it i am getting error message as
"Unable to unarchive abc.zip into <homefolder> name"
How to sftp the Zip file
Thanks (1 Reply)
I am getting error while ftping the files to the particular destination.
Source code
$ftp->login() or die "not log on to destination server $server ";
$ftp->cwd("$destdir") or die "\ not able to change directory to $destdir on $server ****\n";
Output:
... (1 Reply)
Discussion started by: ramkumar15
1 Replies
LEARN ABOUT SUSE
alter_user_mapping
ALTER USER MAPPING(7) SQL Commands ALTER USER MAPPING(7)NAME
ALTER USER MAPPING - change the definition of a user mapping
SYNOPSIS
ALTER USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC }
SERVER servername
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
DESCRIPTION
ALTER USER MAPPING changes the definition of a user mapping.
The owner of a foreign server can alter user mappings for that server for any user. Also, a user can alter a user mapping for his own user
name if USAGE privilege on the server has been granted to the user.
PARAMETERS
username
User name of the mapping. CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all present and future
user names in the system.
servername
Server name of the user mapping.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the user mapping. The new options override any previously specified options. ADD, SET, and DROP specify the
action to be performed. ADD is assumed if no operation is explicitly specified. Option names must be unique; options are also vali-
dated by the server's foreign-data wrapper.
EXAMPLES
Change the password for user mapping bob, server foo:
ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public');
COMPATIBILITY
ALTER USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). There is a subtle syntax issue: The standard omits the FOR key word. Since both
CREATE USER MAPPING and DROP USER MAPPING use FOR in analogous positions, and IBM DB2 (being the other major SQL/MED implementation) also
requires it for ALTER USER MAPPING, PostgreSQL diverges from the standard here in the interest of consistency and interoperability.
SEE ALSO
CREATE USER MAPPING [create_user_mapping(7)], DROP USER MAPPING [drop_user_mapping(7)]
SQL - Language Statements 2010-05-14 ALTER USER MAPPING(7)