Hi, Steve I have a "slack" answer. Those widths are the result of some castings DB2 does to be able to display the data, convert it toString or something similar. Please try doing an explicit casting on a column to see what happens. I remember to have done it long time ago. Good luck -- Juan Lanus TECNOSOL [EMAIL PROTECTED] wrote: > I have noticed when running queries using the Command Line Processor that > there doesn't seem to be any relationship between the width of a column in > the database and the display width that the CLP uses. For example, in the > query below: > > db2 "select schemaname, owner from syscat.schemata order by schemaname" > > one would expect that the two columns returned each would be eight > characters wide, plus perhaps a couple of extra columns thrown in for some > spacing. (Both "schemaname" and "owner" are defined as Char(8).) However, > the actual column width returned is 128 characters wide for each column. > The only thing requiring such a huge width is the line of hyphens (-) under > the column names at the start of the output. Each column gets a 128 > character string of hyphens to separate it from the returned data values. > I have pored over the manuals looking for something that will let me > control this, but I haven't found anything yet. The reason I want to > control it is that it renders output almost unreadable because of all the > resulting line-wrapping on the terminal. Doe anyone have an answer for > this? > > TIA. > > Steve Westfall > Equifax, Inc. > > > > This message contains information from Equifax, Inc. which may be > confidential and privileged. If you are not an intended recipient, please > refrain from any disclosure, copying, distribution or use of this > information and note that such actions are prohibited. If you have > received this transmission in error, please notify by e:mail > [EMAIL PROTECTED] > > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod > > > > ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
