Shell Programming and Scripting

 awk '{ print $0; 
 if ( $0 ~ /LOADTMP1/ ) 
 { 
 print $4;
 Table_name=system($( db2 -x "SELECT TRIM(TD.BSCHEMA) || '.' || TRIM(TD.BNAME) AS TABLE_NAME FROM SYSCAT.TABDEP TD WHERE 
TD.BTYPE='T' AND TD.TABSCHEMA='XXXXXXX' AND  TD.TABNAME='$view' order by BSCHEMA desc fetch first 1 row only ));
 print $Table_name;
 }
 }' test

awk -v SQ="'" '
1
/LOADTMP1/      {print $4;
                 Table_name=system("db2 -x \"SELECT TRIM(TD.BSCHEMA) || " SQ "." SQ " || TRIM(TD.BNAME) AS TABLE_NAME FROM SYSCAT.TABDEP TD WHERE TD.BTYPE=" SQ "T" SQ " AND TD.TABSCHEMA=" SQ "XXXXXXX" SQ " AND TD.TABNAME=" SQ "$view" SQ " order by BSCHEMA desc fetch first 1 row only\"")
                 print Table_name;
                }
'  test