Re: Too narrow column display width using ij.

[Satheesh Bandaram]

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 [EMAIL PROTECTED] wrote: 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... <SQL>========================== ij> 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'); =============================== <Result>======================= COLUMNNAME |COLUMNDATATYPE ------------------------------------ MY_COUNTER |INTEGER NOT NU& =============================== (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! http://pr.mail.yahoo.co.jp/yells/