zOs/SQL/CATSYN

select 'set current sqlid = ''' || strip(creator) || '''; '
        || 'drop synonym ' || strip(name)
        || '; --> ' || strip(tbcreator) || '.' || strip(tbname)
        || ' ' || char(createdts)
    from sysibm.syssynonyms
    where tbName like 'TAV%'
union all select 'set current sqlid = ''S100447'';'
    from sysibm.sysDummy1
union all select 'drop alias ' || strip(creator) || '.' || strip(name)
        || '; --> ' || strip(tbcreator) || '.' || strip(tbname)
        || ' ' || char(createdts)
    from sysibm.sysTables
    where type = 'A'
        and tbName like 'TAV%'  and creator not like 'OA1%'
union all select 'drop view ' || strip(creator) || '.' || strip(name)
        || '; --' || char(createdts)
    from sysibm.sysTables
    where type = 'V'
        and name like 'V11'
$#out                                              20120418 10:05:00
COL1
set current sqlid = 'S100447';
1 rows fetched: select 'set current sqlid = ''' || strip(creator) || '''; ...
$#out                                              20120418 10:04:38
sqlCode 0: set current sqlid = 'A467700'
sqlCode 0: drop synonym TAV001A1