Re: output of dbaccess/isql
I don't know about newer versions, but with OnLine 5.10.UC1, and the
DBFLTMASK environmental variable set to "-1", I get the following:
select id, decfield, decfield / 1000 from test;
id decfield (expression)
1 100.10 0.1001
2 200.20 0.2002
3 300.30 0.3003
4 444.44 0.44444
I believe the DBFLTMASK setting is the key.
Jonathan Leffler wrote:
>
> 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 ?
--
Colin McGrath cmm@trac3000.ueci.com
Raytheon Constructors Inc. (215) 422-4144
Philadelphia, PA, USA
Any opinions I state are my own and not necessarily those of my employer