01-01-2009
Need help in sed command (adding a blank line btw each block generated by pattern)
Hello friends,
I have a C source code containing sql statements. I use the following sed command to print all the sql blocks in the source code....
sed -n "/exec sql/,/;/p" Sample.cpp
The above sed command will print the sql blocks based on the pattern "exec sql" & ";" (since most of them start with "exec" & ends in ";") & the output will look like this (with no ">>>>")
1>>>> exec sql select pqxQrn,
pqxPmeOldQcl
into :qrn, :qxt, :cuk, :cln, :pqxTdd,
:pmeOldQcl indicator :pmeOldQclInd
from pqx
1>>>>where pqxDno = :dno;
2>>>>exec sql select qcfQcl into :oldQcl from qcf
1>>>> where qcfCuk = :cuk;
2>>>> exec sql select cufCid
into :cid
from cuf
1>>>>where cufCuk = :cuk;
2>>>> exec sql select clrChief
into :chief
from clr
1>>>> where clrCln = :cln;
2>>>> exec sql select count(*) into :cnt from pqx
1>>>> where pqxQrn < :qrn;
2>>>> exec sql declare xqxPmeCur cursor for
select pqxQrn
from pqx
where pqxQxt = QXT_PME and
pqxCuk = :cuk and
pqxPmeDno = :dno and
1>>>> pqxTdd = :pqxTdd;
2>>>> exec sql open xqxPmeCur;
I would like to insert a space in between each sql blocks (between "1>>>>" & "2>>>>").....so that it is more readable. Kindly help....& thanks in advance.....
10 More Discussions You Might Find Interesting
1. Solaris
I need to find text "A" and replace it with A B. The issue is that I need a new line between A and B. \n does not do the work. Any help would be much appreciated.
Thanks, (2 Replies)
Discussion started by: ivesia
2 Replies
2. Shell Programming and Scripting
Hi,
In files, I have a field Date Of Birth (DOB). After that line I need to add Date of Joining (DOJ)
DOB:19-Apr-1981
needs to become
DOB:19-Apr-1981
DOJ:20-Jun-2005
What can be a sed/perl line that can do it for me. Please note that DOB/DOJ I have in variables
I am doing in a... (6 Replies)
Discussion started by: eagercyber
6 Replies
3. Shell Programming and Scripting
Hi friends,
I have written script that will search & display the block of sql statement. Since there are many blocks of sql statement i am finding it difficult to distinguish between them. The below is the sed command & its result
exec sql
abc
abc
abc... (2 Replies)
Discussion started by: frozensmilz
2 Replies
4. Shell Programming and Scripting
the following range matching works great but i wish to add a blank line after each range result set... which i've tried and researched to no avail
MY INPUT DATA:
CURRENT CODE I'M USING:
sed -n '/*$/,/;/p' $INPUT_FILE
RESULTS I'M GETTING:
RESULT I looking to... (5 Replies)
Discussion started by: danmauer
5 Replies
5. Shell Programming and Scripting
Hi
Is it possible to do the following in a single command
/usr/xpg4/bin/sed -e '/rows selected/d' /aemu/CALLAUTO/callauto.txt > /aemu/CALLAUTO/callautonew.txt
/usr/xpg4/bin/sed -e '/^$/d' /aemu/CALLAUTO/callautonew.txt > /aemu/CALLAUTO/callauto_new.txt
exit (1 Reply)
Discussion started by: aemunathan
1 Replies
6. Shell Programming and Scripting
FIle A
"A" 2 aa 34
3 ac
5 cd
"B" 3 hu 67
4 fg
5 gy
output shud be
A"" 2 aa 34
"A" 3 ac 34
"A" 5 cd 34
"B" 3 hu 67
"B" 4 fg 67
"B" 5 gy 67 (6 Replies)
Discussion started by: cdfd123
6 Replies
7. Shell Programming and Scripting
I use the following as part of a script to correct for a faulty hostname file.
# get the domain name
read -r thehostname < /etc/hostname
dom="$(echo $thehostname | cut -d'.' -f2)"
numchar=${#dom}
if
then
echo "It appears as though the hostname is not correctly set."
echo "Hostname has... (5 Replies)
Discussion started by: bugeye
5 Replies
8. Shell Programming and Scripting
my file has thousands of line but let me show what i want to achieve... here is one line from that file
cat fileName.txt
(2,'','user3002,user3003','USER_DATA_SINGLE',1,0,0,'BACKUP',2,NULL,0,450,NULL,NULL,'','2011-05-10... (13 Replies)
Discussion started by: vivek d r
13 Replies
9. UNIX for Dummies Questions & Answers
Hi I just wanted to add a new line after every matching pattern:
The method doing this doesn't matter, however, I have been using sed and this is what I tried doing, knowing that I am a bit off:
sed 'Wf a\'/n'/g'
Basically, I want to add a new line after occurrence of Wf. After the line Wf... (5 Replies)
Discussion started by: MIA651
5 Replies
10. Shell Programming and Scripting
here is what i want to achieve.. i have a file with below contents
cat fileName
blah blah blah
.
.DROP this
REJECT that
.
--sport 7800 -j REJECT --reject-with icmp-port-unreachable
--dport 7800 -j REJECT --reject-with icmp-port-unreachable
.
.
.
more blah blah blah
--dport 3306... (14 Replies)
Discussion started by: vivek d r
14 Replies
LEARN ABOUT DEBIAN
oarhold
oarhold(1) OAR commands oarhold(1)
NAME
oarhold - hold a job in OAR batch scheduler.
SYNOPSIS
oarhold [--array][job_ids][--sql "sql syntax"][-r][-h][-V]
DESCRIPTION
Ask OAR to not schedule jobs until oarresume command will be executed.
OPTIONS
-r, --running
Manage not only Waiting jobs but also Running one (can suspend the job)
--array
Hold array job(s) passed as parameter (all the sub-jobs of the given array job(s))
--sql
Hold jobs which repond to the SQL where clause on the table jobs (ex: "project = 'p1'")
-V, --version
Print OAR version number.
-h, --help
Print help command message.
oarsub(1), oardel(1) oarstat(1), oarnodes(1), oarresume(1)
COPYRIGHTS
Copyright 2008 Laboratoire d'Informatique de Grenoble (http://www.liglab.fr). This software is licensed under the GNU Library General Public License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarhold 2012-05-23 oarhold(1)