{ TABLE "informix".test1 row size = 20 number of columns = 2 index size = 9 } create table "informix".test1 ( i integer, n decimal(30,10), primary key (i) ); revoke all on "informix".test1 from "public";
{ TABLE "informix".test2 row size = 14 number of columns = 2 index size = 9 } create table "informix".test2 ( i integer, n decimal(16), primary key (i) ); revoke all on "informix".test2 from "public";
informix ids 9.4
Date: 2006-06-18 12:50 pm (UTC)isql -qr decimal.sql
Database selected.
Table created.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
i n
1 1.23456789012e19
2 1.23456789012e19
3 1.23456789012e19
4 1.23456789012e19
4 row(s) retrieved.
Table created.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
i n
3 2.10000000000000
4 2.20000000000000
5 2.30000000000000
6 2.40000000000000
7 2.50000000000000
8 2.60000000000000
9 2.70000000000000
10 2.80000000000000
11 2.90000000000000
12 0.12345678901235
13 1.23456789012e69
14 0.12345678901235
15 1.23456789012e69
13 row(s) retrieved.
-- dbschema
{ TABLE "informix".test1 row size = 20 number of columns = 2 index size = 9 }
create table "informix".test1
(
i integer,
n decimal(30,10),
primary key (i)
);
revoke all on "informix".test1 from "public";
{ TABLE "informix".test2 row size = 14 number of columns = 2 index size = 9 }
create table "informix".test2
(
i integer,
n decimal(16),
primary key (i)
);
revoke all on "informix".test2 from "public";