05-16-2008
Era,
It works fine for only one file. I am passing the many file for that change from CLO* to CLO*_S02 .
Here is the code part
if [ ${source_schema} = 'OPSDM001' ]
then
sed -e 's/\(TSO[^"]*\)/\1_S02/g' $TN.${ecmdate}.sql > $tmpfile_cln
sed -e 's/"//g' $tmpfile_cln > $TN.${ecmdate}.sql
elif [ ${source_schema} = 'DAYA' ]
then
sed -e 's/\(TEST[^"]*\)/\1_S02/g' $TN.${ecmdate}.sql > $tmpfile_cln
sed -e 's/"//g' $tmpfile_cln > $TN.${ecmdate}.sql
elif [ ${source_schema} = 'CLODM001' ]
then
sed -e 's/\(IN CLO[^ ]*\)/\1_S02/g' $TN.${ecmdate}.sql > $tmpfile_cln
sed -e 's/"//g' $tmpfile_cln > $TN.${ecmdate}.sql
elif [ ${source_schema} = 'UHCDM001' ]
then
sed -e 's/\(TSHL[^"]*\)/\1_S02/g' $TN.${ecmdate}.sql > $tmpfile_cln
sed -e 's/"//g' $tmpfile_cln > $TN.${ecmdate}.sql
else
echo " hi "
fi
This script works fine for other schemas but CLODM001 is not working at all. Am I missing something here too ?
Thanks for yoor help !
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 PHP
cubrid_ping
CUBRID_PING(3) 1 CUBRID_PING(3)
cubrid_ping - Ping a server connection or reconnect if there is no connection
SYNOPSIS
bool cubrid_ping ([resource $conn_identifier])
DESCRIPTION
Checks whether or not the connection to the server is working.
PARAMETERS
o $conn_identifier
- The CUBRID connection identifier. If the connection identifier is not specified, the last connection opened by cubrid_connect(3)
is assumed.
RETURN VALUES
Returns TRUE if the connection to the server CUBRID server is working, otherwise FALSE.
EXAMPLES
Example #1
cubrid_ping(3) example
<?php
set_time_limit(0);
$conn = cubrid_connect('localhost', 33000, 'demodb');
/* Assuming this query will take a long time */
$sql = "select * from athlete";
$result = cubrid_query($sql);
if (!$result) {
echo 'Query #1 failed, exiting.';
exit;
}
/* Make sure the connection is still alive, if not, try to reconnect */
if (!cubrid_ping($conn)) {
echo 'Lost connection, exiting after query #1';
exit;
}
cubrid_free_result($result);
/* So the connection is still alive, let's run another query */
$sql2 = "select * from code";
$result2 = cubrid_query($sql2);
?>
PHP Documentation Group CUBRID_PING(3)