Single quotes insert statement using awk

Shell Programming and Scripting
1

Hi,

Need help, using awk command to insert statement

awk -v q="'" '{ print "db2 connect to repolab > /dev/null; " "\n" "db2 -x \" select name from IBMPDQ.PROFILE where managed_database = " q $1"_"$3"__0" q "\"" } '  profile.txt | sh - | awk -v i="'" ' { print "db2 connect to repolab > /dev/null; " "\n" "db2 \" insert into IBMPDQ.PROFILE_PROPS (PROFILE_NAME, PROPERTY_KEY, PROPERTY_SCOPE, PROPERTY_RUNTIME, PROPERTY_VALUE) VALUES ( " i$1i ",'otsEventTablespace', 'DEFAULT',  'dsweb', 'DSMSPACE') \" "  } '

Output :

 db2 connect to repolab > /dev/null;
db2 " insert into IBMPDQ.PROFILE_PROPS (PROFILE_NAME, PROPERTY_KEY, PROPERTY_SCOPE, PROPERTY_RUNTIME, PROPERTY_VALUE) VALUES ( 'SAMPLE_lxrsvudbl018__0_dsweb_38320407786886277',otsEventTablespace, DEFAULT,  dsweb, DSMSPACE) "

Need output with single quotes in the insert statement

VALUES ( 'SAMPLE_lxrsvudbl018__0_dsweb_38320407786886277','otsEventTablespace', 'DEFAULT',  'dsweb', 'DSMSPACE') "
2

Your first awk call already includes an example of how to use single quotes in an awk statement...