05-16-2008
sed usage
Hi ,
I have a question. How do I replace 2 words in one line like this
IN CLO07 INDEX IN CLOIX07
to
IN CLO07_S02 INDEX IN CLOIX07_S02
But one thing to remember is that there are lots of words like CLODM001 .
So the only matching pattern is "IN CLO"
sample file is :
CREATE TABLE CLODM001.DIM_HOSPITAL (
HOSP_SYS_ID INTEGER NOT NULL ,
CONTR_MKT_NM VARCHAR(30) NOT NULL ,
CONTR_SUB_MKT_NM VARCHAR(30) NOT NULL
LOAD_DT DATE NOT NULL WITH DEFAULT CURRENT DATE ,
UPDT_DT DATE NOT NULL WITH DEFAULT CURRENT DATE )
COMPRESS YES
IN CLO07 INDEX IN CLOIX07 ;
I used this one but its not right right one .
sed -e 's/\(IN CLO[^"]*\)/\1_S02/g' db2look_DIM_HOSPITAL.ddl1 > db2look_DIM_HOSPITAL.ddl2
Thanks in advance ,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Sorry about the title. I'm assuming I want sed anyway...
Here's the deal:
I have hundreds of files in a folder and they all are named with the same format.
$NAME-$VERSION-$ARCH-$BUILD
This is Slackwares' /var/log/packages directory BTW...
$BUILD is what I'm focusing on. It could be... (6 Replies)
Discussion started by: madpenguin
6 Replies
2. HP-UX
how can I find cpu usage memory usage swap usage and
I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times
my final destination is monitor process
logical volume usage above X % and number of Logical voluage above
can I not to... (3 Replies)
Discussion started by: alert0919
3 Replies
3. Shell Programming and Scripting
I'd like to extract the temps from the following command via a series of sed statements but the actual syntax is beyond me.
$ nc localhost 7634 ... (2 Replies)
Discussion started by: audiophile
2 Replies
4. AIX
How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies
5. Shell Programming and Scripting
How can i use sed to change "Linux Cpu (EDF).sh" to "LinuxCpuEDF.sh"?
I want to replace the spaces and brackets. (4 Replies)
Discussion started by: proactiveaditya
4 Replies
6. Shell Programming and Scripting
Hi,
I want to read a command value and replace the command value in another file.
Anybody know how to write it???
For example:
File A:
Command1 = test
File B:
Command1 =
Command2 =
Command3 =
I want to write a shell script to read content from File A and replace Command1... (3 Replies)
Discussion started by: linboco
3 Replies
7. Shell Programming and Scripting
Hi,
I want to replace some character whenever there is a space using sed.
Input file name: aaa
command i am trying is
sed 's/^$/A/g' aaa (2 Replies)
Discussion started by: rakeshbharadwaj
2 Replies
8. Shell Programming and Scripting
Friends,
I came across a wierd scenario while using sed. When I use the below cmd sequence at OS prompt it works fine:
sed 's/# TMOUT=120/TMOUT=900/g' /etc/profile > /etc/profile.011211
However when I use the same in a script it throws the following error:
==Error==
sed: 0602-404... (4 Replies)
Discussion started by: thisissouvik
4 Replies
9. Shell Programming and Scripting
Gurus,
I am trying to display a match (single character) from beginning of the line in a file using a variable.
I tried using sed ... not sure where am doing it wrong...
sed -n "/^\$variable/p" FileName.shor
sed -n "/^\${variable}/p" FileName.shBoth of the above are not working.....Thanks... (4 Replies)
Discussion started by: Kevin Tivoli
4 Replies
10. Shell Programming and Scripting
Hi,
Can anyone let me know the sed command usage
requirement:
sed 's/standard/standard_and/' <new.txt>new.txt
here it needs to search for the pattern "standard" in the file new.txt and it should replace as "standard_and" in the same file new.txt
Note: new.txt is having a separator... (8 Replies)
Discussion started by: srikanth_sagi
8 Replies
LEARN ABOUT CENTOS
drop_index
DROP
INDEX(7) PostgreSQL 9.2.7 Documentation DROP INDEX(7)
NAME
DROP_INDEX - remove an index
SYNOPSIS
DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.
PARAMETERS
CONCURRENTLY
Drop the index without locking out concurrent selects, inserts, updates, and deletes on the index's table. A normal DROP INDEX acquires
exclusive lock on the table, blocking other accesses until the index drop can be completed. With this option, the command instead waits
until conflicting transactions have completed.
There are several caveats to be aware of when using this option. Only one index name can be specified, and the CASCADE option is not
supported. (Thus, an index that supports a UNIQUE or PRIMARY KEY constraint cannot be dropped this way.) Also, regular DROP INDEX
commands can be performed within a transaction block, but DROP INDEX CONCURRENTLY cannot.
IF EXISTS
Do not throw an error if the index does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of an index to remove.
CASCADE
Automatically drop objects that depend on the index.
RESTRICT
Refuse to drop the index if any objects depend on it. This is the default.
EXAMPLES
This command will remove the index title_idx:
DROP INDEX title_idx;
COMPATIBILITY
DROP INDEX is a PostgreSQL language extension. There are no provisions for indexes in the SQL standard.
SEE ALSO
CREATE INDEX (CREATE_INDEX(7))
PostgreSQL 9.2.7 2014-02-17 DROP INDEX(7)