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:
Quote:
typeset lfile_selection_count=${1}
typeset lcyclename_suffix=_cycle${lfile_selection_count} cat > ${Vsqlfile} <<BATCH_EOF -- THESE OPTION SETTINGS MAKE SURE THAT THE SQL IS PROCESSED -- CORRECTLY WITHIN THE CONTEXT OF THIS SCRIPT. SPECIFICALLY, -- THE SCRIPT WILL STOP AND ISSUE AN ERRROR MESSAGE ON THE FIRST -- SQL STATEMENT THAT RETURNS A NON-ZERO CONDITION CODE (-S ON). -- THE SCRIPT WILL NOT COMMIT ANY CHANGES UNTIL THE COMMIT -- STATEMENT IS EXECUTED AT THE END OF THE SCRIPT (I.E. -C AUTOCOMMIT -- IS OFF). tHE PROMPT IS TURNED OFF SO THAT IT IS NOT SHOWN -- IN THE OUTPUT. CONNECT TO ${Gdb2instance_ar} user ${Gdb2user} using XXXXXXXX; UPDATE COMMAND OPTIONS USING p OFF; UPDATE COMMAND OPTIONS USING s ON; LIST COMMAND OPTIONS; alter table ${Gmdsschema}.PLN_RV_SM activate not logged initially; INSERT into ${Gmdsschema}.PLN_RV_SM SELECT a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GE/GG') AND a11.TRNCTN_TYP_CD = 'TI' ; alter table ${Gmdsschema}.PLN_RV_SM activate not logged initially; INSERT into ${Gmdsschema}.PLN_RV_SM selecta11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GI') AND a11.TRNCTN_TYP_CD = 'TI' ;
CURRENT CODE I'M USING:
RESULTS I'M GETTING:
Quote:
SELECT a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GE/GG') AND a11.TRNCTN_TYP_CD = 'TI' ; select a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GI') AND a11.TRNCTN_TYP_CD = 'TI' ;
RESULT I looking to get: (see blank line after semicolumn)
Quote:
SELECT a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GE/GG') AND a11.TRNCTN_TYP_CD = 'TI' ;
select a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GI') AND a11.TRNCTN_TYP_CD = 'TI' ;
I followed the egrep example given in the thread "parse text or complex grep ?". It is exactly what I need...except... how do I insert a blank line after the second line? My exact command is:
egrep 'patt1|patt2' filename
the result is:
patt1
patt2
patt1
patt2
and so on. I would... (2 Replies)
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" & ";"... (2 Replies)
Hi,
I need to match lines after a pattern, upto the first blank line.
Searched in web and some forums but coulnt find the answer.
where <restart_step> =
10 -- Execute query
20 -- Write the contents to the Oracle table
30 -- Writing Contents to OUTPUT... (7 Replies)
Hello...
I have a file which contain certain number of records.
I want to generate another file from this file which will contain 1st line as a blank line & after every 5 lines one blank line will be inserted. How to achieve this through shell scripting?
Thanks... (5 Replies)
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)
Hi
Im trying to do the following in sed. I want to delete any blank line at the start of a file until it matches a pattern and then stops. for example:
Input
output:
I have got it to work within a range of two patterns with the following:
sed '/1/,/pattern/{/^]*$/d}'
The... (2 Replies)
Hi Guys,
I am stuck in between and seeking help here.
Requirement: A script that will run every morning which will connect to Mysql database and run the query to inform us about the holidays (it will also check if there were any holidays during last 2 business days). So the three queries are... (11 Replies)
Input: START
OS:: UNIX
Release: xxx
Version: xxx
END
START
OS:: LINUX
Release: xxx
Version: xxx
END
START
OS:: Windows
Release: xxx
Version: xxx
ENDHere i am trying to get all the information between START and END, only if i could match OS Type.
I can get all the data between the... (3 Replies)