$ cat file
one,ABCD\XYZ,Server One
$ cat run
#!/usr/bin/ksh
ENVDB="ABCD\XYZ"
VAR=$(echo $ENVDB | sed 's/\(\\\)/\1\1/')
sed "s/$VAR/SERVER/" file
$./run
one,SERVER,Server One
$
when declaring a variable e.g.
export DAYS
what checking / how can i check that the value assigned only contains numeric characters or integers ? (1 Reply)
Hi All,
I have got a problem. I have written a Shell script which cuts some information from the file a and puts it in file b. But i get this error when i execute the shell script.
This is what i have written in the script.
#! /usr/bin
cd /test
ls $2 > a
cut -f 1 -d '.' a > b
When i... (2 Replies)
i am trying to append a 5 line SGML file(file1) with a 500,000 line SGML file (file2).
file1 is a template, so i wish to preserve.
i only want to add lines 5 to the end of file2.
i have:
cp file1 temp1
sed -n '5,$p' file2 >> temp1
when i check the tail of temp1, i consistantly find the... (3 Replies)
Hi, i need help passing variables to sed using ksh.
My goal is to get particular data from log files.
first i put a mark to the log files.
echo "TEST_"`date + %m_%d_%Y_%T"` >markFile
this will produce a 'markFile' which contain text like this
TEST_06_01_2009_21:55:09
then i put the mark... (2 Replies)
Hi Gurus,
I am working with a korn shell script. I should replace in a very great file the character ";" with a space.
Example:
2750;~
2734;~
2778;~
2751;~
2751;~
2752;~
what the fastest method is? Sed? Awk?
Speed is dead main point, Seen the dimensions of the files
Thanks (6 Replies)
I am using SED to edit a file (called file)
the file contains the word "ERROR"
and I want to use SED to:
1. Search for text "ERROR"
If found,
2. Append new line with text "hoi"
I tried:
sed 's/ERROR/ a\hoi' file
sed 's/ERROR/ a\ hoi' file
I get all the time the error
sed:... (7 Replies)
I'm trying to do an ls from inside of a ksh script. I loop through the results one line at a time and attempt to do a substitution using sed to convert YYYYMMDD from the older files into the newer files. Basically sometimes the ETL load runs over midnight and half the files are off by one day... (3 Replies)
Hi all,
What am I doing wrong here?
$ cat test_sed.ksh
#!/usr/bin/ksh
var="sed -e \'6s/9/6/\' testfile.txt > testfile.txt.2"
$var
$ ./test_sed.ksh
sed: command garbled: \'6s/9/6/\'
Thank you! (4 Replies)
Discussion started by: ejianu
4 Replies
LEARN ABOUT SUSE
alter_server
ALTER SERVER(7) SQL Commands ALTER SERVER(7)NAME
ALTER SERVER - change the definition of a foreign server
SYNOPSIS
ALTER SERVER servername [ VERSION 'newversion' ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]
ALTER SERVER servername OWNER TO new_owner
DESCRIPTION
ALTER SERVER changes the definition of a foreign server. The first form changes the server version string or the generic options of the
server (at least one clause is required). The second form changes the owner of the server.
To alter the server you must be the owner of the server. Additionally to alter the owner, you must own the server and also be a direct or
indirect member of the new owning role, and you must have USAGE privilege on the server's foreign-data wrapper. (Note that superusers sat-
isfy all these criteria automatically.)
PARAMETERS
servername
The name of an existing server.
serverversion
New server version.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the server. ADD, SET, and DROP specify the action to be performed. ADD is assumed if no operation is explicitly
specified. Option names must be unique; names and values are also validated using the server's foreign-data wrapper library.
EXAMPLES
Alter server foo, add connection options:
ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');
Alter server foo, change version, change host option:
ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');
COMPATIBILITY
ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED).
SEE ALSO
CREATE SERVER [create_server(7)], DROP SERVER [drop_server(7)]
SQL - Language Statements 2010-05-14 ALTER SERVER(7)