Guru,

I need the FREE column to be character but don't want the leading zero.
What is the best way to do it in SQL?

db2 "select substr (tablespace_name, 1, 18) as tbsname, char (dec
((float (free_pages) / float(total_pages) * 100), 8, 2)) as "Free" from
TABLESPACE_CFG


TBSNAME FREE
------------------ ----------
BC_0201_DT 000036.47
BC_0201_IX 000027.39
BC_0202_DT 000013.84
BC_0202_IX 000024.52
BC_0301_DT 000011.10
BC_0301_IX 000021.96
BC_0302_DT 000012.09
BC_0302_IX 000022.26


Thanks.

Zhong
FCSO DBA



First Coast Service Options, Inc., and its affiliates are not responsible for errors or omissions in the transmission of this e-mail message. Any personal comments made in this e-mail do not reflect the views of First Coast Service Options, Inc., or its affiliates. The information contained in this document may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. This document may also contain material that is privileged or protected from disclosure under applicable law. If you are not the intended recipient or the individual responsible for delivery to the intended recipient, please (1) be advised that any use, dissemination, forwarding, or copying of this document IS STRICTLY PROHIBITED; and (2) notify sender immediately by telephone and destroy the document. Thank you.


DB2 & UDB email list listserv db2-l LazyDBA home page