db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wolfgang12...@yahoo.co.jp
Subject Re: Too narrow column display width using ij.
Date Sat, 24 Sep 2005 02:51:17 GMT
Hi Satheesh,

Thank you for your quick response.


It works pretty good. :)



wolfgang

>   
> If you add a cast to 'columndatatype', you can achieve the'minimumDisplayWidth' like
functionality.
> 
> ij>  select columnname, cast(columndatatype as char(20))from sys.syscolumns where
> referenceid in (select tableid from sys.systables a,
> sys.sysschemas b where a.schemaid=b.schemaid and b.schemaname='APP'
> and a.tablename='MYTABLE');
> COLUMNNAME
>                                                 |2
> --------------------------------------------------------------------------------
> ---------------------------------------------------------------------
> MY_COUNTER
>                                                 |INTEGER NOT NULL
> 
> 1 row selected
> 
> Satheesh

__________________________________
 For All Sports Fans!
 http://pr.mail.yahoo.co.jp/yells/


Mime
View raw message