db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Too narrow column display width using ij.
Date Sat, 24 Sep 2005 00:38:48 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
If you add a cast to 'columndatatype', you can achieve the
'minimumDisplayWidth' like functionality.<br>
<br>
ij&gt;&nbsp; select columnname, <b>cast(columndatatype as char(20))</b>
from sys.syscolumns where<br>
referenceid in (select tableid from sys.systables a,<br>
sys.sysschemas b where a.schemaid=b.schemaid and b.schemaname='APP'<br>
and a.tablename='MYTABLE');<br>
COLUMNNAME<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|2<br>
--------------------------------------------------------------------------------<br>
---------------------------------------------------------------------<br>
MY_COUNTER<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|INTEGER NOT NULL<br>
<br>
1 row selected<br>
<br>
Satheesh<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:wolfgang127us@yahoo.co.jp">wolfgang127us@yahoo.co.jp</a>
wrote:<br>
<blockquote cite="mid20050923204709.B721.WOLFGANG127US@yahoo.co.jp"
 type="cite">
  <pre wrap="">Hi gurus,

I displayed the description of a table (MYTABLE)
using the following sql with ij, but the second column's display
width was too narrow to see...
&lt;SQL&gt;==========================
ij&gt; select columnname, columndatatype 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'); 
===============================

&lt;Result&gt;=======================
COLUMNNAME          |COLUMNDATATYPE 
------------------------------------
MY_COUNTER          |INTEGER NOT NU&amp;
===============================
(I made the MYTABLE talbe using "create table MYTABLE (my_counter int
generated always as identity (start with 1));".)

How can I expand the display width of the second column ?

I thought ij have a minimumdisplaywidth option since it has the
maximumdisplaywidth, but actually it doesn't have the minimumdisplaywidth
option. hm...

Regards,
wolfgang



__________________________________
 For All Sports Fans!
 <a class="moz-txt-link-freetext" href="http://pr.mail.yahoo.co.jp/yells/">http://pr.mail.yahoo.co.jp/yells/</a>


  </pre>
</blockquote>
</body>
</html>

Mime
View raw message