06-09-2009
|
|
Registered User
|
|
|
Join Date: Jan 2009
Posts: 42
|
|
|
SED - adding blank line after each Range Match
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
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'
;
|
CURRENT CODE I'M USING:
Code:
sed -n '/[Ss][Ee][Ll][Ee][Cc][Tt][ ]*$/,/;/p' $INPUT_FILE
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 thank you in advance for your time.
-----Post Update-----
I found solution at:
Need help in sed command (adding a blank line btw each block generated by pattern)
Sorry for the trouble... didn't see that post until it came up as "helpfull thread" to my new post :-(
Last edited by danmauer; 06-10-2009 at 01:05 PM..
|
More UNIX and Linux Forum Topics You Might Find Helpful
Powered by 
Threaded Mode
