: !/bin/sh # create t21g3e unload file if [ "$1" = "" ]; then t21g3efile="t21g3e.csv" else t21g3efile="$1" fi tmpt21g3efile="/tmp/t21g3etmp$$.unl" tmp1t21g3efile="/tmp/t21g3etmp1$$.unl" rm -f "$t21g3efile" "$tmpt21g3efile" "$tmp1t21g3efile" ############################### gett21g3e() { grid=$1 rm -f "$tmp1t21g3efile" runisql <> "$tmpt21g3efile" cat "$tmp1t21g3efile" rm -f "$tmp1t21g3efile" } ############################## ( gett21g3e "" >> $tmpt21g3efile tr "," ";" <$tmpt21g3efile | tr "|" "," | sed -e 's/,$//' | sort -u >"$t21g3efile" ) 2>&1 | tee $0.log rm -f "$tmpt21g3efile" "$tmp1t21g3efile" emailaddr="bilmax21" ematt "$t21g3efile" "CC Extns CSV" "$emailaddr" exit 0