output of dbaccess/isql
Dirk Niemeier asked how to show more digits for a computed decimal value in dbaccess/isql, where only two decimal places appeared. Reinhard Habichtsberg suggested formatting with the ACE report writer. Tim Gilbert recalled the DBFLTMASK environment variable for float columns. Dirk reported that setting DBFLTMASK=-1 worked. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,
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 ?
TIA
Dirk
On Tue, 30 Nov 1999 11:35:49 +0100, Dirk Niemeier
<dirk.niemeier@stueken.de> wrote:
>Hi,
>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 ?
>
>TIA
> Dirk
>
Hi Dirk,
if you use isql you can format the output with the ACE report tool.
HTH,
Reinhard
I don't use decimal columns, but with float columns
you can:
setenv DBFLTMASK <# of digits of precision>
i.e. setenv DBFLTMASK 10
I'm doing this from memory, but I think the environment variable is
correct and that I found it in some release notes for either isql or
dbaccess.
Tim Gilbert
Dirk Niemeier wrote:
>
> Hi,
> 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 ?
>
> TIA
> Dirk
Hi all,
thanks for help. The DBFLTMASK=-1 works well.
Dirk
Tim Gilbert schrieb:
> I don't use decimal columns, but with float columns
> you can:
>
> setenv DBFLTMASK <# of digits of precision>
>
> i.e. setenv DBFLTMASK 10
>
> I'm doing this from memory, but I think the environment variable is
> correct and that I found it in some release notes for either isql or
> dbaccess.
>
> Tim Gilbert
>
> Dirk Niemeier wrote:
> >
> > Hi,
> > 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 ?
> >
> > TIA
> > Dirk