Cacher is the code snippet organizer for pro developers

for TABELA in `db2 connect to DBALIAS >  /dev/null; db2 list tables for all | grep LOCK | awk '{print $1}'`;do db2 drop table $TABELA; done
db2 "select tabname from syscat.tables where tabname like '%N1%'" | sed "s/ *$/ /g"