如:
如果是oracle就可以col TBSPACE format a20
那么在DB2中如何操作呢?
db2 => select tbspace,bufferpoolid from syscat.tablespaces
TBSPACE BUFFERPOOLID
-------------------------------------------------------------------------------------------------------------------------------- ------------
SYSCATSPACE 1
TEMPSPACE1 1
USERSPACE1 1
SYSTOOLSPACE 1
SYSTOOLSTMPSPACE 1
USERSPACE3 1
TEMP 1
USER_TEMP 1
TBS 2
上面这些显示很乱,有什么办法可以格式整齐一点,如下面这样的情况:
http://www.116gouwu.comSELECT TBSPACE, BUFFERPOOLID FROM SYSCAT.TABLESPACES TBSPACE BUFFERPOOLID ------------------ ------------ SYSCATSPACE 1 TEMPSPACE1 1 USERSPACE1 1
3 record(s) selected. |