系统集成数据库
DB2如何像Oracle那样在查询时可以用col格式化结果
如：
如果是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.com
如果是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.com
| SELECT TBSPACE, BUFFERPOOLID FROM SYSCAT.TABLESPACES TBSPACE BUFFERPOOLID ------------------ ------------ SYSCATSPACE 1 TEMPSPACE1 1 USERSPACE1 1 3 record(s) selected. |
4同行回答
db2 "select cast(tbspace as char(25)),cast(bufferpoolid as char(4)) from syscat.tablespaces", then ...daolin2005 发表于 2010-10-28 17:05
这应该是目前最好的办法了，呵呵。db2 "select cast(tbspace as char(25)),cast(bufferpoolid as char(4)) from syscat.tablespaces"
, then ...
daolin2005 发表于 2010-10-28 17:05
浏览906
Make sure the Number you casted is bigger than the longest record in this column. otherwise,
the Record will be truncated.收起
the Record will be truncated.收起
浏览855
db2 "select cast(tbspace as char(25)),cast(bufferpoolid as char(4)) from syscat.tablespaces"
, then it will be print out as short.收起
, then it will be print out as short.收起
浏览840