zOs/SQL/SU03DROP

select 'drop tablespace '
       || strip(dbName) || '.' || strip(tsName)
       || '; commit; -- '
       || strip(creator) || '.' || strip(name)
     from sysibm.sysTables
     where type not in ('A', 'V')
         and dbName = 'SU03A1P'
$#out                                              20160729 15:42:52
COL1
drop tablespace SU03A1P.SSUXCMD; commit; -- OA1P.TSUXCMD
drop tablespace SU03A1P.SSUXCMT; commit; -- OA1P.TSUXCMT
drop tablespace SU03A1P.SSUXCX1; commit; -- OA1P.TSUXCX1
drop tablespace SU03A1P.SSUXCX2; commit; -- OA1P.TSUXCX2
drop tablespace SU03A1P.SSUXCX3; commit; -- OA1P.TSUXCX3
drop tablespace SU03A1P.SSUXCX4; commit; -- OA1P.TSUXCX4
drop tablespace SU03A1P.SSUXCX5; commit; -- OA1P.TSUXCX5
drop tablespace SU03A1P.SSUXCXB; commit; -- OA1P.TSUXCXB
drop tablespace SU03A1P.SSUXCXD; commit; -- OA1P.TSUXCXD
drop tablespace SU03A1P.SSUXCXG; commit; -- OA1P.TSUXCXG
drop tablespace SU03A1P.SSUXCXJ; commit; -- OA1P.TSUXCXJ
drop tablespace SU03A1P.SSUXCXN; commit; -- OA1P.TSUXCXN
drop tablespace SU03A1P.SSUXCXP; commit; -- OA1P.TSUXCXP
drop tablespace SU03A1P.SSUXCXR; commit; -- OA1P.TSUXCXR
drop tablespace SU03A1P.SSUXCXS; commit; -- OA1P.TSUXCXS
drop tablespace SU03A1P.SSUXCXT; commit; -- OA1P.TSUXCXT
drop tablespace SU03A1P.SSUXCXV; commit; -- OA1P.TSUXCXV
drop tablespace SU03A1P.SSUXD21; commit; -- OA1P.TSUXD21
drop tablespace SU03A1P.SSUXD22; commit; -- OA1P.TSUXD22
drop tablespace SU03A1P.SSUXD23; commit; -- OA1P.TSUXD23
drop tablespace SU03A1P.SSUXD24; commit; -- OA1P.TSUXD24
drop tablespace SU03A1P.SSUXD25; commit; -- OA1P.TSUXD25
drop tablespace SU03A1P.SSUXD26; commit; -- OA1P.TSUXD26
drop tablespace SU03A1P.SSUXD27; commit; -- OA1P.TSUXD27
drop tablespace SU03A1P.SSUXD28; commit; -- OA1P.TSUXD28
drop tablespace SU03A1P.SSUXD29; commit; -- OA1P.TSUXD29
drop tablespace SU03A1P.SSUXD2A; commit; -- OA1P.TSUXD2A
drop tablespace SU03A1P.SSUXD2B; commit; -- OA1P.TSUXD2B
drop tablespace SU03A1P.SSUXD2C; commit; -- OA1P.TSUXD2C
drop tablespace SU03A1P.SSUXD2D; commit; -- OA1P.TSUXD2D
drop tablespace SU03A1P.SSUXD2F; commit; -- OA1P.TSUXD2F
drop tablespace SU03A1P.SSUXD2G; commit; -- OA1P.TSUXD2G
drop tablespace SU03A1P.SSUXD2I; commit; -- OA1P.TSUXD2I
drop tablespace SU03A1P.SSUXD2P; commit; -- OA1P.TSUXD2P
drop tablespace SU03A1P.SSUXD2R; commit; -- OA1P.TSUXD2R
drop tablespace SU03A1P.SSUXD2S; commit; -- OA1P.TSUXD2S
drop tablespace SU03A1P.SSUXD2U; commit; -- OA1P.TSUXD2U
drop tablespace SU03A1P.SSUXD2V; commit; -- OA1P.TSUXD2V
drop tablespace SU03A1P.SSUXDDF; commit; -- OA1P.TSUXDDF
drop tablespace SU03A1P.SSUXDDH; commit; -- OA1P.TSUXDDH
drop tablespace SU03A1P.SSUXDDP; commit; -- OA1P.TSUXDDP
drop tablespace SU03A1P.SSUXEXE; commit; -- OA1P.TSUXEXE
drop tablespace SU03A1P.SSUXFLJ; commit; -- OA1P.TSUXFLJ
drop tablespace SU03A1P.SSUXFLO; commit; -- OA1P.TSUXFLO
drop tablespace SU03A1P.SSUXIFS; commit; -- OA1P.TSUXIFS
drop tablespace SU03A1P.SSUXIM0; commit; -- OA1P.TSUXIM0
drop tablespace SU03A1P.SSUXIM1; commit; -- OA1P.TSUXIM1
drop tablespace SU03A1P.SSUXIM2; commit; -- OA1P.TSUXIM2
drop tablespace SU03A1P.SSUXIM3; commit; -- OA1P.TSUXIM3
drop tablespace SU03A1P.SSUXIM4; commit; -- OA1P.TSUXIM4
drop tablespace SU03A1P.SSUXIM5; commit; -- OA1P.TSUXIM5
drop tablespace SU03A1P.SSUXIM6; commit; -- OA1P.TSUXIM6
drop tablespace SU03A1P.SSUXIM7; commit; -- OA1P.TSUXIM7
drop tablespace SU03A1P.SSUXIMD; commit; -- OA1P.TSUXIMD
drop tablespace SU03A1P.SSUXIMJ; commit; -- OA1P.TSUXIMJ
drop tablespace SU03A1P.SSUXIMP; commit; -- OA1P.TSUXIMP
drop tablespace SU03A1P.SSUXIMT; commit; -- OA1P.TSUXIMT
drop tablespace SU03A1P.SSUXJES; commit; -- OA1P.TSUXJES
drop tablespace SU03A1P.SSUXJLB; commit; -- OA1P.TSUXJLB
drop tablespace SU03A1P.SSUXJLS; commit; -- OA1P.TSUXJLS
drop tablespace SU03A1P.SSUXJOB; commit; -- OA1P.TSUXJOB
drop tablespace SU03A1P.SSUXOUT; commit; -- OA1P.TSUXOUT
drop tablespace SU03A1P.SSUXPRC; commit; -- OA1P.TSUXPRC
drop tablespace SU03A1P.SSUXSET; commit; -- OA1P.TSUXSET
drop tablespace SU03A1P.SSUXSIN; commit; -- OA1P.TSUXSIN
drop tablespace SU03A1P.SSUXSMD; commit; -- OA1P.TSUXSMD
drop tablespace SU03A1P.SSUXSMF; commit; -- OA1P.TSUXSMF
drop tablespace SU03A1P.SSUXSUB; commit; -- OA1P.TSUXSUB
68 rows fetched: select 'drop tablespace ' || strip(dbName) || '.' || stri...
$#out                                              20160729 15:38:40