#!/bin/ksh
for SERVER in
NEWSNYD403P
NEWSNYD404P
SNEWSNYD601P
SNEWSNYD602P
SNEWSDNY603P
SNEWSNYD604P
do
/usr/bin/scp "/home/sam/bash.tar root@$SERVER":/tmp
done
Error msg I get:
Code:
./scp_script.sh: syntax error at line 3: `NEWSNYD403P' unexpected
#!/usr/bin/bash
if
then
echo "Not valid arguments entered. Just username should be entered."
else
USER_NAME=$1
FILE_NAME=$USER_NAME.info
UNN=STUDIN\\\\$1
echo $UNN
last STUDIN\\\\$1
last UNN
If I type `last STUDIN\\eip060` it works but if I try to expand it with variable it is... (5 Replies)
All,
I have a list of over 400 users that need certain directories created. These will be created in /users/$username on a system and I need a directory called chess under these directories that I create.
Instead of me manually adding each one (mkdir /users/user1, mkdir /users/user1/chess)... (1 Reply)
a) Total number of words in the file.
b) Total number of different words in the file.
How can I use the translate and/or unique commands to accomplish this (4 Replies)
Greetings all. :)
I would like to use sed to join all non-blank lines together in a particular file. I was thinking I could do this by simply replacing the terminating, new-line character on every line which is not blank, but I must be missing something in my sed line:
$ sed... (3 Replies)
Hello,
I am facing a very strange problem when I run my script manuallu ./Fetchcode which is using to connect with MKS integrity from linux end it workks fine but when I run it from cron it doesn't work.Can someone help me
1) How could I check my script when it is running from cron like... (3 Replies)
Help. My script is working fine when executed manually but the cron seems not to catch up the command when registered.
The script is as follow:
#!/bin/sh
for file in file_1.txt file_2.txt file_3.txt
do
awk '{ print "0" }' $file > tmp.tmp
mv tmp.tmp $file
done
And the cron... (2 Replies)
Hey everyone, just now joined because I didn't want to go onto Ubuntu forums and start asking about how to write shell scripts. Seems like this is a pretty active forum for exactly what I need.
I'm trying to modify a shell script I found online, the end goal is to have it find all files in the... (9 Replies)
Hello,
This is basic (i think). I am trying to run a shell script which would go into each folder (folder names defined in the list) and after entering would run some commands, once done, come out of the folder and continue until the list ends.
Pretty basic and there are bunch of example online. ... (9 Replies)
Discussion started by: Zam_1234
9 Replies
LEARN ABOUT SUSE
create_server
CREATE SERVER(7) SQL Commands CREATE SERVER(7)NAME
CREATE SERVER - define a new foreign server
SYNOPSIS
CREATE SERVER servername [ TYPE 'servertype' ] [ VERSION 'serverversion' ]
FOREIGN DATA WRAPPER fdwname
[ OPTIONS ( option 'value' [, ... ] ) ]
DESCRIPTION
CREATE SERVER defines a new foreign server. The user who defines the server becomes its owner.
A foreign server typically encapsulates connection information that a foreign-data wrapper uses to access an external data resource. Addi-
tional user-specific connection information may be specified by means of user mappings.
The server name must be unique within the database.
Creating a server requires USAGE privilege on the foreign-data wrapper being used.
PARAMETERS
servername
The name of the foreign server to be created.
servertype
Optional server type.
serverversion
Optional server version.
fdwname
The name of the foreign-data wrapper that manages the server.
OPTIONS ( option 'value' [, ... ] )
This clause specifies the options for the server. The options typically define the connection details of the server, but the actual
names and values are dependent on the server's foreign-data wrapper.
NOTES
When using the dblink module (see in the documentation), the foreign server name can be used as an argument of the dblink_connect(l) func-
tion to indicate the connection parameters. See also there for more examples. It is necessary to have the USAGE privilege on the foreign
server to be able to use it in this way.
EXAMPLES
Create a server foo that uses the built-in foreign-data wrapper default:
CREATE SERVER foo FOREIGN DATA WRAPPER "default";
Create a server myserver that uses the foreign-data wrapper pgsql:
CREATE SERVER myserver FOREIGN DATA WRAPPER pgsql OPTIONS (host 'foo', dbname 'foodb', port '5432');
COMPATIBILITY
CREATE SERVER conforms to ISO/IEC 9075-9 (SQL/MED).
SEE ALSO
ALTER SERVER [alter_server(7)], DROP SERVER [drop_server(7)], CREATE FOREIGN DATA WRAPPER [create_foreign_data_wrapper(7)], CREATE USER
MAPPING [create_user_mapping(7)]
SQL - Language Statements 2010-05-14 CREATE SERVER(7)