Hi I am trying to substitute 2 words on the same line with _S02 as suffix. Like this .

IN "TSOPS09" INDEX IN "TSOPIX09" ;

to

IN "TSOPS09_S02" INDEX IN "TSOPIX09_S02" ;

i used the following code to make the change , it works fine for first substitution not the second one .

TBLSP_NM=` cat db2look_FACT_PHYSICIAN.ddl | grep -i TSOP | awk '{print $2}' | cut -d '"' -f 2 `
echo $TBLSP_NM
sed -e 's/'${TBLSP_NM}'/'${TBLSP_NM}'_S02/g' db2look_FACT_PHYSICIAN.ddl

the output comes as

IN "TSOPS09_S02" INDEX IN "TSOPIX09" ;


Any help is appreciated !

vgersh preceded me, anyway another one:

Thanks a lot ! You guys rock !!!

Hi,
I ahve next question . I have script which gets info from db2 engine.
The script is

cat sample_substitute.sh
CNTR_NM=`db2 -x "select CONTAINER_NAME ,usable_pages from table( SNAPSHOT_CONTAINER('TST103',-1)) as SNAPSHOT_CONTAINER, syscat.tablespaces where
tablespace_name = tbspace and tbspacetype = 'D' and tbspace='TSOPS06'" `
echo ${CNTR_NM}

The output is like this

/dmpath/dmtiadm1/db2fs1p00/tsops06 2128

But I am trying to get the output like this

'/dmpath/dmtiadm1/db2fs1p00/tsops06' 2128

i.e. the string inside the single quote.

Thanks again in advance !

You may use a thing like:

or


On Solaris, use nawk instead of awk.

i started a new thread for next problem