Re: output of dbaccess/isql

Succinctly, no. DB-Access is not a reporting tool, and if you need accurate control over formats, then you should be using something other than DB-Access. Often I'd recommend SQLCMD, but not this time -- it doesn't provide you with any control over the output format. What it does try to do, though, is report all the decimal places for the values it is given. Which version of DB-Access are you using? The more recent versions have fixed the output of decimal values so that you don't get just 2 decimal places regardless of precision etc. Dirk Niemeier wrote: > is it possible to manipulate the output-style of numeric fields in > dbaccess/isql ? > > Example for decimal: > > create table test ( > id int, > decfield decimal(5,2) > );> > select decfield / 1000 from test; > > The output is 2 numbers for mantissa. But is it possible to get more ? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>