Bash useful commands

Replace string:

In a log file there are the statements to alter tables, then you want to build the statement to truncate these tables.

grep "alter table " Config.log | awk '{print $3}' | sort | uniq | sed s/^/"db2 \"truncate table SCHEMA."/ | sed s/$/" immediate\""/